June FOCUS® Friday
MODIFY for Reporting; Multiverbless Redux; Static Objects in MAINTAIN Applications
11:30 AM - 1:00 PM EDT
It’s already June and the year is almost half done. And we have lots more practical, useful and interesting FOCUS language information to come this year. As the summer begins to heat up this month, we will be looking at using MODIFY for reporting purposes and how you can do that. We also examine another method to combine summary and detail data in a single report- imitating the multiverb functionality. Finally we will explore how to use static objects in the Maintain in the App Studio world.
MODIFY for Reporting
In TABLE, TABELF, and MATCH, the FOCUS language processes sets of data. MODIFY, on the other hand, operates on a single record at a time with CASE logic available to provide unique processing options that you can conditionalize for each record. When you expect to provide different calculations, different field selection, different output for each record that you are reporting on, say account number, MODIFY offers a level of control that may be just what you require. Join us as we explore how MODIFY can be used as a highly useful reporting tool.
A multiverb request will allow you to combine summary and detail data in the same report. We have already shown using WITHIN to summarize within a sort group. This session will show another alternative using the PARTIION_ functions.
Static Objects in Maintain Applications
Objects such as list boxes and radio buttons can either be populated by a stack or have static values. In Dev Studio you could preset and retrieve the selections of these objects using the List Items command. This command is not available in App Studio. We will demonstrate how to use static objects including check boxes in App Studio applications.
It’s all going to happen on Friday, June 16, 2023 and we want you to join us.