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.
Sample:
Set PFLICFILE = %pfprog%\fp\license\licfp.dat (right of the equal sign can be any path you wish but must contain the licfp.dat file)
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