How do I read data without locking the data?

General speaking, the select command will lock data in SHARE lock. If you do not want to lock the data, you can use the SELECT ... FOR BROWSE command. This won't do any lock action. It is called a dirty read or browse read.

Copyright 1999-2001 CASEMaker Inc. All rights reserved.
Comments or questions about our web site? Please write the webmaster.
Terms and Conditions | User Privacy Statement