#2 Read/save SQL commands from a text file

closed
None
5
2001-11-18
2001-09-25
Anonymous
No

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.

Discussion

  • Colin Bell

    Colin Bell - 2001-10-03

    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

    Colin Bell - 2001-10-03
    • assigned_to: nobody --> colbell
     
  • Colin Bell

    Colin Bell - 2001-10-22

    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

    Colin Bell - 2001-11-18

    Logged In: YES
    user_id=233132

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

     
  • Colin Bell

    Colin Bell - 2001-11-18
    • status: open --> closed
     

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks