Search found 6 matches
- 13.04.2017, 15:33
- Forum: ZeosLib 7.2 Forum
- Topic: Error with autocommit and parameters
- Replies: 3
- Views: 569
Re: Error with autocommit and parameters
Just putting a cast in the parameters in SQL to force the type it already works. Without the cast the error remains when opening the query ex: NOT Error cast (:UN_MEDIDA as varchar) cast (:id_item as integer) ex: Error :UN_MEDIDA :id_item It seems some problem in the parse of the parameters that it ...
- 13.04.2017, 13:55
- Forum: ZeosLib 7.2 Forum
- Topic: Error with autocommit and parameters
- Replies: 3
- Views: 569
Re: Error with autocommit and parameters
THE ERROR HAPPENS ONLY IN AUTOCOMMIT MODE AND WITH SOME PARAMETERS, WHEN A TRANSACTION IS RE-START.
IT HAPPENS WHEN IT HAS NULL PARAMETERS.
IN OTHER CASES IT HAPPENS WITH ALL PARAMETERS POPULATED ALSO AS IN THE CASE ABOVE.
IT HAPPENS WHEN IT HAS NULL PARAMETERS.
IN OTHER CASES IT HAPPENS WITH ALL PARAMETERS POPULATED ALSO AS IN THE CASE ABOVE.
- 13.04.2017, 13:48
- Forum: ZeosLib 7.2 Forum
- Topic: Error with autocommit and parameters
- Replies: 3
- Views: 569
Error with autocommit and parameters
Same code in version 7.0.3-stable does not occur ERROR! Zeoslib- build 3986- versao test 7.2 postgreSQL 9.2 BERLIN UPDATE 2 --------------------------- Debugger Exception Notification --------------------------- Project raised exception class EZSQLException with message 'SQL Error: ERROR: current tr...
- 28.03.2017, 18:46
- Forum: ZeosLib 7.2 Forum
- Topic: When trying to connect ERangeError
- Replies: 4
- Views: 571
Re: When trying to connect ERangeError
i test the version of branch
http://sourceforge.net/p/zeoslib/code-0 ... sting-7.2/
and it's working ok
http://sourceforge.net/p/zeoslib/code-0 ... sting-7.2/
and it's working ok
- 28.03.2017, 15:36
- Forum: ZeosLib 7.2 Forum
- Topic: When trying to connect ERangeError
- Replies: 4
- Views: 571
Re: When trying to connect ERangeError
I tested the branch version version and running OK.
http://sourceforge.net/p/zeoslib/code-0 ... sting-7.2/
http://sourceforge.net/p/zeoslib/code-0 ... sting-7.2/
- 27.03.2017, 20:08
- Forum: ZeosLib 7.2 Forum
- Topic: When trying to connect ERangeError
- Replies: 4
- Views: 571
When trying to connect ERangeError
In Delphi 10.1 Berlin Update2 when trying to connect with postgresSQL 9.2 occurring is ERangeError. --------------------------- Debugger Exception Notification --------------------------- Project FlexTotal.exe raised exception class ERangeError with message 'Range check error'. ---------------------...