Hi Kurt,

1) Connection must have set support for BatchProcessing
2) You cannot call SQLMORESULT() without first caliing SQLEXEC()
3) You cannot call next SQLEXEC() while SQLMORERESULT() return value < 2

=SQLEXEC(handle_odbc,"SELECT 1 FROM table; SELECT 1 FROM table; SELECT 1 FROM table;")

liRet=0
DO WHILE liRet<2
   liRet=SQLMORERESULT(handle_odbc)
   IF liRet<0
      * Connection or SQL Command is not valid
      EXIT
   ENDIF

   IF liRet=0
      * Command is executing (for Asynchronous conections)
   ENDIF

   IF liRet=1
      * Command is done
   ENDIF

   IF liRet=2
      * No any SQL Command for executing
   ENDIF
ENDDO

MartinJ

>thnx david,
>
>didn't know spt means sql pass through.
>
>we do error handling afther 'spt' but the program doesn't seems to bug. Only the next time the user restarts the program than he gets the 'Appel non valide émis lors de l'exécution d'une séquence SQLMORERESULTS()' (french os). When i open the database and i check the connection settings then they are changed. And nowhere in the program we change these settings... AND this happends only with win98 os, the others like xp are working well.