Unfortunately, it doesn't seem like all ADO methods and properties and
supported when working with MySQL. Update, as you know, is one of them,
along with others like RecordCount.
I would recommend using a connection object and then passing an SQL
statement to run. If need be, you can add the results to a recordset object.
You can write it like the following, where objConn is a ADO connection
object:
<%
strSQL = "SELECT * FROM Foo"
objConn.Execute(strSQL)
%>
Obviously, the above is ASP syntax, but you get the idea for VB :).
Good luck,
Dennis
**********************************************'
Beridney Computer Services
[EMAIL PROTECTED]
http://www.beridney.com
----- Original Message -----
From: "Simon Abolnar" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, April 14, 2001 4:46 AM
Subject: ADO RS.Update problem
Hello!
I am using mysql with VB ADO under Windows 2000 Proffesional.
I add data with:
RS.Open "Query WHERE 0=1", Cn, , , adCmdText
RS.AddNew
RS.Fields(Cols).Value = xx
.....
RS.Update
After RS.Update RS.Fields(Cols).Value is NULL.
If I use Access database, RS.Fields(Cols).Value has value of last inserted
record.
Would you like to tell me, why mysql works in different way and how to solve
this problem to have compatible solution for mysql and Access?
Thanks all!
Simon
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
