Microsoft KB Archive/113528

{| = New Features of FoxPro Version 2.6 Connectivity Kit =
 * width="100%"|

ID: Q113528

2.60   | 2.60 WINDOWS | MS-DOS kbinterop kbtool kbprg 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:

1. 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. 2. 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. 3. New function: DBVersion The DBVersion function returns the version of FPSQL. This function requires no parameters. 4. 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. 5. 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. Additional reference words: FoxDos FoxWin 2.60 FPSQL.PLB KBCategory: kbinterop kbtool kbprg KBSubcategory: FxtoolCk Keywords         : FxtoolCk Version          : 2.60    | 2.60 Platform         : MS-DOS WINDOWS
 * }