>This is what I think happens...
>Views/cursors are effectively dbf files with a .tmp extension, but the first part of the tmp file is created when the view requested, so when the second opening occurs, the .tmp filename is different from the first, hence we don't get the "File is in use" message.
Hi Alan,
A view is just a cursor created with SELECT-SQL. VFP may as well check in advance to see if an alias already exists and assign default one, if it does.
--sb--