B.Dauvissat
New Member
Hi,
I have a problem on a query i wrote.
It (the query) is very complex and has a lot of recursive requests (same table, previous lines).
On a very heavy database, the request lasted over 6 days :blush:. But the server went down and all changes were lost.
my code is like that :
I would like to commit every 200 lines so, if the server is down, I'm not loosing everything.
Thank you for your help.
I have a problem on a query i wrote.
It (the query) is very complex and has a lot of recursive requests (same table, previous lines).
On a very heavy database, the request lasted over 6 days :blush:. But the server went down and all changes were lost.
my code is like that :
Code:
DEFINE QUERY q-Table FOR Table.
OPEN QUERY q-Table
FOR EACH Table
WHERE Table.Date >= i-Date
BY Table.Date.
GET FIRST q-Table.
DO WHILE NOT QUERY-OFF-END("q-Table") :
[Many things]
GET NEXT q-Table.
END.
CLOSE QUERY q-Table.
I would like to commit every 200 lines so, if the server is down, I'm not loosing everything.
Thank you for your help.