There is no way around the database query happening. I believe there was some discussion earlier in the week about the (1=2) submitting a wiry to the db.
For your table problem, What i have done is for any of my forms that use the external(), I have an active link that fires on open window and does a set field of "(1=2)". We do this for all table fields where required. We use this a lot in our system, for both the UserTool and mid-tier and have seen no issues or performance problems. Brent... Sent from my iPhone On Jul 30, 2010, at 4:11 PM, Jason Miller <[email protected]> wrote: > ** Hi Lisa, > > It would take a little extra workflow but you could have the $Query-Search$ > field default to something that will not return results. Then when the time > is right replace that with your real search. > > You could use 1=2. I just tried it out on a test form. I also logged it > client-side and it looks like it is going to query the db (maybe it is late > enough on Friday where most people are not looking at the List and the 1=2 > reference won't start a riot :) > > ************************************ > Fri Jul 30 2010 15:50:30.5980 */SELECT TOP 1001 > T773.C1,C536870915,C536870964,C536870965,C536871324 FROM T773 WHERE (1 = 2) > ORDER BY C536870915 ASC, 1 ASC > > Jason > > On Fri, Jul 30, 2010 at 12:07 PM, Kemes, Lisa > <[email protected]> wrote: > ** > I have a table that gets populated by a field that I build my query/search > on. So my table qualification is: EXTERNAL( $Query-Search$) (Query-Search > being the name of my field). > > If there is nothing in this field and someone clicks on the table, then ALL > the data on that form gets pulled into that table! > > I was hoping that if nothing is in my query-search field then nothing would > be populated into that table. :( > > Lisa Kemes > AR System Developer > Tyco Electronics > 717-810-2408 tel > 717-602-9460 cell > [email protected] > > > > _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ > > _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
