Select Object Blank

[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

[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.

[kev1n]

It means that there's somewhere an SQL Syntax error. Check the nuDebug Results as miasoft has suggested.

[vanman]

Thanks

Was an orphan subform that had not been finished.


P