Radicore Forum: How To » Show additional column in a LIST1 transaction pattern (a column not part of a parent table)

Home » RADICORE » How To » Show additional column in a LIST1 transaction pattern (a column not part of a parent table)

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

Show additional column in a LIST1 transaction pattern (a column not part of a parent table) [message #5437]

Thu, 17 March 2016 07:33

jjtoranzo2004
Messages: 261
Registered: September 2012

Senior Member

Tony I have the following problem. I want to show an additional column in a LIST1 transaction pattern that does not belong to the main table or any of its parent tables. The column is part of a "grandparent" table.

In order to retrieve the data from the database I followed these steps:

1 - Amend the component script to change the proper $sql_ variables. The $sql_select and the $sql_from variables.

2 - I edited the class file and changed the _cm_changeConfig function to add additional entries to the $fieldarray array.

3 - Change the screen file to include the fields and set their width.

The problem is that the title of the column is shown but not the corresponding data.

Can you point me in the right direction? I am sure I am forgetting something obvious.

Report message to a moderator

Re: Show additional column in a LIST1 transaction pattern (a column not part of a parent table) [message #5439 is a reply to message #5437]

Fri, 18 March 2016 05:45

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

Senior Member

You do not need to make any changes to the $fieldspec array in _cm_changeConfig unless you want the data validated before a WRITE operation, or formatted for display.

You need to chack that the new column is actually included in the data which is returned from the call to _dml_getData and added to the XML document. If you look at http://www.tonymarston.net/php-mysql/infrastructure-faq.html #faq51 you will see some debugging options that may be usefull.

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

Report message to a moderator

Previous Topic:	Open a new window from RADICORE
Next Topic:	List sibling records given a child record

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Tue Nov 26 21:15:05 EST 2024

Total time taken to generate the page: 0.00896 seconds