Hi,

are you trying to use that select to put into another table? I just
ran over this error today and in my case it turned out to be that I
was trying to insert a string larger than the field's length.

Best regards,

Guillem

It is a simple table:

CREATE TABLE PROGRESSREPORTSUBMISSION (
ID INTEGER NOT NULL,
RECORDSOURCE CHAR (1) CHARACTER SET NONE NOT NULL COLLATE NONE);

/* Primary keys definition */

ALTER TABLE PROGRESSREPORTSUBMISSION ADD PRIMARY KEY (ID, RECORDSOURCE);

I get the error with : SELECT id from progressreportsubmission

--- In firebird-support@yahoogroups.com
<mailto:firebird-support%40yahoogroups.com>, "stevenggibb"
<stevenggibb@
...> wrote:

>
> I get the error below when running a simple SQL select on a table.
> I cannot find this error code in "The Firebird Book" or documentation.
>
> Incompatible column/host variable data type.
> Dynamic SQL Error.
> SQL error code = -303.
> arithmetic exception, numeric overflow, or string truncation.
>

Hi,

are you trying to use that select to put into another table? I just
ran over this error today and in my case it turned out to be that I
was trying to insert a string larger than the field's length.

Best regards,

Guillem