I recently did something like this.

I allowed my customer to copy a file to a directory which is being monitored
by my app. When the app detects it, it reads it, parses the sql, and
executes it.

Basically, the file is simply a list of sql statements followed by a
delimiter.

e.g.

^ is the delimiter

select * from dog_table^
select *
from cat^
select * --This is a comment
from cat^


-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]On Behalf Of Grant Brown
Sent: Monday, August 22, 2005 11:20 PM
To: Firbird Support Group
Subject: [firebird-support] Using a text file of all SQL statments


Hi all,

Recently, about a week ago someone on the list said that they used
dynamically loaded SQL strings that were stored in a text file. At least
I think they used a text file.

I have been thinking about this and kinda like the idea.

So my question is how does one find the required SQL string in the text
file and then load it into a query fast enough not to impact on end user
performance.

--
Regards,
Grant Brown

Product Development Manager
Phone : 02 4229 1185
Mobile : 0412 926 995
Email : grant@...
Web : www.sitedoc.com.au

SiteDoc - Easy to Use - Powerful Results



[Non-text portions of this message have been removed]