Re: MySQL, ADO and ODBC

>calls the "post" method , i get an error:
>
>"Row cannot be located, values have changed since it was last read."
>
>I'm not using anything like BatchOptimistic, or nothing... its a simple
>TADOQuery with the default settings.
>
> I thought this was related to the MDAC version installed on the system, but
>i updated in windows 2000 to "MDAC 2.8 RTL" and in WinXP to "MDAC 2.8 SP1
>on Windows XP" but i still get the error. Any ideas? Why does it work on
>Win2k and not on XP??

Does this happen after you have initially inserted the record and then go back
and edit it before doing a requery?
--
Brian Bushay (TeamB)
Bbushay@xxxxxxxxx
.

Relevant Pages

  • Re: Insert, Update and Delete with Join Tables
    ... >I've a TADOQuery with this SQL property: ... >with ADOQuery1 do begin ...
    (borland.public.delphi.database.ado)
  • Insert, Update and Delete with Join Tables
    ... I've a TADOQuery with this SQL property: ... with ADOQuery1 do begin ... Edit; ...
    (borland.public.delphi.database.ado)
  • Re: DefaultExpression broken
    ... It is not implemented for TADOdataset or TadoQuery ... Brian Bushay (TeamB) ...
    (borland.public.delphi.database.ado)
  • Re: BDE -> ADO
    ... TADOQuery, but that is a large work to do. ... BDE has a number of problems but being slow isn't ... Brian Bushay (TeamB) ...
    (borland.public.delphi.database.ado)
  • Re: CommandTimeout - TDataSetProvider/TADOQuery
    ... No you will have to update your version of Delphi to get that fixed. ... TADODataset is a better component to use than TadoQuery ... Brian Bushay ...
    (borland.public.delphi.database.ado)