New Features of FoxPro Version 2.6 Connectivity Kit

ID: Q113528 

2.60    | 2.60
WINDOWS | MS-DOS kbinterop kbtool kbprg

The information in this article applies to:

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

Last Reviewed: May 1, 1996