Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1
  • 2

TOPIC: problem saving data

problem saving data 6 months 3 weeks ago #18746

  • infoeos
  • Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 5
  • Thank you received: 0
Hi,
I have a problem saving data in SQLite and Access (MDB) database.
When I create a new row it works but when I modify some data (or delete a row) I click "Post" but the data are not saved (without any error messages).
I have the same problem in two different pc.

For MDB I have this ODBC string:
DBQ=D:\DB\light_data.MDB;DefaultDir=D:\DB;Driver={Driver do Microsoft Access (*.mdb)};DriverId=25;FIL=MS Access;MaxBufferSize=2048;MaxScanRows=8;PageTimeout=5;SafeTransactions=0;Threads=3;UID=admin;UserCommitSync=Yes;

What can I do to fix it?

Thanks

Please Log in or Create an account to join the conversation.

problem saving data 6 months 3 weeks ago #18749

  • admin
  • admin's Avatar
  • Offline
  • Moderator
  • Moderator
  • Deeds not Words
  • Posts: 7514
  • Karma: 33
  • Thank you received: 409
Have your tables got primary keys?
WIthout them, update usually does not work.
There are several posts regarding this problem on our website.
Mike

Please Log in or Create an account to join the conversation.

problem saving data 6 months 3 weeks ago #18755

  • infoeos
  • Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 5
  • Thank you received: 0
Yes, I have a primary key. I tried also with a fresh db with a simple table with some fields (text and date) with an autoincrement ID (primary key).
Attached the db.
Attachments:

Please Log in or Create an account to join the conversation.

problem saving data 6 months 3 weeks ago #18756

  • admin
  • admin's Avatar
  • Offline
  • Moderator
  • Moderator
  • Deeds not Words
  • Posts: 7514
  • Karma: 33
  • Thank you received: 409
Thank for providing us with the database.

We have reproduced the problem and currently trying to fix it
Mike

Please Log in or Create an account to join the conversation.

problem saving data 6 months 3 weeks ago #18757

  • admin
  • admin's Avatar
  • Offline
  • Moderator
  • Moderator
  • Deeds not Words
  • Posts: 7514
  • Karma: 33
  • Thank you received: 409
Can you try latest version please and let us know the outcome
Mike

Please Log in or Create an account to join the conversation.

problem saving data 6 months 3 weeks ago #18758

  • infoeos
  • Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 5
  • Thank you received: 0
I downloaded the last version:
- 32 bit version in an older version (5.3.1.10 [Help->About]) and it doen't work with the same problem
- portable version works!!! Just one thing: if I delete the last (bottom) record I get an error (translated in english looks like "The current record matches the beginning or end of the file or has been deleted. To perform the requested operation, you need to have a current record.") but the record is deleted and works.
Thank you very much

Please Log in or Create an account to join the conversation.

  • Page:
  • 1
  • 2

We have 140 guests and 3 members online