Devart Forums

Hello
Can i create non-scalar (e.g. table-valued) user-defined function with TLiteUtils.RegisterFunction ?

"Table-valued" means a function that returns a dataset

You can implement table functions using a virtual table mechanism, which relies on the SQLite API. Our components don't provide access to that API. For our components, you can develop a table function as an extension:

https://www.sqlite.org/loadext.html
https://docs.devart.com/litedac/devart. ... ension.htm