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

> At 08:39 AM 27/02/2003 +0000, you wrote:
> >HI all,
> >I have a big problem now...
> >I am not able to insert new record in my database,
> >I always got this error: 'conversion error from string "314"'
> >calling the SP who create the id of the record,
> >what is mean? What I can do?
> >GFix show now problem on database.
> >
> >Details:
> >
> >-Windows2000
> >-Firebird 1.0.1 (810)
> >
> >The SP is:
> >
> >BEGIN
> > OID=GEN_ID( OID_GENERATOR, 1 );
> > INSERT INTO oid_info VALUES
> > ( :OID, :TABELLA, 'NOW', :OID_UTENTE,

0, :USERNAME, :COMPUTER );

> > SUSPEND;
> > EXIT;
> >END
>
> 1. Is 314 the value you are expecting in the variable OID? If so,

check

> up on the column order of your table, to see which column is first.
>
> A better cure for a mismapped column list will be to provide a

proper

> column list in the INSERT INTO (..) clause of this query.
>
> 2. Try changing the timestamp column's value to
> CAST ('NOW' as TIMESTAMP) or CURRENT_TIMESTAMP. Dialect 3

won't

> recognise date literals if they are not cast.
>
> heLen

Thx heLen,
I will update my SP with this tips, but after a backup/restore
the same operation work fine, 314 has nothing to do with my
data, I have nothing like 314...
This is the second time I got this problem, the first last december,
always the error was the same 'conversion error from string "314"'
Thx for cooperation...