Dates in scope
-
- Posts: 23
- Joined: Tue Oct 10, 2017 12:44 pm
Dates in scope
Currently using R&R 8.1 and maintaining code that does the report with the following syntax from VFP6._____DO REPORT with mlibrary,mreport,"?","O",mloscope,mhiscope,"O",mquery1,msec,"","",pcIndex____Problem is that if mloscope is an empty date, it errors.__I have set it to ignore scope but really want it to be able to include blank dates to some ending date (so don^t ignore mhiscope). Is there__a way to do this ? I^ve tried ^{}^, { / / },dtoc(" / / "), etc.____Also, any way to determine programmatically that R&R is querying so my program code stops and doesn^t continue ?____Thanks for any help.__
-
- Posts: 23
- Joined: Tue Oct 10, 2017 12:44 pm
=> RE: Dates in scope
Found my own answer on your website to question 1.____If I save DTOC(mvar,1) to mloscope or mhiscope....the 1 ensures it will save in a 4 year format (ie MMDDYYYY).____Question 2 still outstanding....any way to stop my code while R&R is doing it^s query. Wait window is kludgy, (ie Please wait till R&R finished).____Thanks again