MySQL Forums
Forum List  »  Stored Procedures

Re: Stored Procedure .. IF statement condition problem
Posted by: Peeyush Pandey
Date: March 15, 2013 07:46AM

sorry for that, i was mistaken but what i want is that if condition can be made dynamically, where the operator(<= or >=) is also dynamic, i am facing problem in operator only, like

if CalculatedPercent_val || ValidationOperator_val || AcceptableStats_val

where

CalculatedPercent_val => some number in float
ValidationOperator_val = is either <= or >=
AcceptableStats_val => some number in float

the values of ValidationOperator_val and AcceptableStats_val are coming from a table in database and CalculatedPercent_val is what i calculate and compare in above if condition.


Please help.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Stored Procedure .. IF statement condition problem
1789
March 15, 2013 07:46AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.