Function.ODBC.Connection!ConnectionName.OpenRecordsetRW

From GAB Help
Jump to: navigation, search

Opens records for read and write

Syntax

Function.ODBC.Connection.OpenRecordsetRW(RecordsetName, Table or SQL Statement)

Arguments

Table or SQL Statement

Example

Function.ODBC.Connection!testCon.OpenRecordsetRW(“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.