Arnaldo Giacomitti Junior Guest
|
Posted: Wed Jan 21, 2004 6:41 pm Post subject: MySQL Problem! |
|
|
I am trying to do this:
clDataSet->Insert();
clDataSet->Fields->FieldByName("Estado")->AsString =
String(meEstado->Text);
clDataSet->Fields->FieldByName("Descricao")->AsString =
String(meDescricao->Text);
clDataSet->Post();
clDataSet->ApplyUpdates(-1);
clDataSet is a TSQLClientDataSet, the db server is MySQL all connection are
ok!
Then I have put a SQLMonitor and got this log for this code:
MySQL - mysql_real_query
BEGIN WORK
MySQL - mysql_real_query
MySQL - mysql_escape_string
MySQL - mysql_escape_string
insert into tbesta;
(Estado, Descricao)
values
('TT', 'test teste')
MySQL - mysql_real_query
MySQL - mysql_error
COMMIT
MySQL - mysql_real_query
SET AUTOCOMMIT=1
MySQL - mysql_real_query
The probelm is why TSQLClientDataSet is puting a ";" after tbesta (the name
of my table at server).
Thanks
Arnaldo Giacomitti Junior.
|
|