# Environment Variables

PFODBCCOMMITTYPE=n

Selects the open-commit-type to use for high-level ODBC data sources, where:

0 = "SELECT * FROM tablename" (default)

Very slow on some data sources with very large files,

but uses nothing non-standard.

1 = "SELECT * FROM tablename WHERE id_field = nnn"

(Where "id_field" is the name of the ID field, and "nnn"

is a valid ID.)

Usually faster, but may be slower on some systems, as

filePro must first determine a valid ID to use.

2 = "SELECT TOP 1 FROM tablename"

Fastest version, but "TOP 1" is non-standard and not

supported everywhere. Will cause ODBC failure on those

DSNs that don't support it.

Version Ref: 1.0.14

PFLICFILE=path

Override the default license path for fileProODBC.

Set PFLICFILE = %pfprog%\fp\license\licfp.dat

Default path is %pfprog%\fp\lib\licfp.dat

Version Ref: ODBC 1.0.01

Handling errors

Currently, there really isn t much error handling ability included.

If a query fails, for example if no records are selected due to a WHERE clause, then @ODBC.handle["0"] will return zero, indicating no data is available. (Note that this is also true should you scroll to BOF or EOF, or position to a deleted record.)

The system array @ODBCERROR[] will contain the text of the most recent ODBC failure. Subscript 1 will contain the human-readable text of the error, and subscript 2 will contain the state information from which you can programmatically extract the error information. For more information, see

http://msdn.microsoft.com/library/en-us/vcmfc98/html/_mfc_cdbexception.3a3a.m_strstatenativeorigin.asp