X# Runtime and VO SDK Reference
X# Runtime and SDK Reference
XSharp.VO.SDK Namespace
SQLSelect Class (Typed)
SQLSelect Methods (Typed)
SQLSelect.AddDateVal Method (Typed)
SQLSelect.AddTimeString Method (Typed)
SQLSelect.Append Method (Typed)
SQLSelect.AppendRow Method (Typed)
SQLSelect.BindColumn Method (Typed)
SQLSelect.Close Method (Typed)
SQLSelect.Column Method (Typed)
SQLSelect.ColumnAttributes Method (Typed)
SQLSelect.Commit Method (Typed)
SQLSelect.DataField Method (Typed)
SQLSelect.Delete Method (Typed)
SQLSelect.DirectSkip Method (Typed)
SQLSelect.Error Method (Typed)
SQLSelect.Execute Method (Typed)
SQLSelect.ExtendedFetch Method (Typed)
SQLSelect.Fetch Method (Typed)
SQLSelect.FieldGet Method (Typed)
SQLSelect.FieldGetFormatted Method (Typed)
SQLSelect.FieldHyperLabel Method (Typed)
SQLSelect.FieldInfo Method (Typed)
SQLSelect.FieldName Method (Typed)
SQLSelect.FieldPos Method (Typed)
SQLSelect.FieldPut Method (Typed)
SQLSelect.FieldSpec Method (Typed)
SQLSelect.FieldStatus Method (Typed)
SQLSelect.FieldSym Method (Typed)
SQLSelect.FieldValidate Method (Typed)
SQLSelect.FindTableName Method (Typed)
SQLSelect.FLock Method (Typed)
SQLSelect.FreeStmt Method (Typed)
SQLSelect.GetData Method (Typed)
SQLSelect.GetdateVal Method (Typed)
SQLSelect.GetLookupTable Method (Typed)
SQLSelect.GetStatementOption Method (Typed)
SQLSelect.GetTimeStamp Method (Typed)
SQLSelect.GetTimeString Method (Typed)
SQLSelect.GoBottom Method (Typed)
SQLSelect.GoTo Method (Typed)
SQLSelect.GoTop Method (Typed)
SQLSelect.NoIVarGet Method (Typed)
SQLSelect.NoIVarPut Method (Typed)
SQLSelect.Notify Method (Typed)
SQLSelect.NumResultCols Method (Typed)
SQLSelect.PreExecute Method (Typed)
SQLSelect.Prepare Method (Typed)
SQLSelect.Refresh Method (Typed)
SQLSelect.RejectChanges Method (Typed)
SQLSelect.Requery Method (Typed)
SQLSelect.ReReadRow Method (Typed)
SQLSelect.ResetCursor Method (Typed)
SQLSelect.ResetNotification Method (Typed)
SQLSelect.RLock Method (Typed)
SQLSelect.RLockVerify Method (Typed)
SQLSelect.Rollback Method (Typed)
SQLSelect.SetColumnAttributes Method (Typed)
SQLSelect.SetDataField Method (Typed)
SQLSelect.SetPos Method (Typed)
SQLSelect.SetPrimaryKey Method (Typed)
SQLSelect.SetStatementOption Method (Typed)
SQLSelect.SetTimeStamp Method (Typed)
SQLSelect.ShowSQLError Method (Typed)
SQLSelect.Skip Method (Typed)
SQLSelect.SuspendNotification Method (Typed)
SQLSelect.UnLock Method (Typed)
SQLSelect.Update Method
SQLSelect.UpdateCursor Method (Typed)
SQLSelect.UpdateKey Method (Typed)
SQLSelect.UpdateVal Method (Typed)
Click or drag to resize

SQLSelect.PreExecute Method (Typed)

X#
Return the SQL command that is generated by X#.

Namespace:  XSharp.VO.SDK
Assembly:  XSharp.VOSQLClasses (in XSharp.VOSQLClasses.dll) Version: 2.21
Syntax
Copy
 VIRTUAL METHOD PreExecute(
	cSQLString AS STRING
) AS STRING
Request Example View Source

Parameters

cSQLString
Type: String
A string containing the SQL statement which will be passed to the SQL driver.

Return Value

Type: String
A possibly updated SQL string that will be passed to the SQL driver.
Remarks
This method is a callback method that is passed to the SQL command generated by X# for the purpose of inspection and optional modification, immediately prior to the command being passed to ODBC. It must return SQL statement text.
Examples
The following example demonstrates the use of the SQLSelect:PreExecute() method:
X#
Copy
1METHOD PreExecute(cSQLString) CLASS SubclassOfSQLSelect
2? sSQLString    //View all the SQL can modify it here, too
3RETURN cSQLString
See Also