Hi, I have a table in a form that is used to compute some aggregated funtion. I use it inside a loop in a guide. So I check this value several times during execution. The content of the table changes, but not the fields used at the table qualification. The strange behavior is that ARS only computes the value at the first iteration, so the value is not correct for second or next executions.
To be more clear: I have a table with a qualification: 'ParentID' = $Entry ID$ Then I have a guide with the next filters: Label: Loop Filter 1: SET I use a field of the table and compute the MAX. Filter 2: CALL SERVICE I call a service that changes values at the database Filter 3: If some condition is meet GOTO Loop. Looking at the log I see that the first time Filter 1 is executed, a SELECT is sent to the database, so the MAX value is retrieved correctly. Then the service executes and I can see the SQL going to the database with INSERTS and UPDATES followed by a COMMIT WORK. So the Database is correctly updated. But next time Filter 1 is called, no SELECT to the database is done (seems that the Server has some kind of Cache and thoughts that the database hasn't changed) Well, the question: Is there any process command that forces a refresh on table on filter side? Regards, Jose Manuel Huerta http://theremedyforit.com/ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
