sql_stmt_t Derived Type

type, public :: sql_stmt_t


Components

Type Visibility Attributes Name Initial
integer, public :: kind = ST_NONE
character(len=SQR_NAME_LEN), public :: table = ''
type(column_t), public, allocatable :: coldefs(:)
character(len=SQR_NAME_LEN), public, allocatable :: names(:)
logical, public :: select_star = .false.

SELECT *

logical, public :: unique = .false.

CREATE UNIQUE INDEX

type(sql_lit_t), public, allocatable :: values(:,:)
logical, public :: insert_named = .false.

.true. if an explicit column list was given

character(len=SQR_NAME_LEN), public, allocatable :: set_cols(:)
type(sql_lit_t), public, allocatable :: set_vals(:)
logical, public :: has_where = .false.
type(sql_cond_group_t), public, allocatable :: where_groups(:)
logical, public :: has_order = .false.
character(len=SQR_NAME_LEN), public :: order_col = ''
logical, public :: order_desc = .false.
logical, public :: has_limit = .false.
integer, public :: limit_n = 0