请教 RQP-DEF-0177'sqlPrepareWithOptions' status='-16'

各位大侠请教一下,我增加了两个下拉框,然后在过滤条件里面加了一条
IF ( ?Qty? ='Green'  and  ?CATAGORY?='RSCQTY') THEN
    ( [RSCQTY] >0)
ELSE
    ( [RSCQTY] = 0 )

执行后报错如下:
An error occurred while performing operation 'sqlPrepareWithOptions' status='-16'.
UDA-SQL-0358 Line 25: Syntax error near ">". RSV-SRV-0042 Trace back: RSReportService.cpp(747): QFException: CCL_CAUGHT: RSReportService::process() RSReportServiceMethod.cpp(217): QFException: CCL_RETHROW: RSReportServiceMethod::process(): promptPagingForward_Request RSASyncExecutionThread.cpp(690): QFException: RSASyncExecutionThread::checkException RSASyncExecutionThread.cpp(204): QFException: CCL_CAUGHT: RSASyncExecutionThread::run(): promptPagingForward_Request RSASyncExecutionThread.cpp(740): QFException: CCL_RETHROW: RSASyncExecutionThread::processCommand(): promptPagingForward_Request Execution/RSRenderExecution.cpp(570): QFException: CCL_RETHROW: RSRenderExecution::execute Assembly/RSDocAssemblyDispatch.cpp(251): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly Assembly/RSLayoutAssembly.cpp(63): QFException: CCL_RETHROW: RSLayoutAssembly::assemble Assembly/RSDocAssemblyDispatch.cpp(317): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForward Assembly/RSReportPagesAssembly.cpp(163): QFException: CCL_RETHROW: RSReportPagesAssembly::assemble Assembly/RSDocAssemblyDispatch.cpp(268): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly Assembly/RSPageAssembly.cpp(284): QFException: CCL_RETHROW: RSPageAssembly::assemble Assembly/RSDocAssemblyDispatch.cpp(268): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly Assembly/RSTableRowAssembly.cpp(154): QFException: CCL_RETHROW: RSTableRowAssembly::assemble Assembly/RSDocAssemblyDispatch.cpp(268): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly Assembly/RSTableCellAssembly.cpp(108): QFException: CCL_RETHROW: RSTableCellAssembly::assemble Assembly/RSDocAssemblyDispatch.cpp(317): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForward Assembly/RSTableAssembly.cpp(89): QFException: CCL_RETHROW: RSTableAssembly::assemble Assembly/RSDocAssemblyDispatch.cpp(317): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForward Assembly/RSTableRowAssembly.cpp(154): QFException: CCL_RETHROW: RSTableRowAssembly::assemble Assembly/RSDocAssemblyDispatch.cpp(268): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly Assembly/RSTableCellAssembly.cpp(108): QFException: CCL_RETHROW: RSTableCellAssembly::assemble Assembly/RSDocAssemblyDispatch.cpp(317): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForward Assembly/RSAssembly.cpp(610): QFException: CCL_RETHROW: RSAssembly::createListIterator Assembly/RSAssembly.cpp(651): QFException: CCL_RETHROW: RSAssembly::createListIterator RSQueryMgr.cpp(952): QFException: CCL_RETHROW: RSQueryMgr::getListIterator RSQueryMgr.cpp(1019): QFException: CCL_RETHROW: RSQueryMgr::getResultSetIterator RSQueryMgr.cpp(1165): QFException: CCL_RETHROW: RSQueryMgr::createIterator RSQueryMgr.cpp(1475): QFException: CCL_RETHROW: RSQueryMgr::executeRsapiCommand RSQueryMgr.cpp(1462): QFException: CCL_RETHROW: RSQueryMgr::executeRsapiCommand RSQueryMgrExecutionHandlerImpl.cpp(172): QFException: CCL_RETHROW: RSQueryMgrExecutionHandlerImpl::execute() RSQueryMgrExecutionHandlerImpl.cpp(164): QFException: CCL_RETHROW: RSQueryMgrExecutionHandlerImpl::execute() RSQFSession.cpp(241): QFException: CCL_RETHROW: RSQFSession::DoRequest QFSSession.cpp(604): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest() QFSSession.cpp(602): QFException: CCL_CAUGHT: QFSSession::ProcessDoRequest() QFSSession.cpp(551): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest() QFSConnection.cpp(737): QFException: CCL_RETHROW: QFSConnection::Execute QFSQuery.cpp(117): QFException: CCL_RETHROW: QFSQuery::Execute v2 CoordinationQFSQuery.cpp(3775): QFException: CCL_THROW: CoordinationPlanner
参与5

4 同行回答

蔷薇-不懂 蔷薇-不懂 其它 **软通**
我的类似又不是这个,哎~显示全部
我的类似又不是这个,哎~ 收起
互联网服务 · 2012-09-14
浏览1137
macherater macherater 软件开发工程师 塔塔信息技术中国公司
http://www.cognoschina.net/club/thread-13222-1-1.html楼上的兄弟,看看这个帖子,跟你一样的错误显示全部
http://www.cognoschina.net/club/thread-13222-1-1.html

楼上的兄弟,看看这个帖子,跟你一样的错误 收起
互联网服务 · 2011-03-28
浏览1065
macherater macherater 软件开发工程师 塔塔信息技术中国公司
http://www.cognoschina.net/club/thread-13222-1-1.html楼上的兄弟,看看这个帖子,跟你一样的错误显示全部
http://www.cognoschina.net/club/thread-13222-1-1.html

楼上的兄弟,看看这个帖子,跟你一样的错误 收起
互联网服务 · 2011-03-28
浏览1091
macherater macherater 软件开发工程师 塔塔信息技术中国公司
http://www.cognoschina.net/club/thread-13222-1-1.html楼上的兄弟,看看这个帖子,跟你一样的错误显示全部
http://www.cognoschina.net/club/thread-13222-1-1.html

楼上的兄弟,看看这个帖子,跟你一样的错误 收起
互联网服务 · 2011-03-28
浏览1129

提问者

wojiushipizi
软件开发工程师 IBM
评论49

相关问题

相关资料

问题状态

  • 发布时间:2011-03-23
  • 关注会员:1 人
  • 问题浏览:5283
  • 最近回答:2012-09-14
  • X社区推广