The information in this article applies to:
- Microsoft FoxPro for Windows, version 2.6
- Microsoft FoxPro for MS-DOS, version 2.6
SUMMARY
A new version of FPSQL, version 1.1, is included with the Connectivity Kit
for FoxPro version 2.6 for Windows and FoxPro version 2.6 for MS-DOS.
Version 2.6 of FPSQL includes new functionality that was not previously
available in version 1.0 of FPSQL, which was included with the Connectivity
Kit for FoxPro versions 2.5, 2.5a, and 2.5b. This article discusses the new
functionality added to version 2.6 of FPSQL.
MORE INFORMATION
The following new functionality was added to version 1.1 of FPSQL:
- User-defined constants can now be used for null values from the data
source.
The user can now define four types of null values:
"CharNull" size 30
"IntNull" size 20
"FloatNull" size 20
"DateNull" size 23
The values can be set or obtained using the option functions:
?DBSetOpt(handle, "FloatNull", "9999999.9999999")
?DBGetOpt(handle, "CharNull")
The default for all cases is an empty string; that is, nulls become
spaces in FoxPro.
- Multiple error messages are now supported.
FPSQL now returns a list of up to five error messages per connection.
These messages are displayed in the error message window and can be
obtained by calling DBError(). DBError() supports a fourth optional
parameter with values from 1 to 5. This optional parameter indicates
which message is requested from the list. Values outside this domain
default to the closest valid value. If the parameter is not specified,
the latest error message is returned. This behavior is consistent with
the behavior of version 1.0 of FPSQL.
- New function: DBVersion()
The DBVersion() function returns the version of FPSQL. This function
requires no parameters.
- Logical values in the data source will produce logical values in FoxPro.
If a query is performed against a table containing logical values, the
resulting table in FoxPro will also contain logical values (.T. and
.F.). In version 1.0 of FPSQL, when a query is performed against a table
containing logical values, the resulting table contains 0's or 1's
instead of logical T and F values.
- Dates are always converted to type character.
If a query is performed against a table containing values of type date,
the date value will be converted to type character.
|