tdbc::tokenize

Section: Tcl Database Connectivity (n)
Updated: 8.6
Page Index



 

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 (distinguishing them from similar strings appearing inside quotes or comments) and statement delimiters.
 

SEE ALSO

tdbc(n), tdbc::connection(n), tdbc::statement(n), tdbc::resultset(n)  

KEYWORDS

TDBC, SQL, database, tokenize  

COPYRIGHT

Copyright (c) 2008 by Kevin B. Kenny.


 

Index

NAME
SYNOPSIS
DESCRIPTION
SEE ALSO
KEYWORDS
COPYRIGHT