------=_NextPart_000_0007_01C67E7A.553D04D0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hello

I dont know If I am doing anything wrong, but here goes:

I have a mySQL Query with a datasource connected toa DBGrid (standard =
Delphi),
but when I do a 'SELECT .......... FOR UPDATE', I cannot update the =
grid.

Before the SELECT clause, I do a START TRANSACTION and when the data
is OK then I do a COMMIT. In between the START TRANSACTION and COMMIT I =
want to
be able to update some rows and columns MANUALLY in the DGGrid. I =
cannot do
this.

What can I do to rectify this ?

Many thanx for the help
Abin


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.532 / Virus Database: 326 - Release Date: 27/10/2003
------=_NextPart_000_0007_01C67E7A.553D04D0--

Hi

Are you using TQuery component or direct API? Is this problem fixed now?
Which version of Delphi are you using? Do you use BDE?

regards

Nataraj
Ooty,India

Abin Saydah wrote:
> Hello
>
> I dont know If I am doing anything wrong, but here goes:
>
> I have a mySQL Query with a datasource connected toa DBGrid (standard Delphi),
> but when I do a 'SELECT .......... FOR UPDATE', I cannot update the grid.
>
> Before the SELECT clause, I do a START TRANSACTION and when the data
> is OK then I do a COMMIT. In between the START TRANSACTION and COMMIT I want to
> be able to update some rows and columns MANUALLY in the DGGrid. I cannot do
> this.
>
> What can I do to rectify this ?
>
> Many thanx for the help
> Abin
>
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.532 / Virus Database: 326 - Release Date: 27/10/2003


--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc [at] m.gmane.org