Query TOO COMPLEX

Here is a code snipet that produces a "too complex" error message

Set DsgnData = New ADODB.Recordset
sql = "Select * from dsgndata where coilspec = '" & CoilSpec & "'"
With DsgnData
.Source = sql
.CursorLocation = adUseClient
.CursorType = adOpenDynamic
.LockType = adLockOptimistic
.ActiveConnection = OrdMntCnn
.Open
End With

DsgnData("rkva") = kva3 ====> 750
DsgnData("tapdesc") = atap ====> "NO TAP"
DsgnData("secdesc") = asec =====> "SOMETHING ELSE"
DsgnData.Update ====> Query too complex

Why is this "TOO COMPEX" and how can I get around it with out implementing a
SQL UPDATE query.

usually means data types aren't matching or a text filed is too small for
what you are inserting


mike w.

"Darrell Wesley" wrote:

 > Here is a code snipet that produces a "too complex" error message
 >
 > Set DsgnData = New ADODB.Recordset
 > sql = "Select * from dsgndata where coilspec = '" & CoilSpec & "'"
 > With DsgnData
 > .Source = sql
 > .CursorLocation = adUseClient
 > .CursorType = adOpenDynamic
 > .LockType = adLockOptimistic
 > .ActiveConnection = OrdMntCnn
 > .Open
 > End With
 >
 > DsgnData("rkva") = kva3 ====> 750
 > DsgnData("tapdesc") = atap ====> "NO TAP"
 > DsgnData("secdesc") = asec =====> "SOMETHING ELSE"
 > DsgnData.Update ====> Query too complex
 >
 > Why is this "TOO COMPEX" and how can I get around it with out implementing a
 > SQL UPDATE query.
 >
 >
 ><!-- ~MESSAGE_AFTER~ -->