>>Hi Jayesh, have question again
>>
>>If my file is setting order to "COMPANY_NAME",
>> do i need to set the order to "ORDER_NO" before run SQL ...WHILE ORDER_NO="12345"
>>
>>****************
>>
>>I want make temp. file name from sys(3) and come with a alias name = "T_ASS2"
>>
>>I have coding as below :
>>
>>
>>III = SYS(3)+".DBF"
>>
>>SELECT * FROM order_items
>>WHERE order_no == "12345"
>>INTO TABLE &III
>>
>>
>>***how to addin the alias name = "T_ASS2"
>Immediately following your select statement
>issue...
>USE (III) ALIAS T_ASS2
Unless you need to keep the temp file for other reasons, it is much better to use...
SELECT * FROM order_items WHERE order_no == "12345" INTO CURSOR T_ASS2
This way the file is automatically deleted upon exiting or closing of the file, otherwise you will need to have some way of cleaning up your temp files that will wind up cluttering your system.
>>