Page 1 of 1

Custom-defined functions for retrieving Data

Posted: Mon Sep 11, 2017 8:06 am
by junixquiaoit
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.
jp.png
jp.png (93.44 KiB) Viewed 2258 times

Thanks.

Re: Custom-defined functions for retrieving Data

Posted: Mon Sep 11, 2017 10:06 pm
by Alex K.
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.

Re: Custom-defined functions for retrieving Data

Posted: Tue Sep 12, 2017 5:55 am
by junixquiaoit
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.

Re: Custom-defined functions for retrieving Data

Posted: Thu Sep 14, 2017 8:05 am
by HighAley
Hello.

You could use your custom functions on the Code tab.
Please, add them before the Auto Generated Code.

Thank you.