Can you post what the char string is that you're using when it doesn't work? You have to build it out to include formatting.
As for the 1=1 when you're leaving blank, it is probably building that to show all, as it likely needs to put in something. I don't see that as anything to worry about. Thanks, Mark -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of koray Sent: Friday, September 04, 2009 8:31 AM To: arslist@ARSLIST.ORG Subject: Re: Qualification EXTERNAL() Issue - Returns Nothing Update on situation: When the qualification string is empty log files reads SELECT (......) FROM (...) WHERE (1 = 1) ORDER BY 6 ASC and lists all the data, as i had mentioned previously. On Sep 4, 3:13 pm, koray <ko...@alkankoray.net> wrote: > Dear List, > > I again have an issue but this seems a bit meaningless to me. > > I have a table on my form retrieving data from X form with every > fields of it added as columns. > > I also created a Character Field and set the table's Qualification to > that char field as External(). > When I refresh the table without any qualification - in other words > when the char field is empty - table lists all the data. > > But, when I enter a valid qualification string in the char field, I > get nothing. Log file shows like > > SELECT (......) FROM (...) WHERE (1 = 0) ORDER BY 6 ASC > > 1) where does 1=0 come from? Isn't it meaningless? > 2) Although I have not set any Order option from Table Properties > ORDER BY 6 ASC occurs. > > Any ideas? > > Regards, > > Koray. > > ___________________________________________________________________________ > ____ > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"