TMyQuery insert only one column instead of all

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
moppelstroppel
Posts: 19
Joined: Sat 25 Aug 2018 08:09

TMyQuery insert only one column instead of all

Post by moppelstroppel » Wed 22 May 2019 11:23

Hello all,

I'm using V 9.1.5
I do
TMyQuery* query;
UnicodeString stmt = SELECT * FROM Table WHERE column = 'not existing';
query->Active = false;
query->SQL->Text = stmt;
query->Active = true;

query->Insert();
query->FieldByName("")->AsVariant = ....
query->FieldByName("")->AsVariant = ....
query->FieldByName("")->AsVariant = ....
query->FieldByName("")->AsVariant = ....
query->Post();

Insert is faling due to missing column without default values. Only one column is used instead of all.
On my W10 system everthing is working fine, but on customer site W7 i got the error due to missing columns.


Thanks
Thomas

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

Re: TMyQuery insert only one column instead of all

Post by ViktorV » Wed 22 May 2019 11:42

Unfortunately, we can't reproduce the issue.
Please compose a small test sample including the script for creating and filling in the database objects that would demonstrate the described behavior and send it to us via the contact form https://devart.com/company/contactform.html so that we could research the issue further.
In addition, please specify the particular version of MySQL and the full text of the error you receive.

Post Reply