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

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

   ► MB LobbyCorel Paradox / ObjectPAL Coding BoardParadox Runtime & Distribution Topic   Print This     

Paradox 9 Runtime - Report with QBE included

Paradox 9 Runtime - Report with QBE included in Paradox Runtime & Distribution topic (part of our Corel Paradox / ObjectPAL Coding group).

Quick Search: Paradox   Runtime   included   Paradox 9   Paradox 9 Runtime   Report QBE  
Most Recent Post
Don.C
-- UNK

I've inherited a Paradox 9 application that needs to be cleaned up and stabilized. The biggest single problem is that all users have access to the full version of Paradox so they go in an make copies of tables, litter the directory with queries, etc. Replacing Paradox 9 with the runtime version seems like a great solution but There is a print button in the application that allows the user to print a single record. Examining the button I find the following code:

method pushButton(var eventInfo Event)

var

q Query

rpt Report

num String

endvar

num = String(License_#.value)

q = Query

MASTER.DB | License # | Company name | 

          | Check ~num| Check        | 

EndQuery

if not executeQBE(q) then

errorShow("Could not execute Query")

Return

endif

; ONEREC = MASTER, ONLY USED WHEN PRINTING ONE RECORD

if not rpt.Print("ONEREC.RSL") then

errorShow("Could not print Report")

Return

endif

endmethod

It appears that pushing the button does a quick QBE to limit the report to printing the one record the user is viewing. It works fine in Paradox 9 but using the runtime nothing happens. I suspect that the runtime cannot execute the QBE code. Am I correct? If so, is there another way around this? 

Thanks

 Posted 9 years ago (Thread Starter)
Comment Quote
About Don.C -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.
Old Account!
If this is your account, sign in to activate web presence data (sign in quarterly to keep active). Alternatively, you can subscribe to our monthly eMag with a valid email address.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #14249, No Replies Be the first!
Thread Started 7/30/2010 12:44:53 PM
View Counter=2333
Location=-- UNK 
Joined=9 years ago   MB Posts=1  

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 = P1233A1
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #14249 Counter
2333
Since 7/30/2010
Follow PrestwoodBoards on: 


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