Table Field & DB Query Builder editing updates next reco

Creating desktop or client-server database solutions?

Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller, robinmiller

Post Reply
xeir
Livecode Opensource Backer
Livecode Opensource Backer
Posts: 35
Joined: Thu Jul 03, 2008 5:54 am

Table Field & DB Query Builder editing updates next reco

Post by xeir » Thu Feb 12, 2009 4:28 pm

Hopefully a simple problem here, but it's early and you never know.

Situation:
Created a Table Field, added a simple DB Query using the Builder using a primary key and NOT caching record set.
Table is set to "Focusable" and "Tab on Return".
Database is set to "Update cell data after editing"

Problem:
When editing data in the field, then either pressing Enter or scrolling past the last column, Rev will write the data to the DB. However, it is consistently updating the NEXT record in the table with the edited data instead of the CURRENT record.

Anyone have any thoughts on this?

Thanks

xeir
Livecode Opensource Backer
Livecode Opensource Backer
Posts: 35
Joined: Thu Jul 03, 2008 5:54 am

Post by xeir » Tue Feb 24, 2009 9:28 pm

Well, guessing that no-one has any insight into this.

So in the meantime, I've given up on allowing for in table editing, and just made it a clickable list to bring up a separate edit window.

Post Reply