SQL Pass Through

See Also

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 allows 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.

See Guidelines for Using Visual FoxPro Foundation Classes for more information on using foundation classes.

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.