Foxtable(狐表)用户栏目专家坐堂 → [求助]表都在sql server上,那么对于副本需要加载吗?


  共有2047人关注过本帖平板打印复制链接

主题:[求助]表都在sql server上,那么对于副本需要加载吗?

帅哥哟,离线,有人找我吗?
huhu
  1楼 | 信息 | 搜索 | 邮箱 | 主页 | UC


加好友 发短信
等级:五尾狐 帖子:1165 积分:8129 威望:0 精华:0 注册:2015/3/30 10:44:00
[求助]表都在sql server上,那么对于副本需要加载吗?  发帖心情 Post By:2016/6/16 15:36:00 [只看该作者]

比如有一个表A-Z非插卡收货扫描,副本表A-Z非插卡收货扫描_table3。

在我本机操作这么写应该肯定是没问题的,如果分成多个客户端操作,别人需要对这个副本表操作有问题吗?

If (Vars("AZfckshdh").Substring(5,1) = 1) Then
                                Tables("A-Z非插卡收货扫描_table3").filter = "收货漏扫 = false and 收货单号 = '" & Vars("AZfckshdh") & "'"
                                Dim sum1 As Integer = DataTables("扫描配货明细").SQLCompute("count(SN)","状态 = '生成收货单' and 收货单号 = '" & Vars("AZfckshdh") & "' and 收货漏扫 = 'false'")
                                Dim shls As WinForm.Label = e.Form.Controls("Label1")
                                shls.text = "漏扫的SN有" & sum1 & "个"
                            ElseIf(Vars("AZfckshdh").Substring(5,1) = 2) Then
                                Tables("A-Z非插卡收货扫描_table3").filter = "收货漏扫 = false and 收货单号 = '" & Vars("AZfckshdh") & "' and 外内 = '外'"
                                Dim sum1 As Integer = DataTables("扫描配货明细").SQLCompute("count(SN)","状态 = '生成收货单' and 收货单号 = '" & Vars("AZfckshdh") & "'  and 外内 = '外' and 收货漏扫 = 'false'")
                                Dim shls As WinForm.Label = e.Form.Controls("Label1")
                                shls.text = "漏扫的SN有" & sum1 & "个"
                            End If


 回到顶部