Devart Forums

Posted: **Wed 04 Mar 2009 12:58**

Hello,
sorry my english is nocht very well.

I have a problem and hope, you can help me. I used for a long time MySQL 3.1. Yesterdam my server crashed and i install MySQL 5.
I use C++ Builder 6 and MyDac in Version 3. But with the MyDac Version 3 it seems, that i cannot connect to MySQL 5. I looked for a new MyDac Version and find the Version 5.7.

I remove the old MyDac 3 Version and installed the MyDac 5.7. I open my project and start the programm. Know i have the problem, that it seems that my SQL-Query not work.

With MyDac 3 i do so

Code: Select all

sql_insert = "insert into kundendaten";
sql_insert += " (anrede, firma, vn, nn, stra, plz, ort, land, bemerkung, gesamtkosten, versandkosten, zahlart, blz, ktonummer, bank, inhaber, artikel_komplett, bestellart, bestelldatum, versanddatum, erfasser)";
sql_insert += "  values ('"+neue_bestellung->anrede->Text+"', '"+neue_bestellung->firma->Text+"', '"+neue_bestellung->vn->Text+"', '"+neue_bestellung->nn->Text+"', '"+neue_bestellung->stra->Text+"', '"+neue_bestellung->plz->Text+"', '"+neue_bestellung->ort->Text+"', '"+neue_bestellung->land->Text+"', '"+neue_bestellung->bemerkung->Lines->Text+"',";
sql_insert += "  '"+artikeldaten_back[0]+"', '"+artikeldaten_back[2]+"', '"+zahlart+"', '"+neue_bestellung->Eblz->Text+"', '"+neue_bestellung->Ektonummer->Text+"', '"+neue_bestellung->Ebank->Text+"', '"+neue_bestellung->Einhaber->Text+"', '"+artikeldaten_back[1]+"', '"+bestellart+"', '"+bestelldatum+"', '', '"+computername+"')";

DataModule1->sql_kundendaten->SQL->Clear();
DataModule1->sql_kundendaten->SQL->Add(sql_insert);
DataModule1->sql_kundendaten->Execute();

I get no errormessage. Execute is done but i have no data in my Table. With MyDac 3 it work. Why not with 5.7?

Is in MyDac 5.7 something other to do my Query?

Thanks vor help.

Posted: **Wed 04 Mar 2009 14:36**

I can not reproduce the problem.
Plase make sure that you insert data and read it in/from one database.

Posted: **Wed 04 Mar 2009 15:27**

Hello,
i know make a new project. I have a Form with one Button. Then i have a DataModul. On the DataModul i have one TMyConnection and one TMyQuery.

When i click on the button this code were executed

Code: Select all

AnsiString sql_insert = "insert into test (vn, nn) values ('michael', 'linke')";

DataModule1->sql->SQL->Clear();
DataModule1->sql->SQL->Add(sql_insert);
DataModule1->sql->Execute();

The Query in sql_insert i want to write in my DB. To reach that i must do DataModule1->sql->Execute() or is that wrong? When i use code above then nothing happen. I have no new data in my DB.

Where is my mistake?

Posted: **Wed 04 Mar 2009 15:54**

Is their maybe a restriction in the Trail Version to write into a DB?

Posted: **Thu 05 Mar 2009 08:16**

The MyDAC trial edition does not have such limitation.
Please try to write data to DB using ADO or BDE and check the result.

Devart Forums

Execute not work in 5.7 - With MyDac 3 it work - why?

Execute not work in 5.7 - With MyDac 3 it work - why?