I am working in a functionality where i have to generate the where clause dynamically and pass it on the while select loop to execute the further logic.
Below is the complete steps :-
1. I have a parameter form , where user will define the validation fields and conditions with AND /OR and multiple lines
2. I have to read the parameter records and looped it and create a where clause reading the fields validation from the parm table.
It will look like this .
Parameter Forms
Parm table has below condition
condition = Mycustomtable.Field1 >= today && Mycustomtable.DeliveryFromDate >=today()
I have below code and want to create the where clause reading the parm records and apply condition
While Select MyCustomtable where condition *******(Here parm table condtion should apply automatically )
{
//Do something
}
Note :- Need help to apply condition on while loop and that condition should be created in the runtime and applied on the run time
Any help would be appreciated !
.
