Jump to content

Looping SQL


modemmute

This topic is 7831 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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

This topic is 7831 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.