Oops!

forget this:

Firebird 1.5.2
on Linux Fedora Core 3

:D


Hello!!!

I have this table with 864 records:

SET SQL DIALECT 3;
SET NAMES ISO8859_1;

CREATE TABLE COMPRASDET (
IDCOM INTEGER NOT NULL,
IDARTICULO IDARTICULO NOT NULL /* IDARTICULO = VARCHAR(16) */,
CANTIDAD FLOAT NOT NULL,
COSTO FLOAT NOT NULL,
DESCUENTO FLOAT DEFAULT 0,
IVA FLOAT DEFAULT 0,
IEPS FLOAT DEFAULT 0,
IVBSS FLOAT DEFAULT 0,
TOTCOSTO FLOAT NOT NULL
);

I add a new field:

IDCOMDET INTEGER

But whe I try to post a value just in record 22 show this:

/*
Cannot Post Changes!
There is at least one record with same fields values!

Error Message:
----------------------------------------
Invalid token.
Dynamic SQL Error.
SQL error code = -104.
Unexpected end of command.
*/

and it's imposible to continue.

I try to update this field with my application in delphi but is the same
error
if I try to update on IBExpert ver 2005.04.25 the error is the same.

in the record 27 is the same error..

any tips??

thanks for your help!

Regards

Alex Bautista
Cancun Mexico