I have filed a case with 4D. I'm posting this message to make programmers aware of this issue. If you find that I'm mistaken, please let me know.
A Query within a transaction is returning incorrect results. To demonstrate create a new database with one table, add a date field to the table named "Date". Create and execute a method with the code below: $dDate:=Current date START TRANSACTION CREATE RECORD([Table_1]) [Table_1]Date:=$dDate SAVE RECORD([Table_1]) QUERY([Table_1];[Table_1]Date<$dDate;*) QUERY([Table_1]; & ;[Table_1]Date>Add to date($dDate;-1;0;0)) ALERT(String(Records in selection([Table_1]))+"\r\rSould be zero") CANCEL TRANSACTION The query should return zero records because the records date is = $dDate not < $dDate. However the query shows 1 record found. A bit of testing shows this problem exists in v15.3 as well as v16.0 (other versions of 4D not tested) The query also seems to work if there is no transaction. The query also seems to work if it is a single level query (just date<$dDate results in zero records) I tested only on windows 7 and windows server 2008 R2. Neil Privacy Disclaimer: This message contains confidential information and is intended only for the named addressee. If you are not the named addressee you should not disseminate, distribute or copy this email. Please delete this email from your system and notify the sender immediately by replying to this email. If you are not the intended recipient you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited. The Alternative Investments division of UMB Fund Services provides a full range of services to hedge funds, funds of funds and private equity funds. Any tax advice in this communication is not intended to be used, and cannot be used, by a client or any other person or entity for the purpose of (a) avoiding penalties that may be imposed on any taxpayer or (b) promoting, marketing, or recommending to another party any matter addressed herein. ********************************************************************** 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] **********************************************************************
