Subject | Re: [firebird-support] Timestamp in SP |
---|---|
Author | Helen Borrie |
Post date | 2004-08-02T06:56:03Z |
At 08:42 AM 2/08/2004 +0200, you wrote:
Could you provide your SP definition and *also* the statement that you are
using in your client app to submit the DDL request?
are trying to do this on a Firebird 1.0 server, or you are using a Fb 1.0
client with a Fb 1.5 server. Firebird 1.0 databases are ODS 10, not
10.1. In this case, the thing that prompts the DSQL error is anyone's
guess. It might be thrown, for example, when a Fb 1.0 server finds indexes
on a metadata table that it doesn't think ought to be there. (Indexing on
metadata tables was what prompted the ODS version stepping up at Fb 1.5).
No answers yet, only questions...
/heLen
> >That's a DSQL error, and there should have been a text message with it.
> > No, not at all. But SQL error -104 is a very broad "parent" for dozens of
> > language validity errors. Can you catch the gdscode? - that's the 9-digit
> > error code.
>
>335544569
Could you provide your SP definition and *also* the statement that you are
using in your client app to submit the DDL request?
> >If it's an ODS 10.1 database, that might be the source of problems if you
> > Where did the database come from?
>
>Firebird 1.0
>
> > Could it be an ODS 9 database?
>
>10.1
are trying to do this on a Firebird 1.0 server, or you are using a Fb 1.0
client with a Fb 1.5 server. Firebird 1.0 databases are ODS 10, not
10.1. In this case, the thing that prompts the DSQL error is anyone's
guess. It might be thrown, for example, when a Fb 1.0 server finds indexes
on a metadata table that it doesn't think ought to be there. (Indexing on
metadata tables was what prompted the ODS version stepping up at Fb 1.5).
No answers yet, only questions...
/heLen