I.T. Discussion Community!
-Collapse +Expand
Paradox
Search Paradox Group:

Advanced
-Collapse +Expand Paradox To/From
To/FromCODEGuides
-Collapse +Expand Paradox Store
PRESTWOODSTORE

Prestwood eMagazine

December Edition
Subscribe now! It's Free!
Enter your email:

   ► MB LobbyCorel Paradox / ObjectPAL Coding BoardQBE & SQL Topic   Print This     

Strange errors with :priv: report master table

Strange errors with :priv: report master table in QBE & SQL topic (part of our Corel Paradox / ObjectPAL Coding group).

Quick Search: Strange   Strange errors   Strange errors priv   report master  
Shores
Bologna, -- IT

Hi everybody!

I'm using either the ReportPrintInfo.masterTable property or the corresponding DynArray element to set the master table of a report just before printing it with report.print.

What happens is that if I generate a QBE query with all the conditions I need and pass it as masterTable to the report, all seems to work properly, but if I tell to the very same QBE to produce a temporary table in :PRIV:, and then pass that table to the report as a master table, the report shows many strange errors, refusing to run telling that it has no table, missing fields, any time something different that makes it crash, and sometimes also makes PDX crash.

Note that the table is being created correctly all the times: if I step debug my code and stop after executing the QBE, the table is there sitting in :PRIV: and has both the correct structure and the correct records inside, so why is it complaining that the table is missing or that fields are missing?

I vaguely rememeber something about Liz saying there was a max length of the PRIV path, but I can't find anything online about it...

Also, I hoped that all these path problems where a thing of the past since I started using an AutoIt startup script to SUBST drives to relevant folders, so that my aliase's paths turned to something very short such as:

c:\Users\User\Atipica\Alatron\Prv => y:\Alatron\Prv => :PRIV:

And similar things for all the other aliases.

I'm baffled, since nothing seems to resolve this apart from using directly the query, wich is perfect 90% of the times, but sometimes some calculations that cannot be performed on a live query should be applied to the created table, and in these cases I'd like to use the table...

What I'm missing here? Any hints?

Thanks!

Frelance IT consultant and programmer since 1991: www.atipica.it

 Posted 13 months ago (Thread Starter)
Comment Quote
About Shores -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #17310, 3 replies
Thread Started 11/4/2018 2:08:04 PM
View Counter=456
Last Reply Posted 11/6/2018 4:58:01 AM)
Location=Bologna, -- IT 
Joined=10 years ago   MB Posts=11   KB Comments=3  
Moderator
Steven.G
Myrtle Beach, SC USA

keep the path under 32, and keep the printer names under 32, too.. Win10 likes to re-install printers with names as long as your arm

Steven Green
Senior Software Engineer
Paradox Support Specialist DOS/WIN

Prestwood IT Solutions
8421 Auburn Blvd, Suite 256, Citrus Heights, CA 95610
Office: 916-726-5675 | Fax: 916-726-5676 | http://www.prestwood.com
 Posted 13 months ago
Comment Quote
About Steven.G -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #17311 (Level 2) and Parent is 17310
Reply Posted 11/5/2018 4:53:13 AM
Location=Myrtle Beach, SC USA 
Joined=39 months ago   MB Posts=326  
Shores
Bologna, -- IT

Ok, I'll check the printer name and the path length, what do you think about my idea of using substed drives to shorten the paths, do you think it helps or not?

Thanks!

Frelance IT consultant and programmer since 1991: www.atipica.it

 Posted 13 months ago (Thread Starter)
Comment Quote
About Shores -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #17313 (Level 3) and Parent is 17310
Reply Posted 11/5/2018 5:32:55 PM
Location=Bologna, -- IT 
Joined=10 years ago   MB Posts=11   KB Comments=3  
Most Recent Post
Moderator
Steven.G
Myrtle Beach, SC USA

if the path name is too long, doesn't matter which way you shorten it.. the printer name, you are best to actually be a shared printer, and shorten the network name

Steven Green
Senior Software Engineer
Paradox Support Specialist DOS/WIN

Prestwood IT Solutions
8421 Auburn Blvd, Suite 256, Citrus Heights, CA 95610
Office: 916-726-5675 | Fax: 916-726-5676 | http://www.prestwood.com
 Posted 13 months ago
Comment Quote
About Steven.G -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #17315 (Level 4) and Parent is 17310
Reply Posted 11/6/2018 4:56:26 AM
Location=Myrtle Beach, SC USA 
Joined=39 months ago   MB Posts=326  

Revive Thread!

Add a comment to revive this old thread and make this archived thread more useful.

Write a Comment...
Full Editor
...
Sign in...

If you are a member, Sign In. Or, you can Create a Free account now.


Anonymous Post (text-only, no HTML):

Enter your name and security key.

Your Name:
Security key = P1103A1
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #17310 Counter
456
Since 11/4/2018

Follow PrestwoodBoards on: 


©1995-2019 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech