Board index » off-topic » Programatically creating Paradox Script files (.sql)
Programatically creating Paradox Script files (.sql)
2003-07-04 06:41:24 PM
I am aiming at creating a Paradox Script file (.sql) programatically so that
I can reuse that single file for all my querying needs.
I opened up an existing .sql file (created by Paradox) with Notepad and
found that it contained SQL Text in plain English with some comments.
I noticed that, when I created a script file manually with Notepad (with
some sql text in it), and saved it with a .sql extension, it works just fine
with in Paradox. But when I try to load it from Delphi (i.e. Select * from
mytest.sql ) it gives an error : Operator not applicable. However Delphi
successfully loads any sql scripts created by Paradox. BTW I use Delphi 5 as
my development tool.
Am I missing something? Is any encoding applied on text? Does any one know
how this could be done? I would appreciate some help.
Thnx in Advance,