SQL语句问题

[kojiang]

根据用户选择的年月生成表名，然后放到变量table_name中，执行语句
select XXX into :abc from :table_name；出错，该怎么处理表名的问题？

[pbtech]

"+table_name+"

[klbt]

用动态SQL语句执行。

[kojiang]

如果用：
string aaa
aaa="select XXX from " + table_name
execute immediate :aaa;的话就无法将XXX的值保存到变量中了

[kojiang]

动态语句看的头晕，哪位大虾能给出语句让俺学习一下!

[double22822]

string ls_sql
ls_sql = "select XXX into " +abc+" from " +table_name
execute immediate :ls_sql;

[HooHu]

老兄，应该用连接符号啊

[371xingxiu]

string ls_sql
ls_sql = "select XXX into " +abc+" from " +table_name
execute immediate :ls_sql;

[annyzgf]

integer Intvar
Sqlstatement = " select XXX from "+table_name
PREPARE SQLSA FROM :Sqlstatement ;
DESCRIBE SQLSA INTO SQLDA ;
DECLARE my_cursor DYNAMIC CURSOR FOR SQLSA ;
OPEN DYNAMIC my_cursor USING DESCRIPTOR SQLDA ;
FETCH my_cursor USING DESCRIPTOR SQLDA ;

CHOOSE CASE SQLDA.OutParmType[1]

CASE TypeString!
abc= GetDynamicString(SQLDA, 1)
END CHOOSE

[liliang800207]

用动态sql语句

[kojiang]

我用的是Access

string ls_sql
ls_sql = "select XXX into " +abc+" from " +table_name
execute immediate :ls_sql;
语句执行错误，因为abc的值被代入了ls_sql中

CHOOSE CASE SQLDA.OutParmType[1]，提示数组越界的错误

小弟心急如焚，望各位大虾再伸援手，不吝赐教！