18879.html
来自「以电子书的形式收集了VB一些常见问题解决方法,可以很方便的查找自己需要解决的问题」· HTML 代码 · 共 22 行
HTML
22 行
<html> <head> <title>请教这个程式错在什么?</title> </head> <body bgcolor="#FFFFFF" vlink="#808080"> <center> <h1>请教这个程式错在什么?</h1> </center><hr size=7 width=75%><hr size=7 width=75%><p>Posted by kkcheung on September 13, 1999 at 16:23:49:<p>selstr = "select * from sale_rec where sale_date like '" + Trim(T_FROM.Text) + "%'" 'T_FROM.Text 输入的日期<p>Set tempset = FMSDB.OpenRecordset(selstr, dbOpenSnapshot, dbSQLPassThrough)<br>Do While Not tempset.EOF<br>temp_inv = Trim(tempset.Fields!invo_code): temp_lot = Trim(tempset.Fields!stockno)<p>selstr2 = "select * from receive_rec where stock_no='" + temp_lot + "'"<br>Set tempset2 = FMSDB.OpenRecordset(selstr2, dbOpenSnapshot, dbSQLPassThrough)<p>temp_sendcode = Trim(tempset2.Fields!send_code)<br>sqlSTR = "UPDATE sale_rec SET send_code= '" + temp_sendcode + "' WHERE invo_code='" + temp_inv + "' and stockno='" + temp_lot + "'"<br>BeginTrans<br>FMSDB.Execute sqlSTR, dbSQLPassThrough<p>tempset.MoveNext <==第12次,便odbc call fialed-3146.<br>tempset2.Close<br>CommitTrans<br>Loop<p>我尝试了好几个日子运行,但tempset.MoveNext每到第12次,便odbc call fialed-3146.为什么呢?<p><p><br><br><hr size=7 width=75%><p><a name="followups">Follow Ups:</a><br><ul><!--insert: 18879--></ul><!--end: 18879--><br><hr size=7 width=75%><p></body></html>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?