Specifies the SQL statement for a DataWindow control or DataStore that PowerBuilder is about to send to the database.
DataWindow type |
Method applies to |
|---|---|
PowerBuilder |
DataWindow control, DataWindowChild object, DataStore object |
Web ActiveX |
DataWindow control, DataWindowChild object |
integer dwcontrol.SetSQLPreview ( string sqlsyntax )
number dwcontrol.SetSQLPreview ( string sqlsyntax )
Argument |
Description |
|---|---|
dwcontrol |
A reference to a DataWindow control, DataStore, or child DataWindow |
sqlsyntax |
A string whose value is valid SQL syntax for the SQL statement that will be submitted to the database server |
Returns 1 if it succeeds and 0 if an error occurs. If any argument’s value is null, in PowerBuilder and JavaScript the method returns null.
Use SetSQLPreview to modify syntax before you update the database with changes in the DataWindow object.
To obtain the current SQL statement in the SQLPreview event, look at the sqlsyntax argument.
This statement sets the current SQL string for the DataWindow dw_1:
dw_1.SetSQLPreview( &
"INSERT INTO billings VALUES(100, " + &
String(Current_balance) + ")")
