[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
SQL_AUTOCOMMIT
- Subject: SQL_AUTOCOMMIT
- From: Miguel Angel Jimenez Gil <sanmiguel_jg@YAHOO.ES>
- Date: Wed, 1 Mar 2000 12:27:53 +0100
I'm doing a migration from SQR 3 to SQR 5.1 and i'm
using the Brio.Report Builder for coding and for
lunching the Reports the executable:
\sqribe\sqr\odb\binw\sqrw.exe(SQR 5.1).My database is
SQLSERVER 7.
When I lunch a report of SQR 3 with this executable
the following error appear:
"(SQR 5528) ODBC SQL dbexec: SQLExecute error 0 in
cursor 2:
[INTERSOLV][ODBC MS SQL Server 6 driver]You cannot
have more than one statement active, when
SQL_AUTOCOMMIT is false.
Error on line 389:
(SQR 3735) Could not execute SQL.
Cursor #2:
SQL = CONVERT(FLOAT, ROUND(CONVERT(MONEY, ?), ?))
@Result let ? = @Result
Compiles = 1
Executes = 0
Rows = 0 "
Any help is grateful.
Excuse my possibles mistakes with the English.
Málaga(Spain)
_______________________________________________________________
Do You Yahoo!?
Consiga gratis su dirección @yahoo.es en http://correo.yahoo.es