|
我的脚本中(PB8.0)用了动态sql:
string ls_syntax,ls_serialno,ls_newno
ls_syntax = "select max("+as_colname+") from "+as_tabname+""
declare serial dynamic cursor for sqlsa;
prepare sqlsa from :ls_syntax;
open dynamic serial;
if sqlca.sqlcode<>0 then
MessageBox('提示','取序号错误:'+sqlca.sqlerrtext)
close serial;
return ''
end if
fetch serial into :ls_serialno;
close serial;
报错,sqlerrtext的值为:SQLSTATE=S1C00 [MicroSoft][ODBC MicroSoft Access 驱动程序]可选的功能未实现
是不是ODBC不支持游标或是动态SQL??[em02][em02] |
|