This documentation is archived and is not being maintained.

SQL Pass Through Foundation Class

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.

Category Data Query

Default Catalog

Visual FoxPro Catalog\Foundation Classes\Data Query

Class

_execsp

Base Class

Custom

Class Library

_dataquery.vcx

Parent Class

_custom

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.

Show: