Q: What is Dirty Read and how is it used?

A:

1. DBMaker allows many users to access a database at the same time by using a lock technique. When a resource (like Table, Page or Record) is occupied by a user, when he or she executes the inset, update or delete command, it will lock other users out so the cannot do any operations with the resource. When constraints are on to prevent a user from executing operations in the resource, it is called "Dirty Read". Dirty Read command syntax is the select-statement FOR BROWSE.
2. When querying online data, using Dirty Read has more of an effect when data is accessed in select operations. It will prevent data locked situations in each operator.