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