I have this situation:
---------------------------------
dim sSqlSelect As String
dim vValues As Variant
dim vFields As Variant
dim rs As AdoDb.Recordset
dim cnn As AdoDb.Connection
set cnn=New AdoDb.Connection
...
set rs= New AdoDb.Recordset
with rs
...
.Open sSqlSelect
end with
vFields=array("aField1","aField2","aField3")
vValues=array(aValue1,aValue2,aValue3)
rs.Update vFields,vValues
---------------------------------
For example, if the aFields it is a text field with size =2,
and aValue2 is a string with mora than 2 characters, the Update
method raise an error.
I can retrieve the exact field that raise the error?
Jan Hyde (VB MVP) - 18 Apr 2008 16:22 GMT
Dedalus <ulysse@email.it>'s wild thoughts were released on
Fri, 18 Apr 2008 07:04:54 -0700 (PDT) bearing the following
fruit:
>I have this situation:
>
[quoted text clipped - 22 lines]
>method raise an error.
>I can retrieve the exact field that raise the error?
You already have a thread here for this, please don't start
new ones.
--
Jan Hyde
https://mvp.support.microsoft.com/profile/Jan.Hyde
Dedalus - 20 Apr 2008 11:50 GMT
On 18 Apr, 17:22, "Jan Hyde (VB MVP)"
<StellaDrin...@REMOVE.ME.uboot.com> wrote:
> You already have a thread here for this, please don't start
> new ones.
> --
> Jan Hyde
>
> https://mvp.support.microsoft.com/profile/Jan.Hyde
It is a no intentional error. I'm sorry.