ANNOUNCE: TimpleSQL 1.2
David Bigelow
HOMEPAGE: http://www.simplifiedlogic.com/TimpleSQL
What is NEW in 1.2?
-------------------
* Performance increase! Table Column Format Detection is now separate
from record insert and update routines. The procs are now more suited
for multiple-record manipulations using loops in Tcl.
* New Validation Proc! TimpleSQL can now compare your submission data
to the target table format requirements and validate it! It will
auto-correct BOOL/BIT formats and returns a descriptive error list so
you can better debug your submission data/values against the your
database table's requirements.
* TimpleSQL now properly addresses NULL values during SQL String
Generation (whoops)
* TimpleSQL's test application that comes with the package has been
updated to demonstrate the commands and validations.
Enjoy!
What is TimpleSQL?
------------------
TimpleSQL is a set of standalone procedures that helps the developer
either quickly prepare values, or execute submission, for INSERT or
UPDATE queries into a database using tclodbc.
TimpleSQL only requires a standard one-dimensional Tcl Array of your
input values and the target table name/array where you want to insert
or update your information. TimpleSQL gathers the target table's
column name/formatting requirements and, depending on your desired
action, will generate the proper SQL input string based on the
matching indexes in your Tcl Array. You can also Validate your
submission data relative to the target table before submission
(recommended).
TimpleSQL can either prepare and execute the submission of the
generated SQL, or you can use some lower level commands to help you
generate SQL structures (e.g., SELECT, INSERT, UPDATE) for hard coding
SQL in your own applications.
Using TimpleSQL, you can quickly database enable standard Tcl/TK and
CGI Applications for things like submission forms, polls, and shopping
carts.
Additional Info...
------------------
Please see the web site for additional examples and information. The
download has a stand alone Tcl/Tk test application, a MS-Access
Database, and a sample CGI program using cgi.tcl, tclobdc and
TimpleSQL.
Dave
[[Send Tcl/Tk announcements to tcl-an...@mitchell.org
Announcements archived at http://groups.yahoo.com/group/tcl_announce/
Send administrivia to tcl-announ...@mitchell.org
Tcl/Tk at http://tcl.tk/ ]]