AfmRsOpen and AfmRsClose

Note: The RecordSet functions described in this section are obsolete and are included for backward-compatibility with older Overlay-style AutoLISP functions that have been ported to the Extension environment. It is recommended that newer Archibus Extension-based AutoLISP development use the WebService functions to access data from the database rather than these RecordSet functions. For examples of how older Overlay-style RecordSet functions can be used in the Archibus Extension environment, please see the ‘Examples of using Extension queries in place of Overlay queries’ section in the afm_samples.lsp file.

(AfmRsOpen)

Obsolete Usage:

setq rsId (AfmRsOpen "strsqlSelectStmt"))

Archibus Extension usage:

(setq rsId (AfmRsOpen (list tableName where fieldsToSelect))

Returns the integer ID of the recordset selected by the given statement, or returns nil if no such recordset could be opened.

(AfmRsClose rsId)

Closes the recordset with the given ID. Returns t on success.