Re: MS ADO (VB6.0) Problem with Updates

2002-05-15 Thread Gelu Gogancea
t; <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, May 15, 2002 2:14 AM Subject: MS ADO (VB6.0) Problem with Updates > Hi all, I use MS VB6 and ADO to access my MySQL-Server. > > dim rs as new adodb.recordset > rs.activeconnection = ConnectionObject > rs.curserl

MS ADO (VB6.0) Problem with Updates

2002-05-14 Thread Christoph Lütjen
Hi all, I use MS VB6 and ADO to access my MySQL-Server. dim rs as new adodb.recordset rs.activeconnection = ConnectionObject rs.curserlocation = aduseclient rs.cursertype = adopenkeyset rs.source = "select * from TABLE where ID = " & id rs.open rs!FIELD1 = "VALUE" ... rs.update ... ERROR: Row ca