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 |