osql -b return ERRORLEVEL but "for do ()" cleans it!

• SwePeso

  SSC-Dedicated

  Points: 39758

  More actions

  July 6, 2006 at 7:59 am

  #647752

  I think once that you have referenced %ErrorLevel%, it is automatically set to Zero as it is very volatile.

  Try to save %ErrorLevel% first with

  Set a = %ErrorLevel%

  echo a

  if not %ERRORLEVEL% == 0 goto an_ERROR_label

  ---

  N 56°04'39.16"
  E 12°55'05.25"

• leonardo cocchi

  SSC Journeyman

  Points: 98

  More actions

  July 6, 2006 at 8:25 am

  #647765

  extremely volatile  I'have tried... without success. Another test:

  for  %%x in (*.sql) do (

    osql -S %SERVER% -U %MYUSER% -P %MYPWD% -b -e -n -i %%x >> %OUTPUTLOG%

    echo result: %ErrorLevel% >> %OUTPUTLOG%

  )

  after the call osql, echo of errorlevel returns 0...