vfp数据库sql语言问题

[ganzi01234]

SELECT so.so_po,so.so_date,soxact.sx_item ,;
IIF(IsEmpty(shipment.ms_code),soxact.sx_etd,shipment.ms_etd), ;
soxact.sx_qty,soxact.sx_unit,soxact.sx_loc,invo.io_date,invo.io_code, ;
inxact.ix_qty,inxact.ix_unit, ;
iif(inxact.ix_unit=sx.sx_unit,sx.sx_qty-inxact.ix_qty,iIf(inxact.ix_unit="PCS",(sx.sx_qty)*2-inxact.ix_qty,(inxact.ix_qty)*2-sx.sx_qty)), ;
so.so_footer,so.so_no;
FROM so;
INNER JOIN soxact;
ON so.so_code=soxact.sx_code;
inner join shipment;
on so.so_code=shipment.ms_code;
inner join invo;
on so.so_code=invo.io_code;
INNER JOIN inxact;
ON so.so_code=inxact.ix_so;
inner cursor temprep NOFILTER
这几句为什么报错？

[ganzi01234]

报错是报syntax error

[wwwwb]

SELECT so.so_po,so.so_date,soxact.sx_item ,;
IIF(IsEmpty(shipment.ms_code),soxact.sx_etd,shipment.ms_etd), ;
soxact.sx_qty,soxact.sx_unit,soxact.sx_loc,invo.io_date,invo.io_code, ;
inxact.ix_qty,inxact.ix_unit, ;
iif(inxact.ix_unit=sx.sx_unit,sx.sx_qty-inxact.ix_qty,iIf(inxact.ix_unit="PCS",(sx.sx_qty)*2-inxact.ix_qty,(inxact.ix_qty)*2-sx.sx_qty)), ;
so.so_footer,so.so_no;
FROM so;
INNER JOIN soxact;
ON so.so_code=soxact.sx_code;
inner join shipment;
on so.so_code=shipment.ms_code;
inner join invo;
on so.so_code=invo.io_code;
INNER JOIN inxact;
ON so.so_code=inxact.ix_so;
inner cursor temprep NOFILTER?
是INTO？
INTO　cursor temprep

如果是INNER　JOIN，
inner JOIN　temprep　ON　。。。　INTO　。。。

[十豆三]

最后一行
inner cursor temprep NOFILTER

改为

into cursor temprep NOFILTER