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
TMyQuery insert only one column instead of all
-
- Posts: 19
- Joined: Sat 25 Aug 2018 08:09
Re: TMyQuery insert only one column instead of all
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.
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.