Function.ODBC.Connection!ConnectionName.OpenLocalRecordset

From GAB Help
Jump to: navigation, search

These commands are similar in function to OpenRecordsetRO/RW, but they create local scope recordsets instead of global scope recordsets.

Syntax

Function.ODBC.Connection!Conname.OpenLocalRecordsetRO

Function.ODBC.Connection!Conname.OpenLocalRecordsetRW

Arguments

Example

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.