>I'm looking for a way to speed up a calculation routine that computes the total of a document that can contain up to a few hundred lines. The routine is slow now because for each line I access the db. I'm looking for a way to implement this in a more data oriented way.
>
>In VFP I would have dumped the relevant keys into a cursor and then join the tables to the cursor in an sql statement.
>
>I could of course simulate this by dumping the keys into a temporary table (which if I'm right would not limit the amount of times I access the db), but I was wondering if there is not a more "elegant" way to do this.
>
>TIA.
I'm not sure I understand you right, but you could use derived tables in your SELECT.
SELECT .....
FROM MainTable
INNER JOIN (SELECT Keys From SomeTable WHERE ...) DympedKeys
ON ....
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.