CursorSchema Property

Specifies the structure of the cursor associated with a CursorAdapter object. Read/write at design time and run time.

CursorSchema is essentially the portion "between the parentheses" of the SQL CREATE TABLE and CREATE CURSOR commands. In Visual FoxPro 8.0, you can use CursorSchema to define an XML data source. In Visual FoxPro 9.0, you can use CursorSchema to define XML, Native, ADO and ODBC data sources.

NoteNote

In Visual FoxPro 9.0, DEFAULT values and table and field level CHECK constraints are supported for XML, Native, ADO and ODBC data sources. In Visual FoxPro 8.0, DEFAULT values and table and field level CHECK constraints are only supported for an XML data source. For the DEFAULT values and CHECK constraints to be applied to a cursor, call the CursorFill method with the lUseSchema parameter set to True (.T.).

Visual FoxPro uses the CursorSchema property at design time to determine the structure of the cursor to place on the surface of the Data Environment Designer. Visual FoxPro uses CursorSchema at run time if specified by the CursorFill method.

NoteNote

You must make sure that CursorSchema matches and maps to the data source columns in an acceptable manner.

CursorAdapter.CursorSchema [ = cList ]

Expand imageReturn Value

Expand imageRemarks

Expand imageSee Also


© , 1996-2020 • Updated: 11/10/20
Comment or report problem with topic