04-14-2013 05:43 PM
I want to add new records to existing sas table using ADO and iom.provider.
I have no problem with doing so when table has no constraints - the problem begins when record being added violates integrity constraints.
I try to connect in an usuall way by:
rs.Open TableName, , adOpenStatic, adLockPessimistic, adCmdTableDirect
do until rs.EOF
rs.field1 = value1
rs.field2 - value2
The system returns error on rs.update and what's irritating - rs is no longer available and table is remains locked - there is no possiblity to cancel update so that the table would not remain locked - i tried rs.cancelupdate and rs.close but with no success.
Am I doing something wrong?