[QODBC-Desktop] How to Print Invoices with Different Status using QODBC
Posted by Juliet (QODBC Support) on 30 August 2011 08:35 AM
How to Print Invoices with Different Status using QODBC
Note: There are two columns in table Invoice called "IsPending" and "IsPaid", you could just give them the specified value to get the different status of Invoices.
To print pending, unpaid and paid invoices to a file, you could try the queries as below.
Queries in QODBC
SELECT * FROM Invoice where IsPending=0
SELECT * FROM Invoice where IsPending=1
SELECT * FROM invoice where IsPaid=0
SELECT * FROM invoice where IsPaid=1