hi,
all tables i use is shared tables.

i mean how i can use all tables via main program,
and how i can call any table via any form .

thanks alot. if End of discussion or not.

>Analyze your application, and use cursors whenever possible. If main2 is shared, you use index tags, and create it only once, period!!!!!!! If that's not possible, you have started in the wrong end, and must reconsider your design. End of discussion!
>
>If main2 is NOT shared, store it locally and use it exclusive always.
>
>>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