≪ View Page

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
autocount_pos:possqlquery [2025/04/02 06:59] – junautocount_pos:possqlquery [2025/04/02 06:59] (current) – jun
Line 1: Line 1:
 ===POS SQL Query=== ===POS SQL Query===
 select submiteinvoice,createdtime ,* from pos where createdtime >='20250101' and SubmitEInvoice='F' select submiteinvoice,createdtime ,* from pos where createdtime >='20250101' and SubmitEInvoice='F'
-//+\\
 update pos set SubmitEInvoice ='T' where createdtime >='20250101' and SubmitEInvoice='F' update pos set SubmitEInvoice ='T' where createdtime >='20250101' and SubmitEInvoice='F'