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' to see all records Shows 46 records, with 1 record which has a Sent_Date value of 2/28/17 !!! If I run the query editor in the 'user environment', I get 45 records, and the above reference record with a date of 2/28/17 is (correctly) not found. I have even tried re-signing the date to the date field on the one 2/28/17 record - incase there was something "weird" no change I have deleted the index (both by hand, and by code) and added it back. Flushed the buffers to insure the change to the index and data are on disk. I have now run MSC verify (all OK) and the compacted the datafile (just to be sure) The anomalous result still persists... Any Ideas at all? Thanks! Chip --------------- Gas is for washing parts Alcohol is for drinkin' Nitromethane is for racing ********************************************************************** 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 **********************************************************************