>>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.
>The error occur into the a View or into a SPT command ?
>You can put the code piece that generates the error?
The Error occur in an SPT command. The Code is difficult to write here, because of our Framework. Bud I try to:
this.ConString = "SERVER=Sql-server;DATABASE=ivs2000;TRUSTED_CONNECTION=Yes"
lcConName = this.ConName
lcODBCDriver = this.ODBCDriver
CREATE CONNECTION &lcConName CONNSTRING "DRIVER="+lcODBCDriver+";"+this.ConString
lnConHdl = sqlConnect(this.ConName, .t.)
sqlsetprop(lnConHdl,"IdleTimeout",0)
sqlExec(lnConHdl, "select max(aufneuanlage) as neuanlage from auftragseingang", "curTest")