Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Error in ADO command
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00488113
Message ID:
00488147
Views:
13
Think i found the problem.

When I open the recordset, i have to specify the type of locking it will use, i appended the following line to my code:

#DEFINE adLockBatchOptimistic 4

and then wrote again the opn statement:

adRecordset.OPEN("select * from schema.table order by field",;
adConnection,adOpenDynamic,adLockBatchOptimistic)

I changed some values, issued an UPDATEBATCH and everything worked just fine!

Anyway, thanks for taking your time to help me!
Like Frank said: "I did it... MY WAY!"
Previous
Reply
Map
View

Click here to load this message in the networking platform