ODBC Write to database delayed

**Phjr** · 2013-08-13, 03: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, 03:27

skip 0 should do it

**Phjr** · 2013-08-13, 03: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, 04: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, 04:11

then no delegate is associated to the "commit/validate" action in a way similar to the "refresh" action?

**barrymavin** · 2013-08-13, 05: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