Here it is Sharon, to the group.... Thks for all those who considered their precious time to reply me in my problem, Here is the solution, which was suggested by Sharon ....... OK! Ma....am Remain Kooollll......, Mohamed Ashraf Memon Advanced Micro Devices (Singapore) TEL : 7969-888 X 39826 FAX : 4492-360 DID : 7969-826 Email : [EMAIL PROTECTED] > -----Original Message----- > From: Sharon Buntz [SMTP:[EMAIL PROTECTED]] > Sent: Wednesday, July 21, 1999 12:13 AM > To: Memon, Mohd-Ashraf > Subject: Re: PFCSIG PFC Query Mode Service (Limitation or Not) > Question....... > > Great, glad you got it working! > > Don't forget to let the group (groups<g>) know what it was. > > Have fun, > ~Sharon > > > [EMAIL PROTECTED] wrote: > > > > First, > > > > Thanks Sharon It works fine, when I put the parentheses around, > > > > Secondly > > Yes Sharon, I need to have the where clause around as the situation is > like > > this > > > > A user belongs to a group or doesn't belongs to the group, > > > > if user_belongs_to_the_group then > > show_group_specific_records_only > > else > > show_all > > end if > > > > Lastly > > > > Sorry for putting it on all the list at one time, reason my lazyness to > > actually type the list address, I have created a group called PBGurus > Advice > > in my outlook, whenever I need to place a question I just select that > group > > and it sends to all, > > > > Again alot of apologies for that next time I'll make sure I put it on > one > > list...... > > > > Thks for the reply, > > > > Happy Sleeping (1355 hrs here in Singapore, so definitely should be > night in > > US), Sweet Dreams...... > > > > Remain Kooollll......, > > Mohamed Ashraf Memon > > Advanced Micro Devices (Singapore) > > TEL : 7969-888 X 39826 > > FAX : 4492-360 > > DID : 7969-826 > > Email : [EMAIL PROTECTED] > > > > > -----Original Message----- > > > From: Sharon Buntz [SMTP:[EMAIL PROTECTED]] > > > Sent: Tuesday, July 20, 1999 1:13 PM > > > To: Memon, Mohd-Ashraf > > > Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; > > > [EMAIL PROTECTED] > > > Subject: Re: PFCSIG PFC Query Mode Service (Limitation or Not) > > > Question....... > > > > > > Hi, Mohamed > > > > > > I think it is your "OR" in your WHERE clause throwing it off. Try > putting > > > a set of parentheses around your (x OR y), like this > > > > > > Select A,B,C,D from tableA where (A = :arg OR :arg is null); > > > > > > What happens is that the native PB-level QueryMode simply appends some > > > more > > > ...AND z... to your WHERE clause. And so that "OR" would make it > > > WHERE x OR y AND z. And "AND" goes first. So effectively, you are > > > getting > > > > > > Select A,B,C,D from tableA where A = :arg OR (:arg is null AND B = > 'b'); > > > > > > By the way, do you need to have a WHERE clause in your DW? Because it > is > > > not needed for QueryMode. Just double-checking on that. Also, please > try > > > to post to only one mail list at a time <g> > > > > > > Good luck and let us know what it turns out to be. > > > > > > Have fun, > > > ~Sharon > > > -- > > > Sharon Weinstrom Buntz | mailto:[EMAIL PROTECTED] > > > Cheat Sheet for PFC/PB Help | http://www.pfccheatsheet.com/ > > > > > > > > > > > > > > > [EMAIL PROTECTED] wrote: > > > > > > > > Hi PBers > > > > > > > > I am facing a serious problem with query mode or you can say > retrieve > > > > function of PFC Services. I haven't tried this with PB direct codes > so I > > > > can't say 100% PB problem but my gut feeling tells me that it is > > > Powersoft > > > > problem also. > > > > > > > > Firstly let me describe my sql statement > > > > > > > > Select A,B,C,D from tableA where A = :arg OR :arg is null; > > > > > > > > We all know that when this query is issued if the :arg is passed, > result > > > > would be records for specified :arg, and when it is null it would be > all > > > > > > > > This works fine..... > > > > > > > > Now when I turn on my querymode service and enter parameters in the > > > > querymode, It should retrieve based on querymode parameters taking > the > > > first > > > > where clause into account.... > > > > > > > > What happens is that if in the first where clause :arg was null > > > everything > > > > works fine, but if :arg was some valid parameter,it will ignore the > > > > querymode parameters and pass back the result from the first query > > > > itself.... > > > > > > > > Isn't this strange, a user takes all the pain to enter the > parameters in > > > the > > > > query mode and then turn off query mode waiting for the result to be > > > shown > > > > as desired and what comes out is the same sickening old result.... > > > > > > > > Does any of you... has any solution to this problem/ a work around > would > > > > also do because of emergencies...... > > > > > > > > Remain Kooollll......, > > > > Mohamed Ashraf Memon > > > > Advanced Micro Devices (Singapore) > > > > TEL : 7969-888 X 39826 > > > > FAX : 4492-360 > > > > DID : 7969-826 > > > > Email : [EMAIL PROTECTED] > > > > > [EMAIL PROTECTED] HOSTED BY IIGG, INC. FOR HELP WITH LIST SERVE COMMANDS, ADDRESS > A MESSAGE TO [EMAIL PROTECTED] WITH THE FOLLOWING MESSAGE: help pfcsig > SEND ALL OTHER INQUIRES TO [EMAIL PROTECTED]
