report question

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!

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

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

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

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?

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

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!

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!

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

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

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.