|
Hi
I'm about to embark on a conversion from Paradox to IB and I
have a question about common practice in terms of the use of TQuery's in place
of TTables.
My current app opens a TTable, for each Paradox table that it
uses, at startup and closes them all at closedown.
There appear to be 3 general ways that one can use
TQuery's:
1. Just like a TTable, with a Select * from MyTable in
the SQL property (at one extreme);
2. As a purely open Query with nothing in either
parameters or SQL, relying on code supplied by the app at runtime. In this
case one TQuery could be used to access several files at different
times.
3. With both SQL and parameters specified at design
time, in which case the TQuery is for a predetermined purpose ( and attached to
a specific file).
In the absence of ANY knowledge about what is normal, I'd be
grateful to hear of any general guidelines on what approaches are adopted by
those in the know.
TIA
Mark
|
BEGIN:VCARD VERSION:2.1 N:Howard;Mark FN:Mark Howard ORG:Forest Production Systems Ltd TEL;WORK;VOICE:(07) 348 8177 TEL;CELL;VOICE:(021) 477564 TEL;WORK;FAX:(07) 348 8178 ADR;WORK:;;P.O.Box 5155;Rotorua LABEL;WORK;ENCODING=QUOTED-PRINTABLE:P.O.Box 5155=0D=0ARotorua EMAIL;PREF;INTERNET:[EMAIL PROTECTED] REV:20010619T014852Z END:VCARD
