Radicore Forum: How To » Cant create relationships

Home » RADICORE » How To » Cant create relationships (There is no option to choose junior table in add relationship)

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

Cant create relationships [message #3736]

Mon, 13 May 2013 07:38

barnabooth
Messages: 12
Registered: February 2011

Junior Member

This is not a bug, as someone else would have noticed it, but since version 1.77 and 1.78 There are no option for me to choose Table ID (jnr) in ADD RELATIONSHIP menu. I am at loss, do you have a clue what might be wrong?

Best regards.

Attachment: addrelationship.png
(Size: 16.83KB, Downloaded 2066 times)

Report message to a moderator

Re: Cant create relationships [message #3737 is a reply to message #3736]

Mon, 13 May 2013 13:16

barnabooth
Messages: 12
Registered: February 2011

Junior Member

Quiet bump: if someone does not recognize this (that is have no problem adding relationships), please just give a hint, then I know something is wrong with my installation or system, it is just that everything else runs perfectly and predictably. Thank you in advance.

Report message to a moderator

Re: Cant create relationships [message #3738 is a reply to message #3736]

Thu, 16 May 2013 08:33

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

Senior Member

I can see two things missing in that screen:
1) A red asterisk in front of the 'Table Id (jnr)' label to signify that the field is required.
2) A popup button in the 'Table Id (jnr)' value area to signify that a value is chosen from a popup screen.

This works perfectly on all my installations. The only way that those two items can be missing on the screen is if the details in the dict_retaionship.dict.inc file are wrong. You should see the following values:

Code: [Select all] [Show/ hide]

    $fieldspec['table_id_jnr']              = array('type' => 'string',
                                                    'size' => 64,
                                                    'pkey' => 'y',
                                                    'required' => 'y',
                                                    'lowercase' => 'y',
                                                    'control' => 'popup',
                                                    'task_id' => 'dict_table(popup1)',
                                                    'foreign_field' => 'table_id_jnr',
                                                    'noedit' => 'y');

Can you check your copy of the file to see if it correct?

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

[Updated on: Thu, 16 May 2013 08:37]

Report message to a moderator

Re: Cant create relationships [message #3739 is a reply to message #3738]

Thu, 16 May 2013 08:57

barnabooth
Messages: 12
Registered: February 2011

Junior Member

Thank you very much for answering, however in .../radicore/dict/classes/dict_relationship.dict.inc I read as it should be:

$fieldspec['table_id_jnr'] = array('type' => 'string',
'size' => 64,
'pkey' => 'y',
'required' => 'y',
'lowercase' => 'y',
'control' => 'popup',
'task_id' => 'dict_table(popup1)',
'foreign_field' => 'table_id_jnr',
'noedit' => 'y');

I am beginning to suspect something is wrong or some missing software/addon with my computer (ubuntu 13.04 on macbookpro 5.5 or browser (same error on both the current verions of chromium and firefox) as I have not done any changes in the radicore files. But as said, I don't experience any other oddities when running radicore. Just for curiosity, there are no red asterisk in "update relationship" either, should it be? See screendump.

index.php?t=getfile&id=274&private=0

Attachment: Skärmbild från 2013-05-16 14:49:31.png
(Size: 46.21KB, Downloaded 2077 times)

[Updated on: Thu, 16 May 2013 11:16]

Report message to a moderator

Re: Cant create relationships [message #3742 is a reply to message #3739]

Fri, 17 May 2013 06:52

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

Senior Member

You won't see the red asterisk in the update screen as the field is non-editable.

The $fieldspec['table_id_jnr'] array contains the entry 'noedit' => 'y', which makes the field non-editable by default, but the 'Add Relationship' task should cause the following code to be executed in the dict_relationship_jnr class:

Code: [Select all] [Show/ hide]

    function _cm_changeConfig ($where, $fieldarray)
    {
        // make these fields editable
        unset($this->fieldspec['database_id_jnr']['noedit']);
        unset($this->fieldspec['table_id_jnr']['noedit']);

        return $fieldarray;

    } // _cm_changeConfig

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

Report message to a moderator

Re: Cant create relationships [message #3743 is a reply to message #3742]

Fri, 17 May 2013 14:59

barnabooth
Messages: 12
Registered: February 2011

Junior Member

Thank you for the information. The piece of code is -- as expected -- present in my installation as well. But I will try to figure out what might be wrong with my installation on the basis of this information (and try to get a better grip on the actual working of radicore as a side benefit ...).

I will return when I figure it out, or when I have something more qualified to ask about.

All the best, and again, thank you were much for answering.

Report message to a moderator

Re: Cant create relationships [message #3744 is a reply to message #3743]

Fri, 17 May 2013 15:58

barnabooth
Messages: 12
Registered: February 2011

Junior Member

And the end is, as always: ME STUPID.

From the dict and menu databases I could see that the last time I successfully added a relationship was 2012-12-09, I then decided to thoroughly read through the notes to each version starting with version 1.76 and, indeed, found this point

· updated the data dictionary to include screens to view relationship details from the child to its parents as well as from the parent to its children.You will need to run script 'dict.menu_export(2012-06-23).sql' in order to update the contents of your menu database.

I missed it, because I usually update 2-4 version in a row and the other sql updates in that version are at the top of the text. It was a little bit hidden --- yes, I vainly try to excuse myself -- but running it of couse made this single problem disappear.

This is of course not of any use for future reference, but I post it anyway as unsolved questions have an irritating air around them.

Thank your for your informative replies, and sorry for taking your time.

Report message to a moderator

Re: Cant create relationships [message #3745 is a reply to message #3744]

Sat, 18 May 2013 05:07

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

Senior Member

I'm glad that I was able to give you enough information to help solve your problem. Now that your Radicore installation is functioning properly I hope that you will be able to move forward and generate your own application with all the features that it provides.

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

Report message to a moderator

Previous Topic:	Blocking order column feature
Next Topic:	user can't insert data

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Fri Jul 04 19:28:46 EDT 2025

Total time taken to generate the page: 0.09934 seconds