Hi!

George Simmons seems did the trick.

>I use:
>
>SQLEXEC(handle,"{Call MyFunction()}")
>
>For example..
>

>cinit=ALLTRIM(gcinit)
>cDB=ALLTRIM(cdb)
>cMainkey=ALLTRIM(cMainkey)
>cfunction=gettable("UpdatePdmLog")
>cType=ALLTRIM(cType)
>cOldLinekey=ALLTRIM(cOldLinekey)
>cNewLineKey=ALLTRIM(cNewLineKey)
>cData=ALLTRIM(cData)
>cStatus1=ALLTRIM(cStatus1)
>cStatus2=ALLTRIM(cStatus2)
>cAdmStatus=ALLTRIM(cAdmStatus)
>cAdmStatu2=ALLTRIM(cAdmStatu2)
>cAdmCode=ALLTRIM(cAdmCode)
>
>lcSQL="{Call "+cfunction+"(?cinit,?cDB,?cType,?cMainkey,?cOldLinekey,?cNewLineKey,?cData,?cStatus1,?cStatus2,?cAdmStatus,?cAdmStatu2,?cAdmCode,?nRec)}"
>nerror=SQLEXEC(gnconnectionhandle,lcsql)
>

>
>This shows how to use bind variables which of course has performance advantages.
>
>
>In addtion:
>
>http://govt.oracle.com/~tkyte/ResultSets/index.html
>This page tells all about returning results sets.
>There is an ODBC example writen in VB
>
>However, I tried it about 6 months ago and was unable to get it to work in VFP.
>If you succeed let me know.