How do I call a SQL UDF from clarion?

[ChrisH2]

Has anyone managed to call a SQL function from clarion?

I am able to call a stored procedure and pass parameters back as per the help. I do this by binding a data field and using &myVar [out]. There is nothing in the help with regards to functions.

Has anyone got any ideas?

Thanks,

Chris

 

[ShankarJ]

Hi Chris,

An SQL UDF function is not called directly but through a SELECT statement. In Clarion, you can use the PROP:SQL to do that i.e.

File{PROP:SQL} = 'SELECT UDF(Column) FROM Table'

Regards

 

[ChrisH2]

Thanks ShankarJ that did the trick.