HOLY #%^(&# !!
Nevermind!
The problem is/was :
QUERY([Result_Probes_Used];$Query_Field-> >= d_Search_Date)
Note carefully - I didn't - the query test is :
greater then or equal to
I was using as my test case
Equals
hence the difference
On Thu, 2 Mar 2017 00:29:35 +, Keisuke Miyako via 4
no - I had not tried that.
I just did this - "query by formula" dialog and use [table]Sent_Date =
Date("02/27/17")
I get the same results 45 records, correctly excluding the one record
with the sent date 02/28/17
On Thu, 2 Mar 2017 00:29:35 +, Keisuke Miyako via 4D_Tech wrote:
> but did you
but did you use the "query by formula" dialog
and use [table]Sent_Date = Date("02/27/17") as the criteria?
it might we worth creating a new DB with just one date field and see if the
results are reproducible.
then upgrade to a higher version and compare results.
2017/03/02 7:44、Chip Scheide via
Chip,
I'm generally a big fan of writing really lean code but in a case like this
I'd put the date value into a variable first.
If it still gives inconsistent results I'd do go to the user mode and call
up the IP user set, the one that gives you all 46 records. Do apply to
selection and set the da
I have a query being run
Query([table];$Query_Field-> = Date(s_Search_Start))
$Query Field is [table]Sent_Date (a date field)
s_Search_Start = "02/27/17"
If I run the query (in code) the result is 46 records.
In debugger
Creating an interprocess set, and using the set in the 'user
environment
5 matches
Mail list logo
