Milan Babuskov wrote:

> masotti wrote:
>>> Your current 'library' must have some means of identifying which
>>> parameter goes with which '?' even if it is hidden, but suspect that
>>> information is not stored with the query?
>> The information is stored with the query, in the sense that I've already
>> queries in the form
>> SELECT 'A', 'B', K.THAT, K.THIS, K.OTHER FROM OK K WHERE K.GGG = :PARAM1
>> AND K.SSS = :PARAM1
>
> This is the 'magic' done by BDE and other Delphi libs. It replaces
> :SOMETHING with ? once you decide to run the statement and keeps the
> (parameter number->parameter name) pairs, so you can refer to them.

I've been playing with the idea of doing something like this for the ADOdb
library but I'm not sure if it is necessary as there are so many other ways of
doing it.

--
Lester Caine - G8HFL
-----------------------------
Contact - http://home.lsces.co.uk/lsces/wiki/?page=contact
L.S.Caine Electronic Services - http://home.lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk//
Firebird - http://www.firebirdsql.org/index.php