>>I strongly recommend you use a view. This makes updating quite easy: save data with TableUpdate(), und changes with TableRevert().
>>
>>For indexing, you can either 1) create indices in the local disk, for instance, in the folder getenv("windir") + "\temp", 2) create index names with function sys(2015).
>>
>>Hilmar.
>
>Hi, Hilmar
>
>In creating tmp file I'm using CREATE CURSOR tmp file so that if I close all the app. , the tmp file would be deleted, I've never use a VIEW before, could you tell me how make it.

A cursor is a query that can be modified - and changes are written back to the underlying tables.

See chapter 8, "Creating Views", in the Programmer's Guide (VFP 6), for details.

For a quick start, open your database in the project manager, select "local views", and click on "New" (you need a database to work with views). The view designer is almost identical to the query designer, but in addition, you need to specify update criteria. To save changes, don't forget to activate the "Master switch", labelled: "Send SQL Updates".

HTH, Hilmar.
>
>The index way you gave me worked fine, thanks.

I think you have to explicitly delete the index.