Devart Forums

In the attachment you will find a full example project. Just open Project1.dpr and hit compile. It contains an embedded firebird client (\Win32\Debug\Firebird) and my test database (\Win32\Debug\test.fdb)

If I hit the button "Insert Record 1" a record is inserted. Everything is OK. But if I hit now button "Insert Record 2" to insert another record an exception is shown:

EVariantBadVarTypeError: 'Invalid variant type'

If you click at "Insert Record __2__" first and then at "Insert Record __1__" it works. That makes no sense.


My application needs this options:
SetEmptyStrToNull=true
UpdateAllFiels=false

These options are set and can't be changed.

The first button adds an record with a reference to another table (field ArtikelNr). The second button adds a record without this reference. But the strange thing is, that the other fields may play a role too.

Thanks for your help!

Now I've written this text, but how to attach a file to my forum post?

Hi,
Thanks for contacting Devart blog!

Please submit your example to our support team via the contact form: https://www.devart.com/company/contactform.html

Also please clarify some additional information:
- what version of IBDAC do you have;
- version of FireBird;
- version of IDE;

Hi,

We've reproduced the issue and fixed it. The fix will be included in the next build of our product.
As a workaround, we can send you a nightly build of our product including the required changes.
Please specify your license number, IDE version and send us via this contact form: https://www.devart.com/company/contactform.html