SQLStatement Constructor (Typed)

Construct a SQLStatement object.

Namespace: XSharp.VO.SDK
Assembly: XSharp.VOSQLClasses (in XSharp.VOSQLClasses.dll) Version: 2.21

Syntax

 CONSTRUCTOR(
	cSQLStatement,
	oSQLConnection
) CLIPPER

[ClipperCallingConventionAttribute(new string[] { ... })]
public SQLStatement(
	Usual cSQLStatement = default,
	Usual oSQLConnection = default
)

Request Example View Source

Parameters

cSQLStatement (Optional): Type: Usual
The statement text.
oSQLConnection (Optional): Type: Usual
The SQL connection indicating where the table can be found. If not specified, the current default connection is used, if any; if none is defined, the system asks the end user to log on to a database.

Examples

The following example executes the SQL statement:

Copy

1oConn := SQLConnection{Source,UserId,Pswd}
2ACCEPT "Enter Simple SQL Statement:" TO cStatement
3oStmt := SQLStatement{cStatement,oConn}
4// Execute the statement...
5oStmt:Execute()

Reference

SQLStatement Class

XSharp.VO.SDK Namespace