Ado Recordset Update method an Status fields property
- From: Dedalus <ulysse@xxxxxxxx>
- Date: Mon, 21 Apr 2008 09:19:51 -0700 (PDT)
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
.
- Follow-Ups:
- Prev by Date: RE: Reading text files with ADO - missing record
- Next by Date: Re: Ado Recordset Update method an Status fields property
- Previous by thread: Reading text files with ADO - missing record
- Next by thread: Re: Ado Recordset Update method an Status fields property
- Index(es):
Relevant Pages
|
Loading