Subject Re: [firebird-support] Unclear error calling sp from delphi
Author Helen Borrie
At 02:15 PM 10/09/2004 +0000, you wrote:
>Hi all,
>I have a stored procedure in firebird 1.5 wich wordks from IBConsole
>and from sqlexplorer, but fails when called from delphi.
>The error I get is "General SQL error. Internal error".
>I am using Delphi 4 and the BDE.

The InterBase driver for the BDE with Delphi 4 is for InterBase 5.0.

>I already tried it in a very simple program, the error stays. Other
>Stored Procedure in the same database are working just fine, the only
>difference is that this sp adds records to a table with a calculated
>Anybody any idea?

Yup. InterBase 5 didn't support the TIMESTAMP type or quoted identifiers.
There are other data types it won't support; and a large number of new SQL
constructs. The nearest you'll get to supporting Firebird is BDE 5.2 (the
last-ever) driver which I think you can ONLY get with Delphi 6
Enterprise. But it doesn't fully support the Dialect 3 datatypes
either. (Borland has completely deprecated the BDE for everything but
Access and Paradox...)

Basically, ditch the BDE and get an alternative data access layer. IB
Objects (I think) is the only (and anyway, best) option for working with
Firebird and Delphi 4. (Though UIBComponents and one or two of the other
"thin" data access packages *might* have a Delphi 4 version...)

btw, this is not a Delphi list.