Results 1 to 8 of 8

Thread: ODBC Write to database delayed

  1. #1
    Member
    Join Date
    Apr 2013
    Posts
    88

    ODBC Write to database delayed

    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

  2. #2
    Lianja Development Team barrymavin's Avatar
    Join Date
    Feb 2012
    Location
    UK, USA, Thailand
    Posts
    5,771
    skip 0 should do it
    Principal developer of Lianja, Recital and other products

    Follow me on:

    Twitter: http://twitter.com/lianjaInc
    Facebook: http://www.facebook.com/LianjaInc
    LinkedIn: http://www.linkedin.com/in/barrymavin

  3. #3
    Member
    Join Date
    Apr 2013
    Posts
    88
    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

  4. #4
    Lianja Development Team barrymavin's Avatar
    Join Date
    Feb 2012
    Location
    UK, USA, Thailand
    Posts
    5,771
    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.
    Principal developer of Lianja, Recital and other products

    Follow me on:

    Twitter: http://twitter.com/lianjaInc
    Facebook: http://www.facebook.com/LianjaInc
    LinkedIn: http://www.linkedin.com/in/barrymavin

  5. #5
    Member
    Join Date
    Apr 2013
    Posts
    88
    then no delegate is associated to the "commit/validate" action in a way similar to the "refresh" action?

  6. #6
    Lianja Development Team barrymavin's Avatar
    Join Date
    Feb 2012
    Location
    UK, USA, Thailand
    Posts
    5,771
    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
    Principal developer of Lianja, Recital and other products

    Follow me on:

    Twitter: http://twitter.com/lianjaInc
    Facebook: http://www.facebook.com/LianjaInc
    LinkedIn: http://www.linkedin.com/in/barrymavin

  7. #7
    Member
    Join Date
    Apr 2013
    Posts
    88
    Thanks a lot.

  8. #8
    Member
    Join Date
    Apr 2013
    Posts
    88
    Both issues, seqno() and SQL count(), are sorted with RC8, great!
    Best regards

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Journey into the Cloud
Join us