Subject | Error in show LPAD |
---|---|
Author | Ismael L. Donis García |
Post date | 2010-01-08T16:57:09Z |
Excuse I did not change the subject
When I try to use the show lpad 2 times in the same sql does error give me, as solving this?
Starting transaction...
Preparing query: SELECT a.CODIGO, lpad(CAST(a.CUENTAUSD AS VARCHAR(4)),4, '0') AS CUENTAUSD, lpad(a.SUBCTAUSD, 3, '0') AS SUBCTAUSD
FROM ALMINV a ORDER BY a.CODIGO
Error: *** IBPP::SQLException ***
Context: Statement::Prepare( SELECT a.CODIGO, lpad(CAST(a.CUENTAUSD AS VARCHAR(4)),4, '0') AS CUENTAUSD, lpad(a.SUBCTAUSD, 3, '0') AS SUBCTAUSD
FROM ALMINV a ORDER BY a.CODIGO)
Message: isc_dsql_prepare failed
SQL Message : -204
Undefined name
Engine Code : 335544569
Engine Message :
Dynamic SQL Error
SQL error code = -204
Implementation limit exceeded
block size exceeds implementation restriction
WI-V2.1.3.18185 Firebird 2.1
WI-V0.9.3.1870 FlameRobin
Thanks
=========
¦¦ ISMAEL ¦¦
=========
[Non-text portions of this message have been removed]
When I try to use the show lpad 2 times in the same sql does error give me, as solving this?
Starting transaction...
Preparing query: SELECT a.CODIGO, lpad(CAST(a.CUENTAUSD AS VARCHAR(4)),4, '0') AS CUENTAUSD, lpad(a.SUBCTAUSD, 3, '0') AS SUBCTAUSD
FROM ALMINV a ORDER BY a.CODIGO
Error: *** IBPP::SQLException ***
Context: Statement::Prepare( SELECT a.CODIGO, lpad(CAST(a.CUENTAUSD AS VARCHAR(4)),4, '0') AS CUENTAUSD, lpad(a.SUBCTAUSD, 3, '0') AS SUBCTAUSD
FROM ALMINV a ORDER BY a.CODIGO)
Message: isc_dsql_prepare failed
SQL Message : -204
Undefined name
Engine Code : 335544569
Engine Message :
Dynamic SQL Error
SQL error code = -204
Implementation limit exceeded
block size exceeds implementation restriction
WI-V2.1.3.18185 Firebird 2.1
WI-V0.9.3.1870 FlameRobin
Thanks
=========
¦¦ ISMAEL ¦¦
=========
[Non-text portions of this message have been removed]