The documentation for Query by Attribute discusses at length how a # query
performs with or without the Map NULL values to blank values checked.
I do not see this checkbox in the field Explorer window for an Object field.
Am I missing something here? It is there for other types of fields but not
Object fields.
I have added an object field to an existing table. When added the field is
undefined. At some point I will need to query the using Query By Attribute on
this field?
QUERY BY
ATTRIBUTE([Judges];[Judges]DivRestrictions_1JR_2SR_3Both;"division";#;0)
All the records in the table will be returned I am assuming because the field
is undefined for all the records. I am assuming that I am going to have to
prime the records with an object containing “division" = 0. I thought perhaps
the NULL mapping setting might help me out here, but I do not see anyway to
change the mapping option for testing.
John
John Baughman
Kailua, Hawaii
(808) 262-0328
[email protected]
**********************************************************************
4D Internet Users Group (4D iNUG)
FAQ: http://lists.4d.com/faqnug.html
Archive: http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub: mailto:[email protected]
**********************************************************************
