>>Hi Folks!
>>
>>Today I got another boring Problem.
>>Im my APP, I use Views mixed with SQL Pass through. The Views and the SQL pass through Connections all shared. Now sometimes I got an ODBC Error:
>>
>>Original in German:
>>Datenbankfehler 0: [Microsoft][ODBC SQL Server Driver]Die Verbindung ist mit Ergebnissen von einem anderen hstmt belegt
>>
>>I Try to translate:
>>Databaseerror 0: [Microsoft][ODBC SQL Server Driver] Connection is used by another hstmt.
>>
>>What is this?
>
>Hi Jorg,
>
>This error might indicate that you are trying to execute some command through a connection handle but VFP hasn't fetched all data for the previous execution. This usually happens when you open a view with FetchSize>0 and then try to execute something through the same connection handle.
>I assume you are using VFP7 or earlier version. To avoid this error, use FetchSize=-1 for the view or execute GO BOTTOM IN ViewWorkArea before executing the next command. In VFP8, you can share the same ODBC connection without sharing the same connection handle.
>
Well, we used VFP8. And every view we are using has :
dbsetprop(tcView, "VIEW","MaxRecords" , -1)
dbsetprop(tcView, "VIEW","FetchAsNeeded", .f.)
dbsetprop(tcView, "VIEW","FetchSize", -1)
I'm totaly confused about these troubles.