>Dear Sir,
>
>I have some more questions in the light of your replies.
>
>1) Should I conntiune DataEnvironment or Should I use Free Tables.
>2) Where Should I use TAG's for indexing? In main prg or Load Event of every Form.
>
>Please Help again
1. Depends on your application, really.
2. The Index command is used
ONLY in two scenarios:
a. Use the index command on cursors like you normally do. The same for temporary local tables, which usually can, and should, be cursors after all.
b. Except for a., you ONLY use the index command to create permanent index tags. If you need for instance an index for lastname, you use the command
Index on lastname tag lastname. Once an index tag is created, there is NEVER a need to crete it again, I repeat never, unless you have a crash.
If you regularly use the Index command in your programs for anything other than cursors or local temporary tables, you have a serious design problem.
The only exception to these rules that I can think of right now, is for maintainance where 2b. applies.