Subject Re: Using a text file of all SQL statments
Author Svein Erling Tysvær
Hi Grant!

I think this will vary with your requirements. I've never seen such a
text file myself, but I have seen someone storing SQL statements in a
VARCHAR field in Firebird. Then the user can just choose which
statement he/she wants to run, and since the statements hopefully have
been carefully written by a database developer, you don't risk the
dangers of letting any user write the SQL statement by him-/herself.


--- In, Grant Brown wrote:
> 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.