100分赠送

[zgb888]

我想写个传递表列名为变量的sql函数，应怎么写
我实在想不出好的办法，请大虾指点

[runsoft]

动态SQL了呀
string ls_sql = "select " + ls_column01 + " from table "

[zfisher]

同意啊！

[chrisfy]

不明白楼主的真正用意

[eastpond]

up

[zgb888]

和我用的方法一样，就是执行结果不对，请楼上的给检查一下
string mysql1
mysql1="select "+cell1+" into :Tcell1 " &
+" from table_102_ls " &
+" where c6666=:blsbz"
execute immediate :mysql1 using sqlca;

[arich]

定义存储过程

select name from syscolumns where id = objectid("<表名>")

[klbt]

动态SQL语句
string mysql1

mysql1="select "+cell1+" into :Tcell1 " &
+" from " + tablename &
+" where c6666=:blsbz"
execute immediate :mysql1 using sqlca;

[freeliu]

带输入输出参数的sql语句应该用动态sql的第三种语法，可以查pb的帮助，关键字是dynamic。

[jdsnhan]

ls_mysql = " select " + cell1 + " from "&
+ ls_tabel + " where " + ls_where

DECLARE lc_cur DYNAMIC CURSOR FOR SQLSA;
PREPARE SQLSA FROM :ls_mysql;
DESCRIBE SQLSA INTO SQLDA;
OPEN DYNAMIC lc_cur USING DESCRIPTOR SQLDA;
FETCH lc_cur into :celll;// USING DESCRIPTOR SQLDA;
messagebox('',celll)
CLOSE lc_cur;
看看是不是你要的结果

[jdsnhan]

补充说明 ls_where = "c6666 = '" + blsbz + "'"