>>Hilmar,
>>
>>>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".
>>
>>What about in a free table,'Cause I didn't use a database table.
>>
>>>I think you have to explicitly delete the index.
>>
>>I've check in the folder "c:\windows\temp", the index file dissapear automatically after I close the app.
>>Here is the index :
>>
>>sele tmpalias
>>idx=getenv('temp')+'\'+sys(2015)+'.idx'
>>inde on size to &idx
>>
>>regards,
>>
>>Budianto
>
>
>Budianto,
>
>You can only index a cursor on a field that has unique data. Like this..
>

Create Cursor myCursor(myfield1 c(10) unique, myfield2)
>set order to myfield1
>
>set relationship to myField1 into mytable
>
>

>
>Now you have a relationship between your cursor and your table on myfield1
>
>Hope this helps
>
>

from the help File for VFP 7
>
>UNIQUE
>Creates a candidate index for the field. The candidate index tag has the same
name as the field.
>
>For more information about candidate indexes, see Index Information Display
and Setting a Primary or Candidate Index.
>
>Note: Candidate indexes (created by including the UNIQUE option) are not the
same as indexes created with the UNIQUE option in the INDEX command. An index
created with the UNIQUE option in the INDEX command allows duplicate index
keys; candidate indexes do not allow duplicate index keys.
>

Sorry about the Previous one.