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