Newbies modemmute Posted November 13, 2002 Newbies Share Posted November 13, 2002 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 Link to comment Share on other sites More sharing options...
BobWeaver Posted November 14, 2002 Share Posted November 14, 2002 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. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7926 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now