Subform not saving

Questions related to using nuBuilder Forte.

Subform not saving

Postby GlenMcCabe » Wed Jan 15, 2020 3:08 am

I have 2 virtually identical subform structures.

Onward referrals and interventions

Each has a lookup field which selects the onward referral or intervention and in each case a date and notes are added. The onward referral subform works perfectly but the intervention subform creates a row which saves the notes and dates but not the id of the intervention.

I get the following error
[0] :
===USER==========

globeadmin

===PDO MESSAGE===

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHERE `id` = '1514'' at line 1

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

UPDATE referral_interventions SET WHERE `id` = '1514';

===BACK TRACE====

C:\xampp\htdocs\nubuilder4\nudata.php - line 348 (nuRunQuery)

C:\xampp\htdocs\nubuilder4\nuapi.php - line 52 (nuUpdateDatabase)

ID is the row number which is tobe created or updated.

I have checked structures etc and cannot see differences between the subform structures. I have inserted values into the id field but these do not display in the subform even though they are in the table.

Thanks
GlenMcCabe
 
Posts: 30
Joined: Sun Sep 29, 2019 8:10 pm

Re: Subform not saving

Postby kev1n » Wed Jan 15, 2020 4:36 pm

Hi,

Check the spelling of the fields, upper and lower case, additional spaces.
kev1n
 
Posts: 471
Joined: Mon Oct 15, 2018 2:13 am

Re: Subform not saving

Postby GlenMcCabe » Thu Jan 16, 2020 12:26 am

Thanks Kevin

Tried that but all field names have been chosen using the up and down arrows to toggle through field names.

I did try re selecting all but no difference.

Will try deleting the subform and try again.

Glen
GlenMcCabe
 
Posts: 30
Joined: Sun Sep 29, 2019 8:10 pm

Re: Subform not saving

Postby GlenMcCabe » Thu Jan 16, 2020 6:23 am

Recreated form and subform. They look identical to originals but happy days it is now working.
GlenMcCabe
 
Posts: 30
Joined: Sun Sep 29, 2019 8:10 pm

Re: Subform not saving

Postby admin » Thu Jan 16, 2020 7:55 am

.
admin
Site Admin
 
Posts: 3215
Joined: Mon Jun 15, 2009 9:53 am


Return to General



cron