Fist of all thank you for your help!!!
Sorry, but I disagree with you.....Record is inserted correctly in database.
The only problem is that Resultset remains empty after RS.Update.
Any solution how to get Id of that inserted record without using MySQL
specific solution?
Thanks all!
Simon
----- Original Message -----
From: "Dennis Salguero" <[EMAIL PROTECTED]>
To: "Simon Abolnar" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Saturday, April 14, 2001 1:21 PM
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
