GSP
Quick Navigator

Search Site

Unix VPS
A - Starter
B - Basic
C - Preferred
D - Commercial
MPS - Dedicated
Previous VPSs
* Sign Up! *

Support
Contact Us
Online Help
Handbooks
Domain Status
Man Pages

FAQ
Virtual Servers
Pricing
Billing
Technical

Network
Facilities
Connectivity
Topology Map

Miscellaneous
Server Agreement
Year 2038
Credits
 

USA Flag

 

 

Man Pages


Manual Reference Pages  -  TDBC_TOKENIZE (n)

NAME

tdbc::tokenize - TDBC SQL tokenizer

CONTENTS

SYNOPSIS

package require tdbc 1.0

tdbc::tokenize string


   








\L’|0u-1v’\l’75u+3n_’\L’0u+1v-0u’\l’|0u-1.5n_’



\L’|0u-1v’\L’0u+1v-0u’\l’|0u-1.5n_’





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.
Search for    or go to Top of page |  Section n |  Main Index


Tcl TDBC::TOKENIZE (n) 8.6

Powered by GSP Visit the GSP FreeBSD Man Page Interface.
Output converted with manServer 1.07.