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 las
- 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 A
Hello!
When I add record in database everything works OK. When I modify data in database using
RS.Update
function everything works OK again when I use the same or less length field that it
was before. (lets say "123" to "456" or "45" o "4")
The problem is when I use greater field length (my sql
Hello!
I would like to specify my problem once again!
I have a field type: VARCHAR(100) NOT NULL
When I add new record in database everything works OK!
When I want to modify data in a field using ADO with:
RS.Fields(0).Value="Value"
function everything works OK again when I use the same or les
