MySQL Problem

Thread View: borland.public.cppbuilder.database.dbexpress

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by Arnaldo Giacomitti Junior Wed, 21 Jan 2004 17:29

Author: Arnaldo Giacomitti Junior
Date: Wed, 21 Jan 2004 17:29

36 lines
1992 bytes

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.

Re: MySQL Problem

Author: Craig Stuntz TeamB
Date: Wed, 21 Jan 2004 17:37

21 lines
1901 bytes

Arnaldo Giacomitti Junior wrote:

> I am trying to do this:

	Message cancelled due to cross-post.  Please read and follow Borland's
rules for the use of their server:

http://info.borland.com/newsgroups/guide.html

	In the future, please choose a single, appropriate newsgroup for your
question.

	Thank you,

	-Craig

-- 
Craig Stuntz [TeamB] . Vertex Systems Corp. . Columbus, OH
  Delphi/InterBase Weblog : http://delphi.weblogs.com
InterBase Performance Monitor -- Analyze and control your IB7 
  server: http://delphi.weblogs.com/IBPerformanceMonitor

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads