Welcome to the nuBuilder Forums!

Join our community by registering and logging in.
As a member, you'll get access to exclusive forums, resources, and content available only to registered users.

Select Object Blank

Questions related to using nuBuilder Forte.
Post Reply
vanman
Posts: 54
Joined: Thu Mar 01, 2018 11:09 pm
Has thanked: 1 time

Select Object Blank

Unread post by vanman »

table_structure.png
HI

I have a number of select object using an attribute table
SELECT attribute_id, att_value
FROM attribute
WHERE att_type = 'Staff_Member'

The Select come back blank.

When I run the above in MYSQL returns
attribute_id;"att_value"
6002d17eb160d46;"Lauren"
6002d18ed4f3f3f;"Joanna"
6002d1a10e113c0;"Debbie"
6002d1b10e0c7f0;"Glenda"
6002d1bdab39015;"Paul"
6002d1c68d783d7;"Annie"
6002d1cc0ead332;"Tara"
6002d1d2d4cec0c;"Stuart"

The form has 9 Tabs and 103 objects

Release 4.5 on Windows

Any ideas where to look

Thanks
You do not have the required permissions to view the files attached to this post.
Top
miasoft
Posts: 156
Joined: Wed Dec 23, 2020 12:28 pm
Location: Russia, Volgograd
Has thanked: 32 times
Been thanked: 7 times
Contact:
Contact miasoft

Re: Select Object Blank

Unread post by miasoft »

Release 4.5 on Windows
Any ideas where to look
Test result your request in NU:
09.02_2.png
and you see errors.
You do not have the required permissions to view the files attached to this post.
Wbr, miasoft.
Top
kev1n
nuBuilder Team
Posts: 4562
Joined: Sun Oct 14, 2018 6:43 pm
Has thanked: 76 times
Been thanked: 528 times
Contact:
Contact kev1n

Re: Select Object Blank

Unread post by kev1n »

It means that there's somewhere an SQL Syntax error. Check the nuDebug Results as miasoft has suggested.
Top
vanman
Posts: 54
Joined: Thu Mar 01, 2018 11:09 pm
Has thanked: 1 time

Re: Select Object Blank

Unread post by vanman »

Thanks

Was an orphan subform that had not been finished.


P
Top
Post Reply

Return to “General”