[[https://www.revelation.com/|Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community]]
==== Symbolics in an edit table (OpenInsight Specific) ====
=== At 16 JUL 1998 11:44:25AM Jeff Blinn wrote: ===
{{tag>"OpenInsight Specific"}}
I know this subject has been touched upon before, but I couldn't find what I'm looking for . . .
We have a contact edit table, which contains an ID, name (symbolic), and title (symbolic).
If we pull up an existing record and change one of the ID's or add a new one:
- the ARRAY and LIST properties for the control are set correctly
- the RECORD property for @window is NOT set correctly, it doesn't contain the new data
- when save is executed, the data is NOT saved to the record (which makes sense since I believe the save routine uses the RECORD property of @window)
If we remove the 2 symbolics from the edit table - all is fine, except the users would only see the ID :-(
One workaround that comes to mind is to display the symbolics in other controls - but that seems like a long way to go. Has anyone run into this? Is there a better work around for it?
The symbolics are just executing an exlate from another table.
Thanks,
Jeff
----
=== At 16 JUL 1998 12:23PM Don Bakke wrote: ===
Jeff,
How is the data in the edittable (that controls the symbolics) getting updated? If it's manual then this should work, if it's being done programmatically (PopUp, etc.) then make sure you update the INVALUE or DEFPROP property. Sending a CALCULATE event to the columns holding the symbolics is sometimes necessary as well.
All that aside, if the ARRAY and LIST properties are correct then when the record is written there should be a reconciliation and the information should be written. My only guess is that OI thinks that the information hasn't been changed and therefore won't resolve the data. What happens if you just try to close the form without saving? Do you get the save warning message? I believe that the SAVEWARN property is triggered when a control indicates that there has been a change in its value, but this can be suppressed if the control has been updated programmatically.
I don't know why removing the symbolic makes this go away. Seems fishy to me. Hope some of this helps.
dbakke@srpcs.com
[url=http://www.srpcs.com]SRP Computer Solutions[/url]
[img]http://www.srpcs.com/srpicon1.gif[/img]
----
=== At 16 JUL 1998 01:36PM Jeff Blinn wrote: ===
Don,
I created a new window with just an ID field, and an edit table with two fields contact id, and the contact name.
When I update the contact id (manually - no popups defined) - the display and the record save are correct. This would indicate there's something going on in our other screen that's stopping processing somehow - we'll have to work that out.
However, the RECORD property for @WINDOW still does not reflect the new data. Isn't it supposed to? I was under the impression that this property stored the 'live' data as it was being entered on the screen. For other controls (even single field edit tables) it does contain updated data.
We were trying to do some validation before saving - short of going through every control on the window.
Thanks,
Jeff
----
=== At 16 JUL 1998 02:38PM Jeff Blinn wrote: ===
I've narrowed this behavior down to more specific circumstances. The edit table we were using contained the ID for the contacts table, and was calling the name and title fields from the contacts table, using the 'Selection Criteria' dialog to set up the relationship. The relationship worked - but as noted the update of the RECORD property (and @RECORD) didn't.
We then tried creating symbolics in the same table that the window is linked to (the primary table) - and used those in the edit table. When we do it this way, everything works fine. I guess we'll just have to create a few more symbolics . . .
Jeff
----
=== At 17 JUL 1998 12:47AM Don Bakke wrote: ===
Ah...joined tables do create problems. Unless you needed to update the secondary table it is best just use normal symbolics. Glad you figured it out.
dbakke@srpcs.com
[url=http://www.srpcs.com]SRP Computer Solutions[/url]
[img]http://www.srpcs.com/srpicon1.gif[/img]
[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=NONWORKS_READ&SUMMARY=1&KEY=6355FA33C2A352A785256643005676E9|View this thread on the forum...]]