Home  Contents

sql:declType

Sql Core4 Lua Commands

SYNOPSIS

name = query:declType(columnindex)

DESCRIPTION

Returns the declared type of a column in the the result set.

It can only return meaningful data if a SELECT statement has executed successfully.

The parameter columnindex indicates the column number within the result set, starting at 1.

The returned type is the text that was used when that column was created with CREATE TABLE or ALTER TABLE.

RETURN VALUE

Returns a string on success or nil if no data is available. No further error reporting.

SEE ALSO