请教:视图查询连编前正常 连编后出1570错误 数据库只读
如题程序中出错的地方
sqltext = "SELECT Gum02.gub00c,Gum02.gub01c,'全部' as gub02c,Gum02.gub03i, Gum02.gub04c, Gum02.gub05c, Gum02.gub06c, Gum02.gub07c, Gum02.gub08f, Gum02.gub09d FROM dbo.gum02 Gum02 WHERE Gum02.gub00c = '" + tt0 + "' AND ( Gum02.gub01c = '" + xmdm + "' AND Gum02.gub02c IN (select top 1 Gum02.gub02c from gum02 Gum02 where Gum02.gub01c = '" + xmdm +"') )"
CREATE SQL VIEW gsa17i_cdsdzlcxn remote ;
connection line SHARE as &sqltext
单独执行sql正常
执行表单也正常
连编为exe执行就出错 报1570 数据库只读
[ 本帖最后由 njsaviour 于 2011-7-5 11:03 编辑 ]