Seems like certain forms do not accept ANY External Qualifications. Even setting 1=1 in Character Field for External Qualification gives
SELECT (......) FROM (...) WHERE (1 = 0) ORDER BY 6 ASC in log file and returns nothing. On Sep 4, 5:26 pm, koray <ko...@alkankoray.net> wrote: > Situation Update 2: > EXTERNAL() works on SOME other forms correctly with form 'Task ID' = > "TSK00001". I have double-checked every field's database name and > there should be no error. > > Could there be any other, what i am going to call, "weird" reason? > > Regards, > > Koray. > > On Sep 4, 4:36 pm, Mark Lev <mark....@rightstarsystems.com> wrote: > > > > > > > You need to build the string literally. > > > String = "'Task ID' = " + """ + "TSK00001" + """" > > > I may be slightly off on syntax of embedding a double quote, that may take > > a little tweaking. What I do is make the char string visible and editable, > > so I can see what is being populated, and can manually tweak it to figure > > out what is right. If you're embedding a variable, i.e. $USER$, you may > > need to put a \ in front of the var name $\USER$ so it isn't interpreted > > when compiled. Again, you will need to tweak to get it exactly right. > > > 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:51 AM > > To: arsl...@arslist.org > > Subject: Re: Qualification EXTERNAL() Issue - Returns Nothing > > > 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 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"