You are not logged in.
- Topics: Active | Unanswered
Pages: 1
#1 Re: mORMot 1 » Batch columns and values mismatch » 2022-11-26 07:17:50
Thanks ab,
Works perfectly.
#2 Re: mORMot 1 » Batch columns and values mismatch » 2022-11-18 19:27:00
It does shed some light and I appreciate the effort, thank you.
The TRecordVersion, as you say, is not a simple field but as I understand it, only for for retrieval. Posting and updating should be transparent.
The main concern for me is when the record count is changed. That should have no bearing on the fields.
As I said, there is no rush and I will wait until ab is back from his well deserved vacation.
#3 Re: mORMot 1 » Batch columns and values mismatch » 2022-11-14 14:51:32
Thanks ab,
Thanks for the reply.
I have just created a dummy field for now.
Still have a lot of other parts to keep me busy.
No worries. Enjoy your holiday.
#4 mORMot 1 » Batch columns and values mismatch » 2022-11-14 00:41:14
- rudiloos
- Replies: 9
Hi
The following code
https://gist.github.com/rudiloos/dcbc66 … a0edb7989f
produces the following error
Error SQLITE_ERROR (1) [insert into Test (RowID,CreatedOn,CreatedBy,EditedOn,EditedBy,Notes,RecStatus,File_Name,File_Type,File_Ext,File_Size,File_Date,File_MD5,ProjID,DoneOn,DoneBy,COCNo,COCType,SentOn,SentTo,DateBPM) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)] using 3.39.4 - 22 values for 21 columns, extended_errcode=1
Looking at the fields, it seems to not list the TRecordVersion field but wants to insert the value.
This only happens when the record count added is 199. No error if the record count is 198 or 200.
Changing the model by increasing or decreasing the field count by one also does not generate an error.
Adding the records one by one and not in batch mode produces no errors.
Tried to look through the code but way above my intellect and just gave me a headache.
Am I doing something wrong or is it a bug?
Synopse mORMot framework 2.0.4191, compiled with Free Pascal 3.2.2 32 bit, against SQLite 3.39.4, on Windows 10 64bit (10.0.19045)
Pages: 1