>I get incorrect results (mostly, the fields from the view are missing) unless
>I issue the same SQLEXEC twice when I execute:

Two thoughts: check the return value from the SQLEXEC call, and turn ODBC tracing on and see if anything in the log looks strange after that call.