• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • 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

    …

    Read more
  • 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 ………

    …

    Read more
  • 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

    …

    Read more

Content archive

  • The Four Hundred
  • Four Hundred Stuff
  • Four Hundred Guru

Recent Posts

  • IBM i Has a Future ‘If Kept Up To Date,’ IDC Says
  • When You Need Us, We Are Ready To Do Grunt Work
  • Generative AI: Coming to an ERP Near You
  • Four Hundred Monitor, March 22
  • IBM i PTF Guide, Volume 25, Number 12
  • Unattended IBM i Operations Continue Upward Climb
  • VS Code Is The Full Stack IDE For IBM i
  • Domino Runs on IBM i 7.5, But HCL Still Working on Power10
  • Four Hundred Monitor, March 6
  • IBM i PTF Guide, Volume 25, Number 11

Subscribe

To get news from IT Jungle sent to your inbox every week, subscribe to our newsletter.

Pages

  • About Us
  • Contact
  • Contributors
  • Four Hundred Monitor
  • IBM i PTF Guide
  • Media Kit
  • Subscribe

Search

Copyright © 2023 IT Jungle