Keisuke,
No sure I understand your response.
I am working in R4 and was trying to query on an object field and
thought I could leave the field undefined using Query By Attribute. Not so, but
I am content with initializing all the records with an object so the the query
works with #.
I still do not get why the R4 documentation for Query by attribute
discusses how a # query will function if the "Map null to blank” checkbox is or
is not checked it the checkbox does not exist for an object field.
John
> On Oct 9, 2017, at 3:08 PM, Keisuke Miyako via 4D_Tech <[email protected]>
> wrote:
>
> the "map null to blank" property was originally introduced in v11,
> as a way to tell SQL that pre-existing NULLs
> (which could typically be created by adding fields)
> should not be considered NULLs in SQL.
> otherwise, as far as SQL is concerned,
> NULLs should never be mapped to blanks.
> (that is why the CREATE TABLE command does not allow this property to be
> enabled)
>
>> The documentation for Query by Attribute discusses at length how a # query
>> performs with or without the Map NULL values to blank values checked.
>
> this passage was added in v16
>
> http://doc.4d.com/4Dv16R4/4D/16-R4/QUERY-BY-ATTRIBUTE.301-3317528.en.html
>
> c.f.
>
> http://doc.4d.com/4Dv15/4D/15/QUERY-BY-ATTRIBUTE.301-2018639.en.html
>
> and the you immediate notice that "on" is considered the "4D way" and "off"
> the "SQL way".
>
> as for the question,
>
>> 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.
>
> maybe you need to check the version.
>
>
>
>
> **********************************************************************
> 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]
> **********************************************************************
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]
**********************************************************************
