#2 Read/save SQL commands from a text file

[Anonymous]

A very crucial feature for me is to be able to save SQL commands to a text file (seperated by ';')
characters, to then execute all at once at at later time. I tried copying a text file into the SQL text
field, but it didn't like multiple SQL commands seperated by ';' characters.

I would like to format the text file with multiple SQL commands, and put comments in the file with
'#' characters.

It would also be nice to specify a directory to store the SQL command files in the global
preferences and the file chooser to open a SQL file could go there first. This is to avoid an
annoying problem in Windows with Java programs. In Windows NT, the HOME directory is set to
c:\winnt\profiles\<username> and this is nowhere close to where I keep my files
(d:\users\<username>). If we could save the directory to the global properties, it would save alot
of directory tree traversal time when trying to open a file.

[Colin Bell]

Logged In: YES
user_id=233132

There are two items in the task database that cover this
request.

http://sourceforge.net/pm/task.php?
func=detailtask&project_task_id=38583&group_id=28383&group_p
roject_id=13433

and

http://sourceforge.net/pm/task.php?
func=detailtask&project_task_id=39198&group_id=28383&group_p
roject_id=13433

[Colin Bell]

Logged In: YES
user_id=233132

I've had some code contributed by Johan Compagner which
will provide this functionality. I'm going to be applying
this code to version 1.1.

[Colin Bell]

Logged In: YES
user_id=233132

This functionality has been added to the SQL Script plugin that will be available in version 1.1.