WorkScripts/PosComSvr.sql at master · shinexus/WorkScripts · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
-- 解决PosComSvr通讯报错_[不影响正常使用]

Delete from tPosDtsFileLstDefault
 where TableName in ('tProBillHead',
                     'tProPluAreaHead',
                     'tProPluAreaBody',
                     'tProCertiRateDetail',
                     'tProCertiRateHead',
                     'tProCertiType',
                     'tProGroupShop',
                     'tProTimProject')

 Delete from tJkPosDtsFileLstDefault
 where TableName in ('tProBillHead',
                     'tProPluAreaHead',
                     'tProPluAreaBody',
                     'tProCertiRateDetail',
                     'tProCertiRateHead',
                     'tProCertiType',
                     'tProGroupShop',
                     'tProTimProject')