At 08:00 AM 11/4/2009, Dennis McGrath wrote:
Razzak,
Just to clarify.
I can have the DB open and change QUALCOLS on the fly?
So the following code would work without any problem
SET QUALCOLS 10 -- change to page locking
UPDATE whatever
SET QUALCOLS 2 -- change to row locking
Very correct, Dennis!
To observe the actual difference, if you are using the latest
version and updates of R:BASE 7.6 or Turbo V-8, you can try
the following ...
-- R:BASE 7.6 for Windows (Build:7.6.8.31102 or higher)
-- R:BASE Turbo V-8 for Windows (Build:8.0.22.31102 or higher)
SET FEEDBACK ON
SET QUALCOLS 10 -- change to page locking
UPDATE whatever
SET QUALCOLS 2 -- change to row locking
SET FEEDBACK OFF
CLS
Very Best R:egards,
Razzak.
