PDA

View Full Version : ODBC Write to database delayed



Phjr
2013-08-13, 04:11
I noticed that an update in a form is written only when I change record (next, previous ...), is there a way to make sure it is written immediately ?
form is based on a virtual table mapped to a MySQL table (ODBC connector 5.1)
Regards

barrymavin
2013-08-13, 04:27
skip 0 should do it

Phjr
2013-08-13, 04:55
This is an ordinary form section, I first validate with the "green tick", is this associated to a delegate? (I put "skip 0" in the refresh delegate (after validating) and update was written)
Regards

barrymavin
2013-08-13, 05:00
Yes Lianja uses before and after buffers to be able to perform optimistic locking.

There are other delegates you can use but if thats working for you that should have no side effects as the buffer will only be flushed if its dirty.

Phjr
2013-08-13, 05:11
then no delegate is associated to the "commit/validate" action in a way similar to the "refresh" action?

barrymavin
2013-08-13, 06:19
I'm just uploading RC8 daily build into the windows/beta downloads directory. We will give you access to this so you can test the fixes we did from the tickets you submitted.

Keep up the good work :)

Phjr
2013-08-13, 07:20
Thanks a lot.

Phjr
2013-08-13, 08:14
Both issues, seqno() and SQL count(), are sorted with RC8, great!
Best regards