Database tables

Started by Andrey


Database tables   03 February 2012, 19:22

Good day.
Can someone send me description of rows in sqllite-tables? I want use to generate my reports

Can PI work with MS SQL Server?
SoftPerfect Support forum - Andrew avatar image

Database tables   03 February 2012, 19:49

In this case you need the JOB table, which is mainly self-descriptive. If you have any specific questions about, please post them here.

The software currently only works with SQLite, no external database server can be used.

Database tables   03 February 2012, 21:42

Andrew, can u explain PAGE_TOTAL value formation? How it calculates?
SoftPerfect Support forum - Andrew avatar image

Database tables   04 February 2012, 01:14

The PAGE_TOTAL column contains the total number of pages that the document contains. This value may be zero if the print job does not contain page delimiting information.

It may not be the same number as the number of pages printed. For the number of printed pages use the formula PAGE_COUNT x PAGE_COPIES.

Hope this helps.

Reply to this topic

Sometimes you can find a solution faster if you try the forum search, have a look at the knowledge base, or check the software user manual to see if your question has already been answered.

Our forum rules are simple:

  • Be polite.
  • Do not spam.
  • Write in English. If possible, check your spelling and grammar.




A brief and informative title for your message, approximately 4–8 words:


Spam prevention: please enter the following code in the input field below.

 **        **         **    **  ********   *******  
 **        **    **    **  **   **        **     ** 
 **        **    **     ****    **        **        
 **        **    **      **     ******    ********  
 **        *********     **     **        **     ** 
 **              **      **     **        **     ** 
 ********        **      **     **         *******