Description
Attaches an existing recordset to the grid in the GridChoiceDialog.
Applicable Events
Post Extract, AnyApp Post Extract, Pre-Verify, Interactive, Verification Function Key (F-Key), Post-Verify
Syntax
object.DisplayRecordset (rsObject)
Parameters
Object is a reference to the GridChoiceDialog object. For more information, see GridChoiceDialog Object (page GridChoiceDialog Object).
DisplayRecordset is the command.
rsObject is the ADO Recordset object.
Example
' Build SQL Query
strFilter = "SELECT * FROM CUSTOMER WHERE STATE ='MI' ORDER BY NAME"
' Query database
Set objConn = CreateObject("ADODB.connection")
Set objRS = CreateObject("ADODB.Recordset")
objConn.ConnectionString = strDBConn
objRS.CursorType = 3 ' adUseClient
objConn.Open
objRS.Open strFilter, objConn
‘ Display Results
GridChoiceDialog.DisplayRecordset(objRS)
boolReturn = GridChoiceDialog.DoModal