Project Detail

Description

I need a 16 bit DLL to be developed that exposes a function as described below. The function will be called from FoxPro 2.6 for Windows

Let's assume the function name will be called ODBCExec.

The function will be defined as ODBCExec(DSNName, SQLCommand, OutputTable)

The objective of the function is to execute an SQL Command (passed in the SQLCommand parameter) on an SQL Database (eg. Microsoft SQL Server, Oracle, Pervasive SQL) and return a numeric value representing the number of rows affected by the command. The DSNName parameter is the name of a System DSN or User DSN defined in the Windows Data Sources (ODBC) from the Control Panel. The OutputTable parameter is the name of the output file (with fully qualified path) which will store the records produced/affected by the SQLCommand parameter. The Output Table must be a free table that is readable by FoxPro 2.6 for Windows. DBase III format should be sufficient. It may be necessary to note that the data type of ALL parameters passed to ODBCExec() is character string.

If you need further clarification please do not hesitate to ask.

Thanks in advance.