Use PLSQL from Fast Report
Hi,
I'm using PostgreSQL and Fast Report.net, I have one Function in the Databse that I need to use it from the report, but I can't call it from Fast Report!!
Is there is anyway I can call the function:
Example: select * from Functionname();
Thanks,
I'm using PostgreSQL and Fast Report.net, I have one Function in the Databse that I need to use it from the report, but I can't call it from Fast Report!!
Is there is anyway I can call the function:
Example: select * from Functionname();
Thanks,
Comments
To call a function, use "exec" statement instead of "select":
exec Functionname
not sure about Postgres, but it works in MS SQL.