主题：[求助]表都在sql server上，那么对于副本需要加载吗？

比如有一个表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

不对吧。A用户对A-Z非插卡收货扫描表操作，然后保存了。

B用户不对A-Z非插卡收货扫描表--主表操作，肯定是没有主表数据，主表数据肯定在后台的sql上。那么这时用副表也可以？

看看动态加载这一章：

http://www.foxtable.com/help/topics/1508.htm

要即时加载最新数据，可以看看：

http://www.foxtable.com/help/topics/3006.htm

也就是说要想使用副表，就必须让主表先加载，这样才能用。

做不到直接操作后台表。

那我就直接先加载把。

你可以不用副本表，你可以用sqlTable

http://www.foxtable.com/help/topics/1907.htm

类型改为sqltable。只想取出SN列，下面的代码对吗。

select语句Select [_Identify], [SN] Fr om {扫描配货明细} where 收货漏扫 = false

If (Vars("AZfckshdh").Substring(5,1) = 1) Then
                                Tables("A-Z非插卡收货扫描_table3").filter = "收货单号 = '" & Vars("AZfckshdh") & "' and 外内 is null"
                                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 = "收货单号 = '" & 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

这样也好像不对。

sqltable好像是每次打开窗口时才生出临时的table，数据行应该是固定的吧。并不会随着扫描漏扫 = false 自动动态调整table把。