KeithBrown53
Programmer
Greetings
I'm on BO 6.5.
I'm attempting to add a new object into a universe, which will execute a function on my database. The function name is f_count_admissions, and takes 2 parameters, returning a number.
The parameters are called p_date_from and p_date_to.
I'm trying to enter the following into the select box of the new object:
f_count_admissions (@prompt('DATE FROM','D',,,) , @prompt('DATE FROM','D',,,))
.....but on selecting the parse push-button, I get invalid table name. What am I doing wrong?
Thanks,
Keith.
I'm on BO 6.5.
I'm attempting to add a new object into a universe, which will execute a function on my database. The function name is f_count_admissions, and takes 2 parameters, returning a number.
The parameters are called p_date_from and p_date_to.
I'm trying to enter the following into the select box of the new object:
f_count_admissions (@prompt('DATE FROM','D',,,) , @prompt('DATE FROM','D',,,))
.....but on selecting the parse push-button, I get invalid table name. What am I doing wrong?
Thanks,
Keith.