>It appears that when I requery a remote view (SQL Server), any SQLEXEC commands are not working if done immediately after the requery. Is there something I can do to allow the SQL Passthru commands to work even if it is still trying to requery the view? I move the requery and everything is fine?? Put the requery back in and the SQLEXEC returns -1.
>
>Thanks,
>Doug

Check why SQLEXEC() returns -1

IF SQLEXEC(.....) < 0

*** UPDATE It is not a good idea to use a reserved words as a variables, sorry

   AERROR(arErr)
   DISPLAY MEMORY LIKE arErr
ENDIF