Try this , it has variables declared at the beginning....

vOrderNo = 6048
vSampleText=''
vSampleNo=0
SELECT service.order_no as "orderno",;
servinv.mfg_part as "mfgpart",;
servinv.part_number as "desc",;
vSampleText as "sampleText",;
123 as "vSampleNo",;
servinv.qtyord,servinv.new_used;
FROM sys2000!servinv INNER JOIN sys2000!service ;
ON servinv.sonum = service.order_no ;
WHERE service.order_no = vOrderno ;
ORDER BY servinv.mfg_part;
INTO CURSOR parts NOFILTER

SELECT parts
brow

You can then use the cursor (or alias) and insert in anything you want in the 'temp' fields.

Bryan Holsmtrom