在PB程序中写了一sql但连MySQL数据库运行时总是出错,数据库结构没问题SQL如下
select sum( xf_tenderledger.xf_baseamount )
from xf_tenderledger
where xf_tenderledger.xf_storecode = 'C001'
and xf_tenderledger.xf_tillid = '01'
and xf_tenderledger.xf_txdate = '2009-7-21 00:00:00' ; 出的错误提示如下:
SQLSTATE = 37000
[MySQL][ODBC 5.1 Driver][mysqld-5.0.45-community-nt]FUNCTION ttdb.sum does not exist请各位高手指点
select sum( xf_tenderledger.xf_baseamount )
from xf_tenderledger
where xf_tenderledger.xf_storecode = 'C001'
and xf_tenderledger.xf_tillid = '01'
and xf_tenderledger.xf_txdate = '2009-7-21 00:00:00' ; 出的错误提示如下:
SQLSTATE = 37000
[MySQL][ODBC 5.1 Driver][mysqld-5.0.45-community-nt]FUNCTION ttdb.sum does not exist请各位高手指点
然后看一下PB执行的语句到底是什么?
select ttdb.sum( xf_tenderledger.xf_baseamount )
from xf_tenderledger
where xf_tenderledger.xf_storecode = 'C001'
and xf_tenderledger.xf_tillid = '01'
and xf_tenderledger.xf_txdate = '2009-7-21 00:00:00' ;改用PB的动态执行语句吧.我现在很不喜欢用PB,就是它这种画蛇添足功能.
你转到PB版里问一问吧