Just a quick note about RecordCount. RecordCount only returns the number of
records or rows from the recordset that have been 'seen'. Therefore it is
only reliable if you have traversed the entire recordset before calling it.
I agree, however, that direct SQL calls will generally produce a more
predictable result
Sorry for the interruption...
Pat...
----- Original Message -----
From: "Dennis Salguero" <[EMAIL PROTECTED]>
To: "Simon Abolnar" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Saturday, April 14, 2001 7:21 AM
Subject: Re: ADO RS.Update problem
> 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
>
---------------------------------------------------------------------
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
