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