tdbc::tokenize(n) Tcl Database Connectivity tdbc::tokenize(n)______________________________________________________________________________NAME
tdbc::tokenize - TDBC SQL tokenizer
SYNOPSIS
package require tdbc 1.0
tdbc::tokenize string
_________________________________________________________________DESCRIPTION
As a convenience to database drivers, Tcl Database Connectivity (TDBC)
provides a command to break SQL code apart into tokens so that bound
variables can readily be identified and substituted.
The tdbc::tokenize command accepts as its parameter a string that is
expected to contain one or more SQL statements. It returns a list of
substrings; concatenating these substrings together will yield the
original string. Each substring is one of the following:
[1] A bound variable, which begins with one of the characters ':',
'@', or '$'. The remainder of the string is the variable name
and will consist of alphanumeric characters and underscores.
(The leading character will be be non-numeric.)
[2] A semicolon that separates two SQL statements.
[3] Something else in a SQL statement. The tokenizer does not
attempt to parse SQL; it merely identifies bound variables (dis‐
tinguishing them from similar strings appearing inside quotes or
comments) and statement delimiters.
SEE ALSOtdbc(n), tdbc::connection(n), tdbc::statement(n), tdbc::resultset(n)KEYWORDS
TDBC, SQL, database, tokenize
COPYRIGHT
Copyright (c) 2008 by Kevin B. Kenny.
Tcl 8.6 tdbc::tokenize(n)
