SetSQLPreview
method (DataWindows)
Description
Specifies the SQL statement for a DataWindow control or DataStore
that PowerBuilder is about to send to the database.
Applies to
|
DataWindow type |
Method applies to |
|---|---|
|
PowerBuilder |
DataWindow control, DataWindowChild object, DataStore |
Syntax
PowerBuilder
|
1 |
integer dwcontrol.SetSQLPreview ( string sqlsyntax ) |
|
Argument |
Description |
|---|---|
|
dwcontrol |
A reference to a DataWindow control, DataStore, or |
|
sqlsyntax |
A string whose value is valid SQL syntax for the |
Return value
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.
Usage
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.
When to call SetSQLPreview
Call this method only in the script for the SQLPreview
event.
Examples
This statement sets the current SQL string for the DataWindow
dw_1:
|
1 2 3 |
dw_1.SetSQLPreview( & "INSERT INTO billings VALUES(100, " + & String(Current_balance) + ")") |
See also