Looping SQL

[modemmute]

Unique problem here - really hoping someone here can help!

I have a loop set up to retrieve records dynamicly from a SQL datasource. The loop moves through a set of records, assembling a SQL statement in a calculation field and then queries the datasource for the data to import.

The problem is that once the script has read the dynamic SQL statement once, it never goes back to read it again when it moves on to the second, third, forth record, etc. It's as if it sees the SQL statement the first time, then (even though I'm telling it to look again) it assumes it has seen the statement and never reads it again to update the query.

Help!

Client is getting anxious and I can't figure this one out... Many thanks in advance for any / all help.

-Modemmute

[BobWeaver]

You may have to change the calculation field to unstored. Also if you are putting intermediate results into global fields, make sure that they really are defined as global.