Lots of errors using batch inserts (ValueCount > 1):

Discussion of open issues, suggestions and bugs regarding IBDAC (InterBase Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
frickler
Posts: 37
Joined: Wed 04 Apr 2018 08:30

Lots of errors using batch inserts (ValueCount > 1):

Post by frickler » 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?

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: Lots of errors using batch inserts (ValueCount > 1):

Post by ViktorV » Thu 04 Jul 2019 04:29

Please send a small sample demonstrating the specified behavior to us using the contact form https://devart.com/company/contactform.html

Post Reply