Ado Recordset Update method an Status fields property



I have this situation (the example code it is in visual basic 6):

Dim sSqlSelect As String
dim vFields() as variant
dim vValues() as variant
Dim cnn As ADODB.Connection

On Error GoTo ErrorHandler
....
Set cnn = New ADODB.Connection
cnn1.Open aConnectionString
Set rs = New ADODB.Recordset
With rs
.CursorLocation = adUseClient
.CursorType = adOpenKeyset
.LockType = adLockOptimistic
.Open aSqlSelect, cnn
End With

vFields= Array("Field1", "Field2", "Field3", "Field4")
vValues= Array(aValue1,aValue2, aValue3, aValue4)
rs.update vFields,vValues
....

If, for example, the Field3 is a string field with size equals to 2
and aValue3 is a string with lenght 30,
the update method raise an error.
I can find the field that have fired the error?
In other words, my question it may be this: using Ado .Update method
with notation that use 2 arrays, the .Status property in Fields
collection dont is supported?
Ciao
.



Relevant Pages


Loading