SqlRow (ProcessCore) | ProcessCore

ProcessCore

SqlRow Module

Namespace: ProcessCore.SQL
Assembly: ProcessCore.dll

Helpers for extracting strongly-typed values from a SqlRow. All helpers raise with a fully qualified table.column reference when the lookup fails or the storage class is wrong.

Functions and values

Function or value	Description
`SqlRow.int table column row` Full Usage: `SqlRow.int table column row` Parameters: table : `string` - Logical table name (used in error messages). column : `string` - Column name to read. row : `SqlRow` - The row to read from. Returns: `int`	Reads a required `INTEGER` column from row. table : `string` Logical table name (used in error messages). column : `string` Column name to read. row : `SqlRow` The row to read from. Returns: `int`
`SqlRow.text table column row` Full Usage: `SqlRow.text table column row` Parameters: table : `string` - Logical table name (used in error messages). column : `string` - Column name to read. row : `SqlRow` - The row to read from. Returns: `string`	Reads a required `TEXT` column from row. table : `string` Logical table name (used in error messages). column : `string` Column name to read. row : `SqlRow` The row to read from. Returns: `string`
`SqlRow.textOption table column row` Full Usage: `SqlRow.textOption table column row` Parameters: table : `string` - Logical table name (used in error messages). column : `string` - Column name to read. row : `SqlRow` - The row to read from. Returns: `string option`	Reads an optional `TEXT` column, returning `None` for SQL `NULL`. table : `string` Logical table name (used in error messages). column : `string` Column name to read. row : `SqlRow` The row to read from. Returns: `string option`