|
Help with query problem on web site
|
View:
New views
5 Messages
—
Rating Filter:
Alert me
|
 |
Help with query problem on web site
by Richard Carpenter-2
::
Rate this Message:
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 Active4D-dev@... http://mailman.aparajitaworld.com/mailman/listinfo/active4d-dev Archives: http://mailman.aparajitaworld.com/archive/active4d-dev/ |
|
|
Re: Help with query problem on web site
by Michael Larue-2
::
Rate this Message:
Friday, August 28, 2009
Hi Richard, > is it possible for a called 4D method to leave a > query open and cause this behaviour? Do you have a SET QUERY DESTINATION command anywhere? If so, you'll want to trace it carefully to make sure it's "closed" properly (ie, if you change the destination into something like a set, you need to change it back into the current selection). Hope this helps, Michael Larue _______________________________________________ Active4D-dev mailing list Active4D-dev@... http://mailman.aparajitaworld.com/mailman/listinfo/active4d-dev Archives: http://mailman.aparajitaworld.com/archive/active4d-dev/ |
|
|
|
|
|
Re: Help with query problem on web site
by David Ringsmuth
::
Rate this Message:
Richard,
I have found in a few instances that querying is limited to 40 characters. David -----Original Message----- From: active4d-dev-bounces@... [mailto:active4d-dev-bounces@...] On Behalf Of Richard Carpenter Sent: Friday, August 28, 2009 4:11 PM To: active4d-dev@... 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 Active4D-dev@... http://mailman.aparajitaworld.com/mailman/listinfo/active4d-dev Archives: http://mailman.aparajitaworld.com/archive/active4d-dev/ _______________________________________________ Active4D-dev mailing list Active4D-dev@... http://mailman.aparajitaworld.com/mailman/listinfo/active4d-dev Archives: http://mailman.aparajitaworld.com/archive/active4d-dev/ |
|
|
Re: Help with query problem on web site
by aparajita
::
Rate this Message:
> I have found in a few instances that querying is limited to 40 > characters. 41 characters to be exact. Regards, Aparajita www.aparajitaworld.com "If you dare to fail, you are bound to succeed." - Sri Chinmoy | www.srichinmoy.org _______________________________________________ Active4D-dev mailing list Active4D-dev@... http://mailman.aparajitaworld.com/mailman/listinfo/active4d-dev Archives: http://mailman.aparajitaworld.com/archive/active4d-dev/ |
| Free embeddable forum powered by Nabble | Forum Help |
