nuBuilder Forum

Hi im new user of nubuilder. I dont know if i can post it in here.

I already follow the tutorial especially for the Form and Subform (Invoice Item) of PIZERIA tutorial before i used the updated version there are no problem to display the GRID of SUBFORM. Now i can not display it on my FORM (Invoice).

This is my screen shot : This is before i use the update version : So what do i have to do to solve this ?
Thanks

Hi,

Please verify that the form and Foreign Key are (still) entered:

Click on the Options Menu, then select "Subform Object"

And then select the tab "Subform"

kev1n wrote: ↑Thu Nov 17, 2022 9:21 am Hi,

Please verify that the form and Foreign Key are (still) entered:

Click on the Options Menu, then select "Subform Object"
options_menu.png



And then select the tab "Subform"
subform.png

Hi thanks for the reply , i already cofigure the subform but the issue is stil the same. I did the exact step on each version , the version before updated => it works perfectly but when i use the new updated version => it can't works

Please help. Thanks

Do you see any errors in nuDebug Results?

kev1n wrote: ↑Thu Nov 17, 2022 9:58 am Do you see any errors in nuDebug Results?

The RESULTS is something like this :

[0] : ===USER==========

globeadmin

===PDO MESSAGE===

SQLSTATE[42S22]: Column not found: 1054 Unknown column '' in 'field list'

===SQL===========

SELECT `` FROM zzzzsys_setup WHERE (`item_inv_id` = '-1') AND (0)

===BACK TRACE====

/home3/rhadisubrata/abc.com/core/nuform.php - line 1001 (nuRunQuery)

/home3/rhadisubrata/abc.com/core/nuform.php - line 400 (nuGetSubformRecords)

/home3/rhadisubrata/abc.com/core/nuapi.php - line 91 (nuGetFormObject)

What does the subform's SQL look like?

kev1n wrote: ↑Thu Nov 17, 2022 10:55 am What does the subform's SQL look like?

TQ so much for the reply.

The sql either for form and subform is something like this
This Is For The Subform And this if for the Form (Main)

Thanks, this is showing the db schema and not the form's SQL. This can be found when you click the subform's options menu (see above), select "Form Properties" and then the SQL can be found in the "Browse" tab.

Hi,

Is this solved?