created the code below to pass back to a report

[Terris]

How do I get the cursor available in the data environment so that I can join fpartno and fpartrev to another cursor that already exists in the data environment?

lnHandle = CURSORGETPROP("ConnectHandle","inonhd&quot

lcsql='SELECT inonhd.fpartno, inonhd.fpartrev, sum(inonhd.fonhand) AS fonhand ' + ;
'FROM inonhd JOIN inloca ON inonhd.flocation = inloca.flocation ' + ;
"WHERE INLOCA.FCMRPEXCL = 'N' " + ;
'GROUP BY inloca.fcmrpexcl, inonhd.fpartno, inonhd.fpartrev '

lnReturn = SQLEXEC(lnHandle, lcSQL, 'tnetonhd')
SELECT tnetonhd
=AFIELDS(laitem,'tnetonhd')
SELECT 0
CREATE CURSOR netonhd FROM ARRAY laitem
SELECT * FROM tnetonhd INTO CURSOR netonhd