>I have a problem using the ISEXCLUSIVE( ) function. Here's a simple example of what happens. I use a table exclusive. Next I execute a SQL Select statement using the same table. If I them issue the isexclusive() function using the table name it returns .T.. Now if I display Stat the table is open twice, the second instance is readonly. If I try to pack the table I get the error message "File is open in another work area". Am I going about this the wrong way using the isexclusive() function? How can I tell when it's safe to pack the table?
>
>*Example Code from the command line
>
>Use test_table exclusive
>
>Select * from test_table
>
>display stat && (You can see the table is open twice)
>
>? isexclusive("test_table") &&( Returns a .T. showing the table is open exclusive)
>
>pack && (Get the File open in another work area error.)
>
>? "HELP"
>
>TIA

Tia, per your example your trying to pack a cursor which can't be done. If all you want to do is pack the table, remove the select statement and it will woprk fine.