 |
|||||
|
As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Join the TIBCO Community
Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community. | |||||
Read-Only TopicGo | Search | Notify | Tools |
| SPA problem | Login/Join |
| <RickW> |
It's been quite awhile since I've done MODIFYs but my guess would be to just recompute the selection field = ' ' after the update. | ||
|
| <Special-K> |
Have tried that but it's not working. My manager and I are in agreement it cant be done wihtout repopulating the SPA. Thanks anyway | ||
|
| Expert |
special-K, buy me a vowel...what is an SPA? In your 'screenful of data', where you allow the user to UPDATE or CANCEL, the UPDATE would call the modify routine, and then rerun the initial page, yes? so therefore, the CANCEL routine would have to do exactly the same thing except bypass the modify routine, and just rerun the inital page. Does that make sense? I have a similar usage...i have a pop up window that allows the user to enter some changes, but also requires the proper password. if the password isn't correct, the window closes and the original report re-runs, unchanged.
| |||||
|
| Expert |
SPA or Scratch Pad Area is a sort of cache that is used internally within MODIFY and is generally tied up with CRTFORM, GETHOLD, HOLDINDEX etc. As Rick says, it is a while since many of us have used MODIFY to this extent so if there is a solution within IB it is likely to come from some of the more experienced people such as Ben, Art, Noreen. So, imho, it would be best to raise a inforesponse case for this. T
| |||||||||
|
| Expert |
Special-K (Slimmer?), You do not state what release or platform you are using but the alternative is to migrate to MAINTAIN for your process. Have a look at this link for some hints. T
| |||||||||
|
| Virtuoso |
You should not have to relaod the spa unless your looking to get updated values. Can you post the case where you are trying to reset the 'S' to a blank? You should be able to loop throught the spa and use a gethold to retrieve the record. Then compute the indicator from 'S' to blank. Then HOLD the record back into the spa. "There is no limit to what you can achieve ... if you don’t care who gets the credit." Roger Abbott | |||
|
| Platinum Member |
I'm not a modify guru but I did not know modify could even update a flat file. I thought it would only be able to update databases (vsam, focus,db2,ims,etc). Is that what is being attempted here? FOCUS 7.6 MVS PDF,HTML,EXCEL | |||
|
| <Special-K> |
I've come to the conclusion it isnt possible to clear the selection field and am quite happy to close this problem. | ||
|
| Member |
If your still interested, it can be done. Call be at 248-318-0205 cell and I can help you out. (mark). It depends on how it's coded. WebFocus 7.7.03, Report Caster / Library, Windows 2008 R2 Databases: Oracle 11.x and DB2 8.x | |||
|
| Virtuoso |
If SEL/A1 is the selector column, and ROW/I5 is the selected row: -* copy all SPA columns to their vars COMPUTE HOLDINDEX = ROW; GETHOLD -* revise value, restore position, refresh the row COMPUTE SEL=' '; HOLDINDEX = ROW; HOLD SEL | |||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicCopyright © 1996-2020 Information Builders
| View $GS_USERNAME's Public Profile |
| Add $GS_USERNAME to my Ignore List |
| View Recent Posts by $GS_USERNAME |
| Notify me of New Posts by $GS_USERNAME |