GetRow

GetRow(flags, RowName, table, fields, GridWhere, related, related_id, orderby)

Returns a dictionary object containing a single row of fields.

The object will be called {RowName}Row

Parameters

Flags

# to return DISTINCT records
% to return CURRENT records in Aurora_Data
* to return ALL records in table and *NOT* join Aurora_Data
! in front of related table name denotes reverse relationship
$ join all related tables
Optional
RowName Alphanumeric variable name Required
Table Table name Required
Fields Comma separated list of fields Required
GridWhere Valid SQL WHERE expression Optional
Related Table name Optional
Related _ID ID of related item - prefix by "!" for reverse relationship Optional
OrderBy SQL Order By expression Optional
comments powered by Disqus