Reader Feedback and Insights: Dynamic Result Field in Query/400

October 11, 2002 Timothy Prickett Morgan

Hey, Ted:

In the article “Dynamic Result Field in Query/400“, which appeared in Midrange Guru, OS/400 Edition, Bill wrote, “Every month we run a query that reports year-to-date sales. The year-to-date sales field, YTD$, is defined as result field that adds up monthly numeric buckets from a sales detail file. For example, the YTD$ for March will contain the expression Jan+Feb+Mar. However, before we can run this query each month, we have to add the next month to the expression. We would like to avoid having to modify the expression every month. Is there a way to

Odds and Ends

October 11, 2002 Timothy Prickett Morgan

Dear Readers:

Here are yet more answers to miscellaneous questions. Maybe someone has asked me a question to a problem or situation that you were wondering about.

— Ted

Question:

I am regular reader of your programming tips. I had a question, searched the Web for an answer, and couldn’t get the solution. May be I am not looking at the right place.

Lately, we have been converting programs from RPG/400 to RPG IV. When an RPG IV program abends at runtime, we look at dumps to investigate further. When we look at the dump, the “Statement in Error ………

Client Access Hotspots

October 11, 2002 Timothy Prickett Morgan

Hey, Ted:

I want to display a calendar if a user clicks on a date on the first line of a display. The date field is a ten-character output field in mm/dd/yyyy format.

If I click on the year or a forward slash (/), the program works correctly. However, if I double-click on the month or date portion, the program goes crazy. Double-clicking on a date of 03, for example, shuts down the program. Double-clicking on a month of 10 locks the keyboard.

Any ideas you have that will help solve my problem will be greatly appreciated.

— Bill

I