>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"
PMFJI, but you do not need to set the order or even USE the table. The SQL-Select command will do both. Rushmore looks at ALL the available index tags and uses the tags that will make the SQL-Select run the fastest.
>****************
>
>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"
Try this code:
III = SYS(3)+".DBF"
select * from order_items;
WHERE order_no == "12345";
into Table (III)
use (III) again in 0 alias "T_ASS2"
From then on, you can use the T_ASS2 table.
HTH
Barbara