QDM.ODBC.Criteria (1.0.0)

Published 2024-09-18 09:01:21 +02:00 by pascal

Set up this registry from the command line:

dotnet nuget add source --name pascal --username your_username --password your_token

To install the package using NuGet, run the following command:

dotnet add package --source pascal --version 1.0.0 QDM.ODBC.Criteria

For more information on the NuGet registry, see the documentation.

Library to access Criteria databases with ODBC

QDM.ODBC.Criteria

This tool is designed to make ODBC calls to the Prologue Criteria databases

Description

Library to access Prologue Criteria databases with ODBC
Specifically designed for Apache and Isabelle, from 2M-ITC
2M-ITC Patrick Lejeune
- Phone +32(0)23568680
- Mail info@2m-itc.be
- Site web www.2m-itc.be

Supported Operating Systems

Windows XP
Windows 7
Windows 8
Windows 10
Windows 11

Dependencies

Windows 32 bits
Must be compiled for x86

How to use

  string driver = "Prologue CRITERIA driver 32bit";
  string path = @"c:\criteria-data\";
  string company = "001";
  string codepage = "1252";
  string user = "user";
  string password = "password";

  string db = "C";
  int year = 2024;

  Criteria connection = new Criteria(driver, path, company, codepage, user, password, db, year);
  if (connection == null) throw new ArgumentNullException("connection cannot be null");

  connection.StartTransaction();
  int count = criteria.ExecuteScalar($"SELECT count(*) FROM C011C4CT");
  connection.StopTransaction();

See QDM.ODBC.Criteria.Test project for an example

Version History

1.0.0 Initial Release

Authors

Pascal Demets, for Quincaillerie De Berdt SA

Initial version

Details

NuGet

2024-09-18 09:01:21 +02:00

Pascal Demets

Project Site

Repository Site

7.8 KiB

Assets (2)

qdm.odbc.criteria.1.0.0.nupkg 7.0 KiB

qdm.odbc.criteria.nuspec 785 B

Versions (1) View all

1.0.0

2024-09-18