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]
