Hello,

I'm working on a simple prototype of a grid displaying data from a table in
mySQL using ADO.

So far I'm doing pretty good, I can connect to the DB, create tables, retrieve
data, and update data and display it all in an MS FlexGrid control.

I'm having a problem when I update twice in a row. I'm trying to update the
same row and field twice in a row just to test it and I get an error saying it
cannot find the same record on the second update. But, if I refresh my data
after each update, I dont get the error.

There is one more thing I should mention, to keep the grid and recordset in
sync, I manually position to the record I want to update, based on the grid row
number. (ie: MoveFirst, then loop on MoveNext (grid row times)) I do this
because I cannot use ADO's AbsolutePosition property with mySQL.

Is there a better way I dont know about to keep a grid and recordset in sync?

Thanks in advance

-John C.