Thanks Keisuke.
I figured it out. The 4th line below was missing "$field->=“.
In the Tech tip it was "Is field value Null($field->))”
The corrected line 4 below compile correctly now.
QUERY BY FORMULA($table->;$field->="" |\
$field->="20202020202020202020202020202020" |\
$field->="00000000000000000000000000000000" |\
$field->=Is field value Null($field->))
Very best regards,
Paul Ringsmuth
> On Dec 28, 2016, at 6:50 PM, Keisuke Miyako <keisuke.miy...@4d.com> wrote:
>
> I am not sure if the QBF one-liner takes advantage of indexes.
> (Get last query path says no)
>
> maybe you were right to use sets after all.
>
> perhaps
>
> //set A
> ARRAY TEXT($nulls;3)
> $nulls{1}:="20202020202020202020202020202020"
> $nulls{2}:="00000000000000000000000000000000"
> $nulls{3}:=""
> QUERY WITH ARRAY($field->;$nulls)
>
> //set B
> QUERY BY FORMULA($table->;Is field value Null($field->)
>
> to use less sets.
>
>> 2016/12/29 9:27、Paul Ringsmuth <pringsm...@charter.net> のメール：
>> As a work around I am using the following query by formula instead of the
>> original above:
>
>
> 宮古 啓介
> セールス・エンジニア
>
> 株式会社フォーディー・ジャパン
> 〒150-0043
> 東京都渋谷区道玄坂1-10-2 渋谷THビル6F
> Tel: 03-6427-8441
> Fax: 03-6427-8449
>
> keisuke.miy...@4d.com
> www.4D.com/JP
>
> **********************************************************************
> 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:4d_tech-unsubscr...@lists.4d.com
> **********************************************************************
**********************************************************************
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:4d_tech-unsubscr...@lists.4d.com
**********************************************************************
