Function.ODBC.Connection!ConnectionName.OpenRecordsetRO

From GAB Help
Jump to: navigation, search

Opens a record set for read-only

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.