请问专家:
我用ODBC建立了一个SQL SERVER连接,使用下列程序插入一条记录,为什么没有写入成功?不知道错误出在哪里?Tableupdate(.T.)返回值是true,但是SQL 数据表中没有该记录。
create sql view xsxkvi remote connection conect1 as select * from xsxk where xh='0790790'
use xsxkvi
brow
=DBSetProp('xsxkvi',"View","SendUpdates",.T.)
=DBSetProp('xsxkvi',"View","BatchUpdateCount",1)
=DBSetProp('xsxkvi',"View","UpdateType",1)
=DBSetProp('xsxkvi',"View","Tables","dbo.xsxk")
=DBSetProp('xsxkvi',"View","WhereType",3)
=DBSetProp("xsxkvi.xh","Field","UpdateName","xh")
=DBSetProp("xsxkvi.xh","Field","KeyField",.T.)
=DBSetProp("xsxkvi.xh","Field","Updatable",.T.)
=DBSetProp("xsxkvi.keh","Field","UpdateName","keh")
=DBSetProp("xsxkvi.keh","Field","KeyField",.T.)
=DBSetProp("xsxkvi.keh","Field","Updatable",.T.)
=DBSetProp("xsxkvi.Bji","Field","UpdateName","Bji")
=DBSetProp("xsxkvi.Bji","Field","KeyField",.T.)
=DBSetProp("xsxkvi.Bji","Field","Updatable",.T.)
=DBSetProp("xsxkvi.xb","Field","UpdateName","xb")
=DBSetProp("xsxkvi.xb","Field","KeyField",.T.)
=DBSetProp("xsxkvi.xb","Field","Updatable",.T.)
=CURSORSETPROP("Buffering", 5, "XSXKVI")
insert into xsxkvi (xh,keh,bji,xb) values ('0790790','1034','1255','JCX')
=TableUpdate(.T.)
-
十豆三 回复于:2008-06-16
-
怎么所有字段都是
,"Field","KeyField",.T.)