[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql-win32
Subject:    Refresh after Update in VB?
From:       <John.Cook () bench ! com>
Date:       2004-03-25 19:35:02
Message-ID: 9B124F08B3EFDA4F8813B05102DC7195EE0061 () nh-ex01 ! nh ! bench ! com
[Download RAW message or body]

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.

-- 
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:    http://lists.mysql.com/win32?unsub=mysql-win32@progressive-comp.com



[prev in list] [next in list] [prev in thread] [next in thread]