onUpdate table event and delay before record saved issue

Discuss all problems you have with Servoy here. It might help to mention the Servoy version and Operating System version you are using

onUpdate table event and delay before record saved issue

Postby swingman » Tue Dec 04, 2007 9:20 am

Hi 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?
Christian Batchelor
Certified Servoy Developer
Batchelor Associates Ltd, London, UK
http://www.batchelorassociates.co.uk

http://www.postgresql.org - The world's most advanced open source database.
User avatar
swingman
 
Posts: 1472
Joined: Wed Oct 01, 2003 10:20 am
Location: London

Return to Discuss possible Issues and Bugs

Who is online

Users browsing this forum: Google [Bot] and 9 guests