Database tables

Started by Andrey

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
Thanx

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.
Andrey

Database tables   03 February 2012, 21:42

Thanx
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.

Sometimes you can get the answer faster if you try the forum search and/or have a look at the software user manual to see if your question has already been answered.

Our forum rules are simple:

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

Author:

Subject

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

     

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

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

Message: