hi heLen,
searching on IB-Support I found my previous message,
(10/1/2003) and the reply of some other users who got
the same problem time to time, seem to be not only
a problem of my database..
Should be related to ('NOW') the literal time used?
because the error was generated at the same time of the day!
Thx

--- 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