Created attachment 97692 [details] Error message received when trying to save record After successfully creating 17 records in "Form" mode, the program won't save the 18th and won't let me add any new records to the database. Pop-up message says: Error inserting the new record S1000 General error java.lang.NullPointerException in statement INSERT INTO "Art" ("Address","AmountPaid","City","CollectionID","CopyrightYear","DatePurchased","Discount","EditionNumber","EmailAddress","FirstName","Insured","ItemType","LastName","PaymentMethod","PhoneNumber","Photo","PurchasedAt","SalePrice","SalesTax","ShippingCost","StateOrProvince","Title") VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)]
Make a copy of the database. Delete all personal data in the database and attach the empty (or filled with dummies) database to this bug. So somebody elese could have a look at it. Without any example it is impossible to get the same error. You are using the internal HSQLDB? Where is the Primarykey in your table "Art"? Could you reproduce the same with any dummy-data?
Created attachment 97711 [details] A sample of the DB form used when LO stopped allowing records to be added The "add record" button is greyed out on this dummy database form as well as on the original. The original stopped adding new records after #17. The dummy won't even get beyond Record #1 whether I hit "add record" or "next record." Hoping someone can duplicate this bug and suggest a work-around.
Created attachment 97720 [details] Sample of the DB form used when LO would not "Add Record" This a dummy of the original DB form that stopped allowing "Save Record" and "Add Record" after 17 records created. For some reason, the "dummy" will not add a record beyond #1. Any chance there's a work-around for this bug? If not, the LO database is totally USELESS.
(In reply to comment #3) > Created attachment 97720 [details] > Sample of the DB form used when LO would not "Add Record" You have added only a form, not the database. Please attach the *.odb-file.
Following Robert's comment, I put it as NEEDINFO. Judith: may I suggest you to give a try to 4.2.4 since there won't be any new official release with 4.1 branch? (last 4.1.X version is 4.1.6)
No feedback since several months, I put it INVALID since we can't even give it a try. Judith: don't hesitate to reopen this tracker if you still reproduce this with last LO version (4.2.6 or 4.3.0) and please attach an example file in this case.