I have found that you get 1=0 when Remedy does not like the qualification string. This could be because of incorrect syntax or bad column names.
On Fri, Sep 4, 2009 at 3:31 PM, koray<ko...@alkankoray.net> wrote: > 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"