TMyQuerry.SQL*

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
teunis
Posts: 48
Joined: Wed 01 Feb 2006 14:15
Location: Curacao

TMyQuerry.SQL*

Post by teunis » Tue 29 Aug 2006 22:29

Delphi 6 Q : TMyQuerry;
Fortunately this goes well: Q.SQL property is set and Q.Execute gives me result.
But I also see Q.SQLUpdate etc.
How can I let the Q know to execute SQLUpdate?
The examples given are very sound sql's but how to execute them.
Please, enlight me (Teunis) :shock:

Antaeus
Posts: 2098
Joined: Tue 14 Feb 2006 10:14

Post by Antaeus » Wed 30 Aug 2006 06:19

SQLUpdate is executed automatically if you do something like this:

Code: Select all

  Q.Edit;
  // some code to edit record
  Q.Post
This is described in MyDAC FAQ.

Post Reply