Hi Sirs/Ma'ams,
I would like to ask if there's a way to create a custom-defined function that uses data from Databand as parameters and use these to retrieve data in SQL that returns a value. In short, if there's a way to create a custom-defined function that doesn't use a Data Source. If there's a way, I would like to know how can it happen.
Thanks.
Custom-defined functions for retrieving Data
-
- Posts: 38
- Joined: Thu Jun 23, 2016 2:03 am
Re: Custom-defined functions for retrieving Data
Hello,
As a way, you can send in your function DataTable - DataSourceName.DataTable
Please check the sample project with custom function in the attachment.
Thank you.
As a way, you can send in your function DataTable - DataSourceName.DataTable
Please check the sample project with custom function in the attachment.
Thank you.
- Attachments
-
- AddCustomFunction.zip
- (36.11 KiB) Downloaded 166 times
-
- Posts: 38
- Joined: Thu Jun 23, 2016 2:03 am
Re: Custom-defined functions for retrieving Data
Hi,
It is working on run time. Thanks for the help.
But I would like to know where I can see my custom-defined function on Designer. Is it available also on Expressions window?
Thanks.
It is working on run time. Thanks for the help.
But I would like to know where I can see my custom-defined function on Designer. Is it available also on Expressions window?
Thanks.
Re: Custom-defined functions for retrieving Data
Hello.
You could use your custom functions on the Code tab.
Please, add them before the Auto Generated Code.
Thank you.
You could use your custom functions on the Code tab.
Please, add them before the Auto Generated Code.
Thank you.