lib_dblib_get_record
Fetches every column of a database library table row by key, optionally using a specific key field, and returns values, footprint references, and lookup status.
Instructions
Every column of one row of a database library table.
The row is found by its key, the value in the table's key column
(key in a lib_dblib_search result; the column is
key_field in lib_dblib_info). The key is passed to the
database as a parameter, never as SQL text. lookup says how
the row was found: parameter when the database matched it,
scan when the parameterised query could not run and the
table was read and compared instead.
Args: library_path: Full path of the .DbLib file. table: A table the DbLib declares. key: The row's key value. key_field: Optional column to match instead of the DbLib's own key column; it must be a column of the table.
Returns:
{"library_path", "table", "key", "key_field",
"key_field_source", "lookup", "found", "match_count",
"rows_scanned", "scan_capped", "symbol_ref", "symbol_library",
"footprints": [{"ref", "library"}], "description",
"fields": {column: value}}. found False is an answer, not
an error: the key is not in that table. match_count above
1 means the key is not unique and the first row is shown.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| key | Yes | ||
| table | Yes | ||
| key_field | No | ||
| library_path | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||