Description
Use to create a connection to a database and display the SQL statement as a recordset.
Applicable Events
Post Extract, AnyApp Post Extract, Pre-Verify, Interactive, Verification Function Key (F-Key), Post-Verify
Syntax
object.OpenSQL strSql, strConn
Parameters
Object is a reference to the GridChoiceDialog object. For more information, see GridChoiceDialog Object (page GridChoiceDialog Object).
OpenSQL is the command.
strSQL is the SQL string you want to run which will return a recordset. For example, “Select * from Table”.
strConn is the connection string to the database.
Example