Hi,
we are trying to update a table using ADO (2.6). We have a Sybase System 11 database.
The weird thing is, the rs.update works fine UNTIL we try to update a varchar-field in the table.
ex.
with rs
.fields("Status"
= 5
.fields("AuditDate" = Now
.update
end with
This works!
if I include for example:
.fields("AuditAction" = "M"
the update fails with an E-FAIL error.
Another weird thing is that it DOES work if we add a new record to the table.
Tried it with other tables, other fields,.... all the same.
Anybody an idea?
TIA
Vjee
we are trying to update a table using ADO (2.6). We have a Sybase System 11 database.
The weird thing is, the rs.update works fine UNTIL we try to update a varchar-field in the table.
ex.
with rs
.fields("Status"
= 5.fields("AuditDate"
= Now.update
end with
This works!
if I include for example:
.fields("AuditAction"
= "M"the update fails with an E-FAIL error.
Another weird thing is that it DOES work if we add a new record to the table.
Tried it with other tables, other fields,.... all the same.
Anybody an idea?
TIA
Vjee
