You don't need Name expression in USE command because the 'temporer' is an alias not a variable
use temporer alias dtempo in 0
>I have code in my cmdbutton.click and running well:
>
>select StockId,qty,price,disc,pk from vInvdetail where qty<>0 into cursor temporer
>select temporer.*, nvl(stock.name,spac(30)) as cname from temporer;
> left join stock on temporer.stockId = stock.stockId into cursor temporer
>select * from temporer order by pk into cursor temporer
>use (temporer) alias dtempo in 0
>
>but my client always get this error:
>
>ERROR #:12
>MESSAGE: variable 'TEMPORER' is not found
>PROGRAM: PROCEDURE FFORM.CMD1.CLICK
>
--sb--