以下是在datawindow下面的代码，我把这段代码去掉条件后，在sql的查询分析器中执行是没有问题的，但是在我要保存该数据窗口时，就会报这个错了: 第1行:'.'附近有语法错误 ;
SELECT "PO"."POID",
"PO"."INDATE",
"PO"."SUPPID",
"PO"."SUPPLIER",
"POPROD"."PRODID",
"POPROD"."PRODSHORT",
"POPROD"."UNITID",
"POPROD"."QUANTITY",
"POPROD"."XH",
"POPROD"."COMEFROM",
"POPROD"."PRODUCT",
"POPROD"."RATIO"
FROM "PO", "POPROD"
WHERE ( "PO"."POID" = "POPROD"."POID" ) and
( "PO"."COMPANYID" = "POPROD"."COMPANYID" ) and
( ( po.companyid = :as_companyid ) AND
( "POPROD"."STATUS" = :as_status ) ) AND PO.BELONGSTKS like '%'||:as_stk||'%'
ORDER BY "PO"."POID" ASC,
"POPROD"."XH" ASC
是什么原因呢，急！！！
------解决方案--------------------
SELECT PO.POID,
PO.INDATE,
PO.SUPPID,
PO.SUPPLIER,
POPROD.PRODID,
POPROD.PRODSHORT,
POPROD.UNITID,
POPROD.QUANTITY,
POPROD.XH,
POPROD.COMEFROM,
POPROD.PRODUCT,
POPROD.RATIO
FROM PO, POPROD
WHERE ( PO.POID = POPROD.POID ) and
( PO.COMPANYID = POPROD.COMPANYID ) and
( ( po.companyid = :as_companyid ) AND
( POPROD.STATUS = :as_status ) ) AND PO.BELONGSTKS like '%'||:as_stk||'%'
ORDER BY PO.POID ASC,
POPROD.XH ASC