>thanks Naomi and Sergey.
>I will implement the error stuff but my simple code works now after the sql guy changed
> my permissions
>
>
>
I use this instead of SQLEXEC.
Pass the connection handle as the parameter.

PARAMETERS pn_connection
PRIVATE ln_result, la_errors, ll_return
ll_return = .T.
ln_result = SQLEXEC(pn_connection)
IF ln_result < 1
  ll_return = .F.
  = AERROR(la_errors)
  WAIT WINDOW "SQL Error: " + la_errors(3) 
ENDIF
RETURN ll_return