5323.html

来自「以电子书的形式收集了VB一些常见问题解决方法,可以很方便的查找自己需要解决的问题」· HTML 代码 · 共 26 行

HTML
26 行
字号 
<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 <a href="mailto:jfmt@stn.sh.cn">Eric</a> on September 06, 1998 at 17:28:33:<p>
Private Sub Command1_Click()<br>Dim a As String<br>Dim b As String<br>Dim xa As Integer<br>Dim xb As Single<br>Dim xc As Single<br>Dim rs As Recordset<br>Dim r1 As Recordset<br>Dim r2 As Recordset<br>'按键锁定<br>Command1.Enabled = False<br>Command1.Visible = False<br>Command2.Enabled = False<br>Command2.Visible = False<br>Screen.MousePointer = 11<br>Label1.Caption = "开始资料库重整,工作中........"<p>'sql资料<br>Set rs = iBase.OpenRecordset("select 异动库.[出货单号] as xx, [未出数量] from 订单库 inner join 异动库 on [订单库].[订单号] = [异动库].[出货单号]", dbOpenDynaset)<p>rs.MoveLast: rs.MoveFirst<br>xa = Int(10000 / rs.RecordCount)<br>xc = 0<br>iWorkspace.BeginTrans<br>Do Until rs.EOF<br>   <br>    a = "select sum([出货数量]) as x1 from [异动库] where [出货单号] = '" & rs!xx & "'"<br>    b = "select sum([订货数量]) as x2 from [订单库] where [订单号] = '" & rs!xx & "'"<br>    <br>    Set r1 = iBase.OpenRecordset(a, dbOpenSnapshot)<br>    Set r2 = iBase.OpenRecordset(b, dbOpenSnapshot)<br>    rs.Edit<br>    rs!未出数量 = r2!X2 - r1!X1<br>    rs.Update<br>    rs.MoveNext<br>    xc = xc + xa<br>    ProgressBar1.Value = xc<br>Loop<br>iWorkspace.CommitTrans<p><p>'按键开起<br>Command1.Enabled = True<br>Command1.Visible = True<br>Command2.Enabled = True<br>Command2.Visible = True<br>Label1.Caption = "结算完成...请按结束键离开......."<br>Screen.MousePointer = 1<p>rs.edit总是报说不能修改<p>谢谢指点
<br>
<br><hr size=7 width=75%><p>
<a name="followups">Follow Ups:</a><br>
<ul><!--insert: 5323-->
<!--top: 5340--><li><a href="5340.html">Re: 错在那里</a> <b>小吴</b> <i>07:32:36 9/07/98</i>
(<!--responses: 5340-->0)
<ul><!--insert: 5340-->
</ul><!--end: 5340-->
</ul><!--end: 5323-->
<br><hr size=7 width=75%><p>

</body></html>

5323.html - 源码说明

本页面展示了「以电子书的形式收集了VB一些常见问题解决方法,可以很方便的查找自己需要解决的问题.对一些VB初学者很用.」中的 5323.html 源码文件，采用 HTML 编程语言编写，共 26 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。

虫虫下载站收录了大量与电子书相关的技术资源，包括源代码、技术文档、电路图等，是电子工程师和嵌入式开发者的专业学习平台。

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?