Dev, Member
Hi,
I created a report using a function instead of a procedure, but it doesn't seem to be saved anywhere. Is it possible to create a report using a function in MyDBR instead of placing the query inside a stored procedure?
Any help would be great on this front.
Thank you,
Shiva S
myDBR Team, Key Master
Functions and stored procedures are both database objects used to encapsulate logic, but they differ in purpose, structure, and usage.
Functions return a single value and are typically used inline within SQL queries (e.g., SELECT my_func(column) FROM mytable).
Stored procedures can return multiple result sets with multiple columns and are therefore the basis for myDBR reports.
What is the reason you are trying to use a function as a report?
--
myDBR Team
myDBR Team, Key Master
Functions and stored procedures are both database objects used to encapsulate logic, but they differ in purpose, structure, and usage.
Functions return a single value and are typically used inline within SQL queries (e.g., select my_func(column) from mytable).
Stored procedures can return multiple result sets with multiple columns and are therefore the basis for myDBR reports.
What is the reason you are trying to use a function as a report?
--
myDBR Team
You must log in to post.