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 Class Samples