When I add records to my form the the table isn't updated when I save the records. But if I close Kexi and reopen it the records are in the table. Looks like there's a missing commit somewhere? Is this normal behavior for Kexi?

Hi, Something specific must have happened in your db so it might be required to inspect it (or any similar minimal one that exposes the same issue) to see why the update is not visible immediately.

If it does not commit you won't see the data but there is a commit since you see the change.

Cheers.

Thanks for your reply. The project is using the builtin SQLite db server. How should I inspect, or what should I be looking for? The commit doesn't seem to happen when I save the new record, when it should, but after I close and reopen the project the commit shows up.

Hello, I'd know your KEXI version first. If you can make a copy of your database and send me privately I can inspect it. You can strip it down by opening e.g. in SQLItebrowser and removing all tables but the ones that will be tested. You can also remove all records first.

I sent a pm with that info and a copy of the database earlier today. Thanks again!

OK tried it, and it works (KEXI 3.2), both entering new records in the table and form. Could you tell me 1. if entering new records into the table works for you and 2. how do enter and accept records in the form step by step?

Glad it works there, now just need to see what I'm doing wrong. I see a problem first with entering data directly into table and then having it show up in the form. Let's see if I'm doing something wrong there first, maybe that will address the form entry problem. This is what I did, step-by-step:

1. Open project without any records. In table view, enter data in first record, then hit shift-enter twice (or Save Record tab). Next record appears. Enter data for three records, save, then change to form view.

2. Check form view, all records show in form as expected.

3. return to table view, enter fourth record, then shift-enter twice. Change back to form view.

4. in form view, new record not present in form. First three records are there still, and Record count at bottom of blank form shows “< 4 of 3 >”. Record 4 has empty fields in form view.

5. close project with Kexi > Close. Then reopen project. Open form view, record 4 now there.

Record 4 should be in form view without having to close? Or am I doing something wrong here?

Quick fact. Forms does not refresh automatically the contents when you also enter data using other forms for the same table or in the table view directly. The same goes in opposite way: in table view when you enter in forms. To refresh you can close and open respective form or table and records will be visible. This is inconvenient se we plan to deliver a "Refresh" feature.

Ah, ok, so what I'm seeing is a known issue. I didn't know that. Thanks!