关于selectblob的问题

[jjllwanjilong]

我的数据库环境为sybase 11.92 + win2000 + pb6.5
在数据库连接后运行以下代码
INT I
STRING A
BLOB BL1
FOR I = 1 TO DW_1.ROWCOUNT()
A = DW_1.GETITEMSTRING(I,1)
sqlca.autocommit = true
SELECTblob filedata INTO :BL1 FROM sbf_program where filename = :A using sqlca;
sqlca.autocommit = false
if isnull(bl1) then
messagebox('','error' + sqlca.SQLErrText )
else
messagebox(string(LEN(bl1)),A)
end if
setnull(BL1)
NEXT


有时正常,有时出错,提示如下:
ct_close():network packet layer:internal netlibrary error:net-library operation terminated due to disconnect
请问那位能够解答

[juwuyi]

INT I
STRING A
BLOB BL1
FOR I = 1 TO DW_1.ROWCOUNT()
A = DW_1.GETITEMSTRING(I,1)
//sqlca.autocommit = true
SELECTblob filedata INTO :BL1 FROM sbf_program where filename = :A using sqlca;
//sqlca.autocommit = false
if SQLCA.SQLCode <> 0 then
MessageBox("SQL error",SQLCA.SQLErrText,Information!)
end if
setnull(BL1)
NEXT

[jjllwanjilong]

不是这个原因,原来没有这两条语句的,后来因为读不出来才加上去的,我感觉与上述autocommit无关,这部分程序在aix+sybase + win2000上正常.