G
Guest
Dear all,
I am passing parameters to store procedure without any troubles but
parameters list are less than 10 parameters, still manageable.
But we have a situation where we do not know for instance the number of
variable my final customer would like to monitor and store to database.
It can be a list of 20 variabls or 50 or more...
I was wondering what is the best way to pass an unknown list of parameters
to a store procedure , can we use arrays ? XM files ?
one parameter will correspond to one table field at the end
What is the best way to do it and how ?
thanks for help
regards
serge
I am passing parameters to store procedure without any troubles but
parameters list are less than 10 parameters, still manageable.
But we have a situation where we do not know for instance the number of
variable my final customer would like to monitor and store to database.
It can be a list of 20 variabls or 50 or more...
I was wondering what is the best way to pass an unknown list of parameters
to a store procedure , can we use arrays ? XM files ?
one parameter will correspond to one table field at the end
What is the best way to do it and how ?
thanks for help
regards
serge