大家好:我在FM里想用一个时间参数select ...From RDSL_BUYERINFO_INCREMENT_MODIwhere intime=#prompt('begindate','date')# group by area_code然后报The query contains an error.You can save the object and edit it later, but other objects that reference it m...
显示全部
大家好:
我在FM里想用一个时间参数
select ...
From
RDSL_BUYERINFO_INCREMENT_MODI
where intime=#prompt('begindate','date')#
group by area_code
然后报The query contains an error.
You can save the object and edit it later, but other objects that reference it may be affected by this update.
Do you wish to save your changes?
RQP-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-9'.
UDA-SQL-0107 A general exception has occurred during the operation "prepare".
ORA-00932: inconsistent datatypes: expected DATE got NUMBER 这样的错误
这个意思是说期望一个日期类型但是是数值类型么。
可我的传的类型就是日期的啊。
这个可以怎么修改下啊。。谢谢大家啊。。
收起