Richard, I have found in a few instances that querying is limited to 40 characters.
David -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Richard Carpenter Sent: Friday, August 28, 2009 4:11 PM To: [email protected] Subject: [Active4d-dev] Help with query problem on web site I have a rather strange problem to track down and would like some suggestions on areas to look. This is with Active4d 4.5r1 on a windows 2003 server and 4D 2004.8. We have some scenarios where a query such as the following : Query([Task];[Task]Task_ID = $TaskID) Return the wrong record. Usually this record is another record a user has recently created or edited in a web process. Immediately calling the same query line again will find the correct record. We haved checked the datafile with 4D Tools and Datacheck and neither reported any errors. I know that active 4d checks all built queries to ensure they are terminated properly but is it possible for a called 4D method to leave a query open and cause this behaviour? The datafile currently sits around 8 gigabytes with the largest table holding about 1.7 million records. Thanks for any suggestions in advance! _______________________________________________ Active4D-dev mailing list [email protected] http://mailman.aparajitaworld.com/mailman/listinfo/active4d-dev Archives: http://mailman.aparajitaworld.com/archive/active4d-dev/ _______________________________________________ Active4D-dev mailing list [email protected] http://mailman.aparajitaworld.com/mailman/listinfo/active4d-dev Archives: http://mailman.aparajitaworld.com/archive/active4d-dev/
