hi,
2.thank you, ok , but my table main1 need to creat index for every new main1
maybe i need to create main1 more one time daily,

2.some thing else i need your advise or your way to use all tables as excl off , when many users use my project (mean sharing).
somthing as under, and how i can call any tables to work area at any form or application i create

close all
*SET SAFETY off
SET EXCLUSIVE on
USE main1 IN 0
INDEX ON flag tag FLAG
USE main2 IN 0
USE trans1 IN 0

thanks alot.


>Mohammad, remember Help is your friend! To create an index tag, you must use the table exclusive. But, you normally create index tags only ONCE, there is no need to create an index tag oer and over! If you need a temporarily index, you don't use the TAG option, you just index to a temp file, and delete the temp file afterwards.
>
>>hi all,
>>
>>
>>i try as under , igot error message file must open excl
>>

>>SET SAFETY off
>>SET EXCLUSIVE off
>>SELECT 1
>>USE main1
>>*use main1 in 0
>>INDEX ON flag tag FLAG
>>

>>thanks