>if anyone can advise what is wrong with the code below... i am trying to empty a table and can't get the exclusive use set to off again once it is packed...
>SELECT book
>if reccount()>0
> USE book excl
> DELETE ALL
> PACK
> SET EXCLUSIVE OFF

 USE Book AGAIN SHARED>endi
>
>many thanx!

EMail: EdR@edrauh.com
"See, the sun is going down..."
"No, the horizon is moving up!"
 - Firesign Theater

NT and Win2K FAQ .. cWashington WSH/ADSI/WMI site
MS WSH site ........... WSH FAQ Site
Wrox Press .............. Win32 Scripting Journal
eSolutions Services, LLC

The Surgeon General has determined that prolonged exposure to the Windows Script Host may be addictive to laboratory mice and codemonkeys