>>With sys(2335) I set unattended mode. This line of code has run over 2000 times with no trouble (no errors, no negitive returns):
>>
>>lnRet = sqlexec( phSqlHdl, pcSqlCmd )
>>
>>but sometimes my error handler gets called and shows this:
>>
>>Error: #2031, User-interface operation not allowed at this time.
>>Line #: 2627
>>
>>which is the above line.
>>
>>the whole program can be found at:
>>
>>
http://www.personnelware.com/temp/bv.prg>>
>>Why is SQLEXEC() tripping a UI event?
>>
>>^Carl Karsten
>
>
>Probably VFP is trying to display an error message. Could there be a problem with the ODBC connection?
Could be, but I am not aware of any problems that would cause UI. The user name and password are ok, the network connection is ok. The current version of the program has been in use for two months, getting run about 400 times a week (3200 runs). The previous version did not use the Oracle server, it read .txt files. Testing of the current version was minimal, as the previous version has been in use for 3 years. I only enabled the "Unattended Server Mode" 2 weeks ago, and I have run into this problem 2 times in the last 800 runs. It is worth noting that we were having Oracle performance problems.
As I am writing this, it happened again, only on this line:
REPORT FORM (XRPTNAM) TO FILE (SUBSTR(STRTRAN(cpFilNam,'.'),1,8)+".RPT") ASCII
Again, there shouldn't be any UI going on.