MySQL Problem

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

Article #8

Back to borland.public.cppbuilder.database.dbexpress Previous Next

From: 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.

Technical Details

Message-ID: <400eb664@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!nntp-relay.ihug.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: fb4e2,717f3d3b493cc62b,start
X-Google-Attributes: gidfb4e2,public
X-Google-Thread: 10a82e,717f3d3b493cc62b,start
X-Google-Attributes: gid10a82e,public
X-Google-Thread: f7a32,717f3d3b493cc62b,start
X-Google-Attributes: gidf7a32,public
X-Google-ArrivalTime: 2004-01-21 09:30:07 PST
From: "Arnaldo Giacomitti Junior" <arnaldo@giacomitti.com.br>
Newsgroups: borland.public.cppbuilder.database.dbexpress,borland.public.delphi.database.dbexpress,borland.public.kylix.database.dbexpress
Subject: MySQL Problem
Date: Wed, 21 Jan 2004 15:29:06 -0200
Lines: 38
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: 200.138.134.161
Message-ID: <400eb664@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1074706020 200.138.134.161 (21 Jan 2004 09:27:00 -0700)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!nntp-relay.ihug.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail