On Tue, Mar 9, 2010 at 1:27 AM, Helen Borrie <[email protected]> wrote: > You seem to be looking at this in a strange way. The server itself does not > process scripts. A script component is merely a container for the > application execute a series of DSQL statements in sequence.
I understand that the server doesn't execute scripts, but only single SQL statements. I also examined the source code of the parts that interpret the scripts and convert them to everyday client requests. I also implemented the two SET commands in the script component for my own use to try what I suggested earlier. > The application connects just as usual, with the required connection charset > and dialect, and fires off these statements one by one. The smarter ones > provide optional exception handling. Most script components are written just > to ignore non-SQL sentences such as SET NAMES and SET SQLDIALECT, purposely > to enable you to execute a script that was created for use with isql. I'd be > surprised if FbScript doesn't provide this too. FbBatchExecution recognizes and throws exceptions on SET NAMES and SET SQL DIALECT, so this is a problem for me. > Otherwise there is nothing special about a script. SET NAMES and SET > SQLDIALECT are for interactive use within an isql shell. Scripts do not take > parameters. The fact is that isql has a command-line mode, whereby you can > pass parameters to set things like connection charset and sql dialect on > switches, along with an -i switch for a script to execute. When isql runs > from the command line or a batch file, it does understand the SET commands, > but you can set them either way for isql. It would be good to use the settings provided with SET commands, so the script behaves exactly the same as with other script execution tools. It's not a must, but it would be better for me :) ------------------------------------------------------------------------------ Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev _______________________________________________ Firebird-net-provider mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
