Using Pervasive SQL v8.7sp3
I am trying to do an SQL SELECT statement with a function in that statement
like this:
//===========================================
Function myFunction Integer iSomeValue Returns Boolean
Function_Return (TRUE)
End_Function
SELECT from MyFile where ( (MyFunction(iSomeValue)) = (TRUE) )
//===========================================
1. Can I use a function in a SELECT statement? (I need to check the
contents of an array)
2. Is my syntax close?
Many thanks. Jim