>>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.

I guess I left a line out trying to simplify to much. Select the table before the pack statement. And the select statement would occur sometime during the program execution. Usually as a rowsource for a Combobox. Hope this helps.