您所在位置：主题：查询问题.请教!~!!!!!
zaliang
[专家分：1010] 发布于 2006-04-24 09:12:00
我用DELPHI+ACCESS;
其中在执行下面的这条语句时,提示:floor函数未定义(在SQL查询器里面没问题);应当怎么该呢?floor在SQL中是无条件取整的意思;
select c.bh as 编号,m.HYKH as 会员卡号,HYXM as 会员姓名,XB as 性别,KLX as 会员卡类型,
c.HYDJ as 会员卡等级,SFJE as 消费金额,XFRQ as 消费日期,
[color=FF00FF]floor[/color](SFJE/10) as 所得积分,m.BZ as 备注说明,lxdh as 联系电话
from meminfo m,memconsume c, memrank r
where m.HYKH=c.HYKH and m.KDJ=r.BH
其中在执行下面的这条语句时,提示:floor函数未定义(在SQL查询器里面没问题);应当怎么该呢?floor在SQL中是无条件取整的意思;
select c.bh as 编号,m.HYKH as 会员卡号,HYXM as 会员姓名,XB as 性别,KLX as 会员卡类型,
c.HYDJ as 会员卡等级,SFJE as 消费金额,XFRQ as 消费日期,
[color=FF00FF]floor[/color](SFJE/10) as 所得积分,m.BZ as 备注说明,lxdh as 联系电话
from meminfo m,memconsume c, memrank r
where m.HYKH=c.HYKH and m.KDJ=r.BH
