>>A view is always opened exclusively, regardless of the lock status of the underlying table(s).
>
>So a view shouldn't be used in a record search procedure if the environment is multi-user?
Fundamentally, a view is just the result of a SELECT - SQL statement. Its contents are valid as at the instant it was opened.
You can refresh a view's contents (basically cause its underlying SELECT - SQL to be run again) by using the REQUERY() function.
If you REQUERY(), you don't need to regenerate your indices, they will still be in effect.
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up
