ODBC

_ODBC_Login, ODBC_BindParam, ODBC_CloseDataSet, ODBC_ConnectDB, ODBC_DisconnectDB, ODBC_Execute, ODBC_GetField, ODBC_GetFieldByName, ODBC_GetFieldCount, ODBC_GetFieldIndex, ODBC_GetFieldName, ODBC_GetRowCount, ODBC_LoadBindParamFromFile, ODBC_NextRow, ODBC_OpenDataSet, ODBC_SaveFieldByNameToFile, ODBC_SetField, ODBC_SetFieldByName

ODBC_BindParam

Description

 ODBC_BindParam(
   int  Dataset,
   char *ParamName,
   char *Variable
);

This function is for internal purposes only.

Parameters

int Dataset

Dataset number.

char *ParamName

For internal purposes only.

char *Variable

Path to the database file.

ODBC_CloseDataSet

Description

 ODBC_CloseDataSet(
   int  Dataset
);

This function is for internal purposes only.

Parameters

int Dataset

Dataset number.

ODBC_ConnectDB

Description

 ODBC_ConnectDB(
   char *ConnectionString
);

This function is for internal purposes only.

Parameters

char *ConnectionString

Connection string. See MS ADO Connection String property: http://msdn2.microsoft.com/cs-cz/library/ms675810(en-us,VS.85).aspx

Example:

int rowCount, iDB, iDataSet;

char textField[256], filePath[256], fileOutputPath[256];

char output[80];

//iDB = ODBC_ConnectDB("Driver={PostgreSQL UNICODE(x64)};Server=127.0.0.1;Port=5432;Database=dbFile;Uid=postgres;Pwd=admin");

iDB = ODBC_ConnectDB("DRIVER={MySQL ODBC 8.0 ANSI Driver};SERVER=localhost;DATABASE=sakila;USER=root;PASSWORD=admin;OPTION=3;");

//iDataSet = ODBC_OpenDataSet(iDB,"SELECT COUNT(*) as count from sakila.actor" ,1);

//ODBC_Execute(iDataSet);

//ODBC_GetFieldByName(0,"count","rowCount");

sprintf(textField, "c:\\\\folder\\folder\\file","");

/*iDataSet = ODBC_OpenDataSet(0,"INSERT INTO sakila.files (name) VALUES (:filename)",0);

ODBC_BindParam(iDataSet,"filename","textField");

*/

sprintf(filePath, "c:\\\\Users\\user.name\\Documents\\input.zip","");

sprintf(fileOutputPath, "c:\\\\Users\\user.name\\Documents\\17output.zip","");

iDataSet = ODBC_OpenDataSet(iDB,"INSERT INTO sakila.files (name,data) VALUES (:filename, :data)",0);

ODBC_BindParam(iDataSet,"filename","textField");

ODBC_LoadBindParamFromFile(iDataSet,"data","filePath");

/*

iDataSet = ODBC_OpenDataSet(iDB,"UPDATE files SET data=:data WHERE id=27",0);

ODBC_LoadBindParamFromFile(iDataSet,"data","filePath");

*/

ODBC_Execute(iDataSet);

iDataSet = ODBC_OpenDataSet(iDB,"SELECT data FROM sakila.files order by id desc limit 0,1",1);

ODBC_Execute(iDataSet);

ODBC_SaveFieldByNameToFile(iDataSet,"data","fileOutputPath");

ODBC_DisconnectDB(iDB);

sprintf(output, "Row count: %d","rowCount");

Int_CreateTextWindow(output,0,RGB(0,0,128),RGB_WHITE,100);

Wait(2);

Int_CreateWindow(WND_1,"sprintf example",0, 0, 0, 450,560,"Header:\n

\n",1,1,0.00000,1,1,1,"Arial,B,8");

Int_SetWindowText(WND_1, output, TRUE);

Int_CloseTextWindow();

ODBC_DisconnectDB

Description

 ODBC_DisconnectDB(
   int  DBConnection
);

This function is for internal purposes only.

Parameters

int DBConnection

For internal purposes only.

ODBC_Execute

Description

 ODBC_Execute(
   int  Dataset
);

This function is for internal purposes only.

Parameters

int Dataset

Dataset number.

ODBC_GetField

Description

 ODBC_GetField(
   int  Dataset,
   int  FieldIndex,
   char *Variable
);

This function is for internal purposes only.

Parameters

int Dataset

Dataset number.

int FieldIndex

Field index.

char *Variable

Path to the database file.

ODBC_GetFieldByName

Description

 ODBC_GetFieldByName(
   int  Dataset,
   char *FieldName,
   char *Variable
);

This function is for internal purposes only.

Parameters

int Dataset

Dataset number.

char *FieldName

Name or unique name of the field.

char *Variable

Path to the database file.

ODBC_GetFieldCount

Description

 ODBC_GetFieldCount(
   int  Dataset
);

This function is for internal purposes only.

Parameters

int Dataset

Dataset number.

ODBC_GetFieldIndex

Description

 ODBC_GetFieldIndex(
   int  Dataset,
   char *FieldName
);

This function is for internal purposes only.

Parameters

int Dataset

Dataset number.

char *FieldName

Name or unique name of the field.

ODBC_GetFieldName

Description

 ODBC_GetFieldName(
   int  Dataset,
   int  FieldIndex,
   char *FieldName,
   int  MaxLen
);

This function is for internal purposes only.

Parameters

int Dataset

Dataset number.

int FieldIndex

Field index.

char *FieldName

Name or unique name of the field.

int MaxLen

ODBC_GetRowCount

Description

 ODBC_GetRowCount(
   int  Dataset
);

This function is for internal purposes only.

Parameters

int Dataset

Dataset number.

ODBC_LoadBindParamFromFile

Description

 ODBC_LoadBindParamFromFile(
   int  Dataset,
   char *FieldName,
   char *Variable
);

Binds a file to a text “:data” in SQL query.

Parameters

int Dataset

Place holder for the SQL query.

char *FieldName

Name or unique name of the field.

char *Variable

Path to the database file.

ODBC_NextRow

Description

 ODBC_NextRow(
   int  Dataset
);

This function is for internal purposes only.

Parameters

int Dataset

Dataset number.

ODBC_OpenDataSet

Description

 ODBC_OpenDataSet(
   int  DBConnection,
   char *SQL,
   int  Execute
);

This function is for internal purposes only.

Parameters

int DBConnection

For internal purposes only.

char *SQL

SQL database.

int Execute

Execute parameter.

ODBC_SaveFieldByNameToFile

Description

 ODBC_SaveFieldByNameToFile(
   int  Dataset,
   char *FieldName,
   char *Variable
);

Saves data from the “data” column to the address saved in the “fileOutputPath”.

Parameters

int Dataset

Dataset number.

char *FieldName

Name or unique name of the field.

char *Variable

Path to the database file.

ODBC_SetField

Description

 ODBC_SetField(
   int  Dataset,
   int  FieldIndex,
   char *Variable
);

This function is for internal purposes only.

Parameters

int Dataset

Dataset number.

int FieldIndex

Field index.

char *Variable

Path to the database file.

ODBC_SetFieldByName

Description

 ODBC_SetFieldByName(
   int  Dataset,
   char *FieldName,
   char *Variable
);

This function is for internal purposes only.

Parameters

int Dataset

Dataset number.

char *FieldName

Name or unique name of the field.

char *Variable

Path to the database file.

_ODBC_Login

Description

 _ODBC_Login(
   char *ODBC_UID,
   int  ODBC_UIDMaxLen,
   char *ODBC_PWD,
   int  ODBC_PWDMaxLen,
   char *ODBC_CON,
   int  ODBC_CONMaxLen
);

This function is for internal purposes only.

Parameters

char *ODBC_UID

For internal purposes only.

int ODBC_UIDMaxLen

For internal purposes only.

char *ODBC_PWD

For internal purposes only.

int ODBC_PWDMaxLen

For internal purposes only.

char *ODBC_CON

For internal purposes only.

int ODBC_CONMaxLen

For internal purposes only.

ODBC🔗

ODBC