SMSQLScript component

This is a parser which allow to split loaded program on SQL-statements (commands) so you can control execution step-by-step.

For example, you have sql-script with table dump (a lot of INSERT-statements) which you want to apply to another database. You can't execute this sql-script in TQuery (or another similar component) because such components support one command execution only. In this case TSMSQLScript will divide script on simple statements and every statement can be processed by TQuery.

11K Last updated: October 25, 2002
D3-7, CB3-6 Freeware (with sources): sqlscript.zip

I wrote this component because SMExport suite allow to generate SQL-file with table dump. So TSMSQLScript component allow to apply this sql-file to your database.

But generally you can use this component just as simple parser.

Borland Software Scalabium Delphi tips

Copyright© 1998-2024, Scalabium Software. All rights reserved.
webmaster@scalabium.com