Pass a date to stored procedure
|1/27/2023 2:41:43 AM
|PHPRunner General questions
I have a stored procedure that returns a stock, a parameter is a date
How can i pass that date string to the stored procedure.
You can achieve this if you create a SQL View in PHPRunner that is based on your stored procedure call:
|fvdb author 1/30/2023
The problem is that the filter is not returned in the stored procedure. Let me elaborate.
Now I need to pass the date @a to the stored procedure, currenty i am trying to create a database with just one date, and based upon that date create a qustom query, but it should be easier to do with the "SQL views" i guess.
The result must be that i get a stock on a particular date.
Your latest response didn't provide any new info. What exactly causes the trouble implementing this with the help of a SQL View?