SQL Pass Through Foundation Class

Category Data Query
Default Catalog Visual FoxPro Catalog\Foundation Classes\Data Query
Class _execsp
Base Class Custom
Class Library _dataquery.vcx
Parent Class _custom

Remarks

This class is used for SQL Pass Through and makes it possible for you to execute stored procedures on a host database such as Microsoft SQL Server.

To use, drop the class on a project or form or, from the Component Gallery Item Shortcut Menu, select Add to Project or Add to Form. When you drop the class on a form, Visual FoxPro places the class icon on the form. You can then specify the appropriate property values and provide any necessary input and output objects. When you drop the class on a project, you can choose between adding the class or creating a subclass.

You need to add code that specifies parameter and connection information so the class can return a result set in a cursor.

Properties, Events, Methods Description
LUseSQLSyntax Specifies whether to use Server Exec
syntax.
Default: .F.
DoSQL method Runs a SQL Pass Through statement.
Syntax: DoSQL( )
Return: none
Arguments: none
GetSQL method Gets results from the SQL Pass Through
statement.
Syntax: GetSQL( )
Return: none
Arguments: none
aParams[1,0] property Internal to the class.
cCursorName property Internal to the class.
cSpname property Internal to the class.
cSQL property Internal to the class.
hConnectHandle property Internal to the class.
ProcessError method Internal to the class.
SetParams method Internal to the class.
SetSQL method Internal to the class.

See Also

Guidelines for Using Visual FoxPro Foundation Classes | Visual FoxPro Foundation Classes A-Z | Visual FoxPro Foundation Classes