the problem still unsolved....it returned an error below

Insert into Service (GroupNo,ServiceCode,ServiceName,SystemNo,Upload,timestampstr)

SELECT 6,ServiceCode,ServiceName,SystemNo,Upload,TIMESTAMPSTR

FROM Service

WHERE GroupNo=1

error

violation of PRIMARY or UNIQUE KEY constraint "INTEG_29" on table "SERVICE"

the primary key is the timestampstr

how...

ok tnx for the care...dont wori im gonna test it first into another database...if theres a way somehow to do it without removing the pk...is it possible?

its gnome database....a database used by firebird/interbase..if mysql uses *.frm for database file type...firebird/interbase uses *.fdb and *.gdb....so the pk just refuses duplicate entry just like wat i expected...ok tnx...

wat if il remove the pk of the table will it work? how will i know if wat field in the table is the primary key...i am using a gdb...

I hav tried the script u have given but it didnt work.................it show something like this...

violation of primary or unique key constraint "INTEG_25" on table "SERVICE"

wat does it mean?

by the...

ei guys i need ur help ive been reading ur post but i hardly understand it...i wanted to copy a record within same table changing only the value of a...