Lots of errors using batch inserts (ValueCount > 1):
Posted: Wed 03 Jul 2019 15:44
Firebird 3.0.4 embedded, IBDAC 6.4.12, Delphi XE6, german windows 7.
1. If I create a new database and table from scratch and then try to insert many rows into
this table using batch operation, a division by zero error occurs. If I set ValueCount to
1, the error disappears. If I close and reopen the connection after creating the database,
the error disappers.
2. If I create a table with one BLOB SUB_TYPE 1 field (closing/opening connection after to
avoid error 1.) and then try to insert many rows into this table using batch operation, I
can't use "AsMemo", because then all blob rows but the last are NULL. If I set ValueCount
to 1, the error disappears. If I use "AsBlobRef.AsString", the error disappears.
I've created a small demo; where to put it?
1. If I create a new database and table from scratch and then try to insert many rows into
this table using batch operation, a division by zero error occurs. If I set ValueCount to
1, the error disappears. If I close and reopen the connection after creating the database,
the error disappers.
2. If I create a table with one BLOB SUB_TYPE 1 field (closing/opening connection after to
avoid error 1.) and then try to insert many rows into this table using batch operation, I
can't use "AsMemo", because then all blob rows but the last are NULL. If I set ValueCount
to 1, the error disappears. If I use "AsBlobRef.AsString", the error disappears.
I've created a small demo; where to put it?