List records from one form and then enter them into another form
Hi,
I use the below procedure to list records in a specific order from one form and then enter those records into another form in the same order. When the records list on the screen they stop at each page, and then the user must hit page down key for the next page to list, etc. Once the list finishes the user must hit the esc key so the records are entered into the other form. Can this be done another way so it is completely automated and the user does not have to do anything?
Thanks,
Mike
for Race Numbers Final Numbers
;
list records
Race # in order ;
Adj New Bet Rtg FTS FUSA in reverse ;
PP ;
Adj Horse ;
Total E1E2 ;
Total LPSR ;
Power Rating ;
Adj Surface Sort .
enter a record in Fix FTS FUSA Numbers
New Bet Rtg := Race Numbers Final Numbers Adj New Bet Rtg FTS FUSA ;
Race # := Race Numbers Final Numbers Race # ;
PP := Race Numbers Final Numbers PP ;
Adj Horse := Race Numbers Final Numbers Adj Horse ;
Total E1E2 := Race Numbers Final Numbers Total E1E2 ;
Total LPSR := Race Numbers Final Numbers Total LPSR ;
Power Rating := Race Numbers Final Numbers Power Rating ;
Adj Surface Sort := Race Numbers Final Numbers Adj Surface Sort .
By: Michael M. Dorn posted: 17th February 2010 - 17:58
Replies
Michael Charlwood at 1st April 2010 - 19:29 says:
Haven't given much thought to this nor tried a similar test query out and do not know what version of DataEase you are using. However it sounds as if, on the print style screen, you have have got "pause after each page?" set to yes hence it is allowing each page to be read on the screen. With it set to No I would expect the "enter a record" to run straight after the screen printing ends.
If that doesn't fix it let me know.
Michael M. Dorn at 2nd April 2010 - 15:06 says:
Michael,
I am using DataEase V 7.2. I can not find a setting for pause after each page anywhere.
Thanks,
Mike
Michael Charlwood at 2nd April 2010 - 19:54 says:
Sorry I can't help with anything other than DataEase for DOS, Whilst I have a copies of DataEase 6 & 7.2 I have never tried to use them. In DataEase DOS after writing the DQL query the next step in the procedure is to specify where the output is to be sent. Options are screen/printer/disk and, if sent to the screen, do you want to pause between each page of output so giving an opportunity to read the output page by page. Useful when testing so not to finish up with loads of wasted printout. It is that pause option giving rise to the need to hit a key to continue to the next page.
Surely there must be a similar step in 7.2 procedures, after writing the procedure and defining the print layout, to specify screen output and at that point to define "pause after each page" which is what you have describe is happening. The option must be set within the DQL definition for that procedure.
Michael Charlwood at 2nd April 2010 - 21:00 says:
Have had a quick look at 7.2 DQL. Rather difficult as 7.2 does not have a sample database attached as did earlier versions! Anyway pushing a few random buttons I came across the Document Print Options screen which looks like the equivalent to 4.53DOS Print Style Screen. It is where one defines No Output/Printer/Window/File but doesn't seem to talk about pausing pages in a window. Don't know what "Print without displaying Dialogue" refers to. Also clicking Window option doesn't bring up an otherwise hidden "pause each page" either.
As your procedure does pause each page then either it is specified elsewhere or it pauses by default and you are probably stuck with it.
Michael M. Dorn at 3rd April 2010 - 15:17 says:
Michael,
Thanks for your input. The "Print withou displaying Dialogue" stops the "Document Print Options" screen from displaying. Hopefully somewhere down the line, DataEase will add the "pause after each page" option back in to the software.
Mike