>Hi All,
>
>I have a form which I set index for three columns. The first time I ran the form is O.K. Second attempt, VFP said "File is in used", so I erased the three .idx using the ERASE command before recreating the .idx again in the init() and close the table before exiting. It works fine, but I totally forgot other forms also required the table I just closed. How could I solved this problem? TIA
Is there any particular reason for you not using permanent indices (CDX)?
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)