--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@t...>
wrote:

> 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

> >field ("ONTVANGENOP" TIMESTAMP Default 'Now' NOT NULL).
> >
> >Anybody any idea?
>
> Yup. InterBase 5 didn't support the TIMESTAMP type or quoted

identifiers.



Never seen any problem there.

> 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...)
> See http://www.ibphoenix.com/main.nfs?a=ibphoenix&page=ibp_dev_comps
>
> btw, this is not a Delphi list.

No it isn't, but still the question is a firebird realated question!

>
> ./heLen

The cause of this problem was in the parameter list generated by the
BDE. It converted the last field (varchar(1024) to a parameter of
type blob.

The solution was simple, h=just manually adjust the parameter
settings to string and all worked fine.

Thanks for your help.

Glenner003