From GAB Help
Jump to: navigation, search

Opens a record set for read-only


Function.ODBC.Connection!connectionName.OpenRecordsetRO(RecordsetName, Table or SQL Statement)


Table or SQL Statement


Function.ODBC.Connection!testCon.OpenRecordsetRO(“rst”, “Select * from CUST_master where CustName = ‘“+”Global Shop Solutions”+”’”)


  • 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.