>Your solution seemed simpled and elegant. However, when I use this snippet, I don't get results back from the SQL Statement. There is no Error either.
>
>Any clues..?
>
>TIA

With SQLExec (except some specific ones) you don't get any immediate error. Check return valuye, if it's lt 0 then check for error. ie:

if SQLExec(lnHandle, lcSQL, lcResultCursorName ) < 0
  CheckError(lcSQL)
*...

Function CheckError
Lparameters tcSQL
local ix,lcError
local array arrCheck
lcError=tcSQL+chr(13)
Aerror(arrCheck)
For ix=1 to 7
  lcError = lcError+trans( arrCheck [ix])+ chr(13)
Endfor
Messagebox(lcError,0,'Error def.')
return

Cetin