Radicore Forum: Framework » Key values change after popup call

Home » RADICORE development » Framework » Key values change after popup call

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Key values change after popup call [message #7330]

Sun, 11 August 2019 08:40

htManager
Messages: 375
Registered: May 2014

Senior Member

Hi Tony,
after a popup call in a upd1 pattern the key values are changed. I want to insert the key values from the popup form as a foreign key. In the _cm_popupReturn function the key values in the $fieldarray as well as the values in the $select_array are fine. In my debugger I see that when returning the values from _cm_getForeignData in std.table.class.inc the key values are changed. Is it because I have the same names as key fields?
I attached the two dict files in the attachment in one file.

Attachment: orga_mannschaften_kontakte-orga_vereine.dict.inc
(Size: 29.74KB, Downloaded 251 times)

Report message to a moderator

Re: Key values change after popup call [message #7331 is a reply to message #7330]

Mon, 12 August 2019 03:54

AJM
Messages: 2309
Registered: April 2006
Location: Surrey, UK

Senior Member

When you return from a popup the default behaviour is for the column values in $select_array to be inserted into $fieldarray. This will cause the values for existing fields in $fieldarray to be overwritten regardless of whether they are part of the primary key, a candidate key or just foreign keys. If the fields being returned have one name, but you want to change them to another then you should do so in the _cm_popupReturn() method.

The _cm_getForeignData() method is designed to perform lookups on foreign key fields in order to retrieve additional data.

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

Report message to a moderator

Re: Key values change after popup call [message #7332 is a reply to message #7331]

Tue, 13 August 2019 05:46

htManager
Messages: 375
Registered: May 2014

Senior Member

Now I understand and it works fine. The only thing I had to do was to change the values in $select_array into the original values (from $fieldarray) before returning $fieldarray at the end of the _cm_popupReturn() method. Thank you.

Report message to a moderator

Re: Key values change after popup call [message #7333 is a reply to message #7332]

Wed, 14 August 2019 04:52

AJM
Messages: 2309
Registered: April 2006
Location: Surrey, UK

Senior Member

It's easy when you know how Smile

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

Report message to a moderator

Previous Topic:	PDF - images in body / underlining 'label'
Next Topic:	https-server not defined - Access denied

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sat Aug 13 12:27:55 EDT 2022

Total time taken to generate the page: 0.01342 seconds