≪ View Page

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
autocount_pos:possqlquery [2025/04/02 06:58] – 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'