> 'select m.*,'
>
> ' (select "Name" from "items" d where d.ID=m."ItemID")
> as "Ite' +
> 'mName",'
>
> ' (select "Name" from "items" d2 where d2.ID=m."Purpose")
> as "' +
> 'UseIn",'
>
> ' (select "Warehouse" from "warehouse" d3 where
> d3.ID=m."From"' +
> ') as "Source",'
>
> ' (select "Warehouse" from "warehouse" d4 where
> d4.ID=m."To") ' +
> 'as "Destination"'
> 'from "usage" m'
>
> 'where ("Status" != :paramstatus) and "RequestDate"
>
>>= :paramdate' +
>
> ' ')

How does it perform in IB_SQL ?

> AutoFetchAll = True

Do you realy want to download all the records?

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services