Skip to main content

Fetch Row By ID (LCC.db.get)

Signature​

row, err = LCC.db.get(name, id, timeout?)

Parameters​

  • name
    String. Table name. Must be non-empty and no longer than 256 bytes.
  • id
    Number. Row id to retrieve. Must be an integer value greater than or equal to 1.
  • timeout
    Number, optional. Request timeout in seconds, default 60.

Returns​

  • row
    Table. Row that matches the id; nil when not found.
  • err
    String or nil. Returns 'not found' if the row is missing, 'unknown table' when the table does not exist.

Notes​

Retrieves a single row by id, typically for editing forms.
User columns are returned as strings, while id is returned as a number.
An id that is not an integer value greater than or equal to 1 triggers a Lua parameter validation error.

Example​

local row, err = LCC.db.get("tasks", 42)
if row then
    print("Task", row.Name, row.Status)
end