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 at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
