Dates in scope

Meeting place for R&R customers and clients to share tips and ideas. Post your questions, messages or problems here.
Post Reply
Peggy_Kuhn_(Guest)
Posts: 23
Joined: Tue Oct 10, 2017 12:44 pm

Dates in scope

Post by Peggy_Kuhn_(Guest) » Tue Oct 30, 2001 4:11 pm

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.__

Peggy_Kuhn_(Guest)
Posts: 23
Joined: Tue Oct 10, 2017 12:44 pm

=> RE: Dates in scope

Post by Peggy_Kuhn_(Guest) » Tue Oct 30, 2001 4:56 pm

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

Post Reply