> 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

big tip....
put a primary key on the table and populate it with unique values.
Alan