can you give any example on TLiteUserFunction to get back a result parameter ?
And how to register the function ? I expected an Execute method or Active prop...
I have defined a simple function funCountStatus2 as
Code: Select all
SELECT COUNT(*) FROM :aTable WHERE STATUS = 2;
Code: Select all
LiteUserFunction.FunctionName := 'funCountStatus2';
I have used a TLiteSQL to call the function
Code: Select all
SELECT funCountSendStatus1(:aTable) as count;
Can you help ?