nuBuilder Forum

Posted: **Mon May 14, 2018 7:50 pm**

I have created a form (and a table ) using fast forms with 3 text and 2 lookup values.
It works perfectly as long as the lookup values are set to a record of the tables they look into.
However I want to insert records in the table without the lookup values.
Saving the records works (The records are saved in the table, I can access them using phpMyAdmin)
However the records are not shown in the browse list so I cannot access them from the nuBuilder environment.

Any ideas how to solve this.

I am thinink of adding a dummy record in the 2 other tables and use it as default value, however I' d prefer to have actually empty values

Posted: **Mon May 14, 2018 8:20 pm**

I removed the lookup columns and the SQL querry from the browse form and I can access all the records now.

I would like to be able to view all the columns so any ideas are welcome.

Posted: **Mon May 14, 2018 8:32 pm**

Well found the solution I modified the autocreated SQL script using LEFT OUTER JOIN istead of JOIN on the two tables.
This returns all the lines from the main table and browse form has all records.

changed the following:

Code: Select all

SELECT
    part.*,
    device.*,
    field.*

FROM
    part
        JOIN device ON part.part_device_id = device.device_id
        JOIN field ON part.part_field_id = field.field_id

with this.

Code: Select all

SELECT
    part.*,
    device.*,
    field.*

FROM
    part
        LEFT OUTER JOIN device ON part.part_device_id = device.device_id
        LEFT OUTER JOIN field ON part.part_field_id = field.field_id

Posted: **Mon May 14, 2018 11:50 pm**

Posted: **Tue May 15, 2018 6:40 am**

gniko, does that mean it's all fixed?

Posted: **Tue May 15, 2018 7:50 am**

Yes its all fixed.
Thanks!

Posted: **Tue May 15, 2018 11:09 pm**

nuBuilder Forum

Empty lookup values

Empty lookup values

Re: Empty lookup values

Re: Empty lookup values

Re: Empty lookup values

Re: Empty lookup values

Re: Empty lookup values

Re: Empty lookup values