nz函数在asp+access应用问题
程序运行环境是asp+access
执行这句老报错:set rs = conn.execute( "SELECT nz(Max(Ncmid),0)+1 as cmid FROM xixcm ")
报错提示是:错误类型:Microsoft JET Database Engine (0x80040E14)表达式中 'nz ' 函数未定义。
SELECT nz(Max(Ncmid),0)+1 as cmid FROM xixcm 这条查询在access调试中通过,很困惑了,请高手提示
[解决办法]
set rs = conn.execute( "SELECT IIF(ISNULL(Max(Ncmid)),1,Max(Ncmid)+1) as cmid FROM xixcm ")
是这个功能吗?