IT SOLUTIONS
Your full service technology partner! 
-Collapse +Expand
Paradox
Search Paradox Group:

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

Prestwood eMagazine

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

   ► MB LobbyCorel Paradox / ObjectPAL Coding BoardParadox Reports Topic   Print This     

report question

report question in Paradox Reports topic (part of our Corel Paradox / ObjectPAL Coding group).

Quick Search: question   report question  
luckydogli
city of port st lucie
Port St. Lucie, FL USA

Dear all, 

I just got a paradox report on our legacy system - paradox 7 for windows. I need to find out what is the underlying data for the report. I opened the report in design mode and look at the data model. It has three tables, two of them linked. Two of them are priv table. I can find the two priv tables - one empty and the other one has data. how can I find which query makes the process? thanks for your help!

 Posted 23 months ago (Thread Starter)
Comment Quote
About luckydogli -Collapse +Expand
Visit Profile
Membership pending.
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 #17160, 10 replies
Thread Started 6/22/2018 7:06:28 AM
View Counter=795
Last Reply Posted 6/29/2018 9:07:15 AM)
Location=Port St. Lucie, FL USA 
Joined=23 months ago   MB Posts=6  
Moderator
Steven.G
Myrtle Beach, SC USA

you have to know what the code is, that calls the report.. most likely, a button on a form, but I know that doesn't help much

there are ways to pull code into tables, then query the tables for the specific text strings you want (in this case, the report name).. but don't know if you app is all in one place, if you have access to the code, if you know how to put together your own processes, etc

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 23 months ago
Comment Quote
About Steven.G -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #17161 (Level 2) and Parent is 17160
Reply Posted 6/22/2018 7:16:26 AM
Location=Myrtle Beach, SC USA 
Joined=44 months ago   MB Posts=375  
luckydogli
city of port st lucie
Port St. Lucie, FL USA
Quote:
Originally Posted by Steven.G

you have to know what the code is, that calls the report.. most likely, a button on a form, but I know that doesn't help much

there are ways to pull code into tables, then query the tables for the specific text strings you want (in this case, the report name).. but don't know if you app is all in one place, if you have access to the code, if you know how to put together your own processes, etc

Thanks Steven. I looked at the button on the form. it is like this - i cannot insert picture somehow on this website. 

Method pb()

var

repInfo2       ReportPrintInfo

endVar

if libSys.OpenDateDialog("StartEnd")

   then dt=libSys.getStart()

          dt1=libSys.getEnd()

          setMouseShape(mouseWait)

          if libLTC.calcMORDEP(dt,dt1) and libSys.AddRepHist(":LTC:", "MORDEP", dt,dt1,libSys.getStatus())

              then BLANKASZERO(FALSE)

              message("Printing Reports")

              repInfo.Orient=printlandscpae;

              repInfo2.orient=printlandscape

              repInfo.name=stModDir+"LTCMOR1";

              repInfo2.name=stModDir+"LTCMOR2"

              libSys.PrintReport(repInfo);

              libSys.PrintReport(repInfo2)

     else msgStop("Warning!","Unable to Process or Print LTC MOR Data")

endIf

setMouseShape(MouseArrow)

blankAsZero(True)

else msgInfo("Notice!", "You have cancelled")

endif

endmethod

 Posted 23 months ago (Thread Starter)
Comment Quote
About luckydogli -Collapse +Expand
Visit Profile
Membership pending.
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 #17162 (Level 1.1)  Reply to 17161 and Parent is 17160
Thread Started 6/22/2018 7:28:31 AM
Location=Port St. Lucie, FL USA 
Joined=23 months ago   MB Posts=6  
Moderator
Steven.G
Myrtle Beach, SC USA

it seems that this is the process that makes the data

if libLTC.calcMORDEP(dt,dt1) and libSys.AddRepHist(":LTC:", "MORDEP", dt,dt1,libSys.getStatus())

you have two library files, with more code in them.. my guess, the first process gets the data, the second process massages it into the report table

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 23 months ago
Comment Quote
About Steven.G -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #17163 (Level 3) and Parent is 17160
Reply Posted 6/22/2018 8:01:38 AM
Location=Myrtle Beach, SC USA 
Joined=44 months ago   MB Posts=375  
luckydogli
city of port st lucie
Port St. Lucie, FL USA
Quote:
Originally Posted by Steven.G

it seems that this is the process that makes the data

if libLTC.calcMORDEP(dt,dt1) and libSys.AddRepHist(":LTC:", "MORDEP", dt,dt1,libSys.getStatus())

you have two library files, with more code in them.. my guess, the first process gets the data, the second process massages it into the report table

Thanks Steven. for the two libary files, are you referring to libLTC.calcMORDEP and libSys.AddRepHist? if the first one libLTC.calcMORDEP(dt,dt1) get the data, how can I look at the process? where to find it? how to open it?

 Posted 23 months ago (Thread Starter)
Comment Quote
About luckydogli -Collapse +Expand
Visit Profile
Membership pending.
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 #17164 (Level 1.1)  Reply to 17163 and Parent is 17160
Thread Started 6/22/2018 10:27:15 AM
Location=Port St. Lucie, FL USA 
Joined=23 months ago   MB Posts=6  
Moderator
Steven.G
Myrtle Beach, SC USA

you open a library just like you open a form or script.. be careful.. sounds like you didn't write this app, and you're learning how it all works

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 23 months ago
Comment Quote
About Steven.G -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #17165 (Level 4) and Parent is 17160
Reply Posted 6/22/2018 2:25:23 PM
Location=Myrtle Beach, SC USA 
Joined=44 months ago   MB Posts=375  
luckydogli
city of port st lucie
Port St. Lucie, FL USA
Quote:
Originally Posted by Steven.G

you open a library just like you open a form or script.. be careful.. sounds like you didn't write this app, and you're learning how it all works


Thanks Steven!

 Posted 23 months ago (Thread Starter)
Comment Quote
About luckydogli -Collapse +Expand
Visit Profile
Membership pending.
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 #17177 (Level 1.1)  Reply to 17165 and Parent is 17160
Thread Started 6/27/2018 10:49:15 AM
Location=Port St. Lucie, FL USA 
Joined=23 months ago   MB Posts=6  
luckydogli
city of port st lucie
Port St. Lucie, FL USA
Quote:
Originally Posted by Steven.G

you open a library just like you open a form or script.. be careful.. sounds like you didn't write this app, and you're learning how it all works


Hi Steven, 

as I am digging into the code, I came up with this code, i think i understand some of them but not all. I have some questions and hope you can help. 

1. in the first column of :ltc:ltcmeter.db, what is the underscore _dt? i think here it is like a where clause condition. what is the third row- check _dt+1?

2. in the first column of :priv:ltcmor1.db, the second column has changeto in its 2nd row, is that a indication for calculation? thanks!

q1=query
                                                         
:ltc:ltcmeter.db |Date   |Unit1Flow |Unit2Flow |Unit3Flow |Eff30  |Eff12  |Eff16  |ROProduct |PlantTimer |PolymerDose |Rainfall |HSIron  |FlourideVol |TotalFinishWater |RoRawBlend |
   |_dt, >=~st-1, <~st1 |_u1a  |_u2a  |_u3a  |_eff30a |_eff12a |_eff16a |  |_pta  |  |    |  |  |   |  |
   |check _dt+1  |_u1b  |_u2b  |_u3b  |_eff30b |_eff12b |_eff16b  |_ROPb  |_ptb  |_pd  |_rain  |_hsiron |_fl  |_tfw   |_rop   |
                                                      
:priv:ltcmor1.db |Date |Unit1Flow   |Unit2Flow   |Unit3Flow   |ROProduct |TotalProduct           |PlantHours  |Polymer   |Rainfall  |FinIron  |Flouride   |FinalFlow12   |FinalFlow16   |FinalFlow30   |TotalFinishWater |AmnUsed  |RoRawBlend  |RawFlow |
   |_dt+1 |changeto (_u1b-_u1a)/1000 |changeto (_u2b-_u2a)/1000 |changeto (_u3b-_u3a)/1000 |changeto _ROPb |changeto (((((_u1b-_u1a)/1000)+((_u2b-_u2a)/1000)+((_u3b-_u3a)/1000)))+_ROPb)   |changeto _ptb  |changeto _pd* (50.94/448) |changeto _rain  |changeto _hsiron |changeto (_fl*.792*.23*10.03) |changeto (_eff12b-_eff12a) |changeto (_eff16b-_eff16a) |changeto (_eff30b-_eff30a) |changeto (_rop+_ROPb) |changeto (_rop*11) |changeto _rop  |changeto _ROPb | 
endQuery
 Posted 23 months ago (Thread Starter)
Comment Quote
About luckydogli -Collapse +Expand
Visit Profile
Membership pending.
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 #17187 (Level 1.2)  Reply to 17165 and Parent is 17160
Reply Posted 6/29/2018 7:50:28 AM
Location=Port St. Lucie, FL USA 
Joined=23 months ago   MB Posts=6  
Moderator
Steven.G
Myrtle Beach, SC USA

the underscore is an example element, yes, kinda like a where clause.. the check mark is like a select clause

yes, sometimes a changeto is a direct calc, but not always.. depends on context

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 23 months ago
Comment Quote
About Steven.G -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #17188 (Level 5) and Parent is 17160
Reply Posted 6/29/2018 8:03:57 AM
Location=Myrtle Beach, SC USA 
Joined=44 months ago   MB Posts=375  
rum
Frankfort, KY USA

1.  _dt sets up a variable inside the query,  the variable is being used in two ways

    a.  in the third row,    "|check _dt+1  |", This selecting the DATE+1 day and displaing it in the output

    b.  using _dt+1 ,  the second table is being linked to the first, and updating records for the following day (hence _dt+1)

2.  everywhere you see a changeto,  there is an update happening.   in order to do an update calculation you need a variables,  you can see that _ub1 & _u1a are defined in the 2nd and 3rd lines of the query,  under the column Unit1Flow.

If I had to guess,   this query is meant to calculate the change in waterflow values from one day to the next

 Posted 23 months ago
Comment Quote
About rum -Collapse +Expand
Visit Profile
Membership pending.
Member subscribes to this thread with a verified email.
Member pending approval.
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 #17189 (Level 6) and Parent is 17160
Reply Posted 6/29/2018 8:06:26 AM
Location=Frankfort, KY USA 
Joined=35 months ago   MB Posts=118  
Most Recent Post
luckydogli
city of port st lucie
Port St. Lucie, FL USA

Thanks Steven and rum, and this starts to make some sense now. I need to figure out this logic and re-write them in sql. 

 Posted 23 months ago (Thread Starter)
Comment Quote
About luckydogli -Collapse +Expand
Visit Profile
Membership pending.
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 #17190 (Level 7) and Parent is 17160
Reply Posted 6/29/2018 9:05:52 AM
Location=Port St. Lucie, FL USA 
Joined=23 months ago   MB Posts=6  

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 = P1307A1
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #17160 Counter
795
Since 6/22/2018
Go ahead!   Use Us! Call: 916-726-5675  Or visit our new sales site: 
www.prestwood.com


©1995-2020 Prestwood IT Solutions.   [Security & Privacy]