onUpdate table event and delay before record saved issue
Posted: Tue Dec 04, 2007 9:20 amHi all,
just wondered if anyone have come across this issue (Servoy 3.5.2, Autosave is ON):
We have a table which is a list pks of records to be transferred to a web site via a web-service running in a head-less client.
In another table we have an onUpdate table event which places the pk of the record in the queue to be transferred.
This all works fine.
The web service is triggered every minute via a headless client.
This also works fine.
Then we discovered that the web service was transferring the old version of the record, not the new one.
We think the following is happening:
The client which changes the record, updates the record, but does not save it in time before the web_service picks up the pk and reads the currently saved record.
Is it save to put a
databaseManager.saveData()
to force an immediate save in an onUpdate
table event method to try to cure this issue?
just wondered if anyone have come across this issue (Servoy 3.5.2, Autosave is ON):
We have a table which is a list pks of records to be transferred to a web site via a web-service running in a head-less client.
In another table we have an onUpdate table event which places the pk of the record in the queue to be transferred.
This all works fine.
The web service is triggered every minute via a headless client.
This also works fine.
Then we discovered that the web service was transferring the old version of the record, not the new one.
We think the following is happening:
The client which changes the record, updates the record, but does not save it in time before the web_service picks up the pk and reads the currently saved record.
Is it save to put a
databaseManager.saveData()
to force an immediate save in an onUpdate
table event method to try to cure this issue?