Jim,

NOFILTER was available with version 6. I remember because I used it a lot on my last job and that was the highest version of VFP they ever got.

Dana

>Hi Robin,
>
>Do you have a SELECT on the same table (and only that table... no others involved in the SELECT)?
>If so, you may have a filtered result set on your hands... behind the scenes the table itself is used with a filter to provide the equivalent of teh "result set".
>
>You can use the NOFILTER clause on the SELECT if you are using VFP7 or later.
>
>good luck
>
>
>>Hi! My form opens a table in its dataenviroment exclusively, something in my form is opening the table again and gets an alias of W17? I can't find any code in the methods that opens the table?
>>
>>I want to do a pack but can't because the table is open twice?
>>
>>Any ideas extremeley appreciated