Function.ODBC.Connection!ConnectionName.OpenRecordsetRO
From GAB Help
Opens a record set for read-only
Contents
Syntax
Function.ODBC.Connection!connectionName.OpenRecordsetRO(RecordsetName, Table or SQL Statement)
Arguments
Table or SQL Statement
Example
Function.ODBC.Connection!testCon.OpenRecordsetRO(“rst”, “Select * from CUST_master where CustName = ‘“+”Global Shop Solutions”+”’”)
Remarks
- When working with a table that has a memo field, the recordset must be opened using OpenRecordsetRW not OpenRecordsetRO. Once you have gotten into the recordset records the memo field will need to be placed in a stored variable, other wise the memo field will disappear from you.
- Some data types, specifically LONGVARCHAR will only work if the recordset is opened as RW instead of RO.