Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 264
  • Last Modified:

ASP VBScript command object lockPessimistic

I'm using a command object to pass 35 parameters to an Access database stored procedure, using the ".Execute" command. Does the command object not have a lockPessimistic property the way a recordset does?
0
tom_burkhardt
Asked:
tom_burkhardt
  • 3
  • 2
1 Solution
 
Data-ManCommented:
no ADO does not have a lock pessimistic property....Mike
0
 
tom_burkhardtAuthor Commented:
thanks. I didn't think so. Any idea what happens if someone else makes a change at the same time? There must some default read type/lock type for the command object (I'm using an implicit connection, rather than going through a connect object).
0
 
Data-ManCommented:
I usually send over the timestamp field and compare that to the current timestamp to ensure that the record hasn't changed before doing the update.

Mike
0
 
tom_burkhardtAuthor Commented:
Thanks!!
0
 
Data-ManCommented:
Use the return value to pass back a failure...0 if it worked.

Mike
0

Featured Post

Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now