急急急！！！！动态sql中的selectblob问题？

[jackylam]

急急急！！！！动态sql中的selectblob问题？
程序如下：
ls_temp = '000000000223'
ls_sql = "selectblob zp0000 into :lb_temp from sy_student_photo where subid0 = ?"

PREPARE SQLSA FROM :ls_sql USING sqlca;
EXECUTE SQLSA USING :ls_temp;
---此处返回的sqlca.sqlcode = -1
if sqlca.SQLCODE = 0 THEN
p_1.setpicture(lb_temp)
end if
---有没有解决的办法？
动态sql中是否支持selectblob???

[fibbery]

用嵌入式sql语句就行了，不用动态的
selectblob zp0000
into :lb_temp
from sy_student_photo
where subid0 =:ls_temp；

[fibbery]

楼主对四种动态sql语句应用的条件还不太了解，应该看看帮助，第四种功能最强大，一般用到第三种就能解决绝大部分需求了。

[waterstony]

如果后台是sqlserver：

sqlca.autocommit = true

selectblob zp0000
into :lb_temp
from sy_student_photo
where subid0 =:ls_temp；

sqlca.autocommit = false

[freeliu]

ls_sql = "selectblob zp0000 from sy_student_photo where subid0 = ?"

PREPARE SQLSA FROM :ls_sql USING sqlca;
EXECUTE SQLSA USING :ls_temp;
fetch sqlsa into :lb_temp;
---此处返回的sqlca.sqlcode = -1
if sqlca.SQLCODE = 0 THEN
p_1.setpicture(lb_temp)
end if

[jackylam]

如果里面的字段和表名都是变量怎么办？
比如：
ls_sql = 'selectblob ' + ls_column_name + ' into :lb_temp from ' + ls_table_name + 'where subid0 = ?'

请继续指教

[tchj99]

ls_sql = "selectblob "+fieldname+" from "+tablename +" Where " +fieldname +" ="+ls_temp
declare mycursor dynamic cursor for sqlsa;
prepare sqlsa from :ls_sql using tran;
open dynamic mycursor;
fetch mycursor into :lb_temp;
close mycursor;
试试行不行

[tarky_z]

to：水煮活鱼，不幸地告诉你，selectblob不支持动态的sql。我遇到过和你一样的问题：表名和字段名都是变量。最后的方法是写个函数，choose case 一个一个解决。好像很笨，但是确实没有其他办法:)

[大雄之家]

如果后台是sqlserver：

sqlca.autocommit = true

selectblob zp0000
into :lb_temp
from sy_student_photo
where subid0 =:ls_temp；

sqlca.autocommit = false

或者试试
ls_sql = "selectblob "+fieldname+" from "+tablename +" Where " +fieldname +" ="+ls_temp
declare mycursor dynamic cursor for sqlsa;
prepare sqlsa from :ls_sql using tran;
open dynamic mycursor;
fetch mycursor into :lb_temp;
close mycursor;
看行不行呀！

[sun2927]

up

[jackylam]

以上各位大虾给的方法都试过了，还是不行啊，怎么办，救救我啊。