Koray if you are entering the qualification as 'Task ID' = "TSK000001" in an external qual it will not work, you need to put the double quotes within two double quotes so the 'TSK000001' needs to be something like " " "TSK000001" " " . I have put spaces to show you the double quotes, you need to remove the spaces. make your char field visible and then have a look at what the qualification looks like and you will what is wrong. you can enter the qual as you have shown in the EXTERNAL qualification field and just right click on the table and refresh it, it will show the correct data, but if you do a Set Fields then you have to triple the double quotes. Let me know if this fixes your problem or you need further help. thanks shafqat ayaz
--- On Fri, 9/4/09, koray <ko...@alkankoray.net> wrote: From: koray <ko...@alkankoray.net> Subject: Re: Qualification EXTERNAL() Issue - Returns Nothing To: arslist@ARSLIST.ORG Date: Friday, September 4, 2009, 1:50 PM Qualification I am using is something basic like 'Task ID' = "TSK000001" just to test it. Weird thing is that when I enter the qualification string manually on Table Properties it works perfect, but not via the character field. On Sep 4, 3:37 pm, Mark Lev <mark....@rightstarsystems.com> wrote: > 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: arsl...@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 atwww.arslist.org > Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" > > ___________________________________________________________________________ > ____ > 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"