Inserting record in a table

[Former Member]

Hi Experts,

I have created one table with three fields and all these fields have foreign key associated with it. I have inserted one record

sucessfully and when i am trying to insert one more record it says that it already exist which is not avialable in that table.

Can anybody tell me possible reason behind this.

Thanks,

Ahmed.

[Former Member]

May be you are trying to insert same record again.

Please check.

Regards

[Former Member]

hi,

may be ur key field data is same.. check ur key field in the table .. and see that u r not passing same data for key field in multiple records.

Rgds.,

subash

[Former Member]

Hi,

I have two tables employ and dept . First having the following fields

like Mandt, carrid , dept and empno and second table has

fields like Mandt, Carrid and dept and all fields in both the tables are primary keys except empno in first table.

In first table Mandt has foreign key relationship with table T002 (foreign key fields are Mandt ).

Carrid has foreign key relationship with table scarr

( foreign key fields are Mandt and carrid).

Dept has foreign key relationship with dept table

( Foreign key fields are Mandt , Carrid and dept ).

I ve inserted few entries in dept table.

Now when i am trying to insert second record in first table that is employ table it say it already exist.

Please please dont reply me saying that i am inserting already existing record or same key fields.

Thanks a lot,

Ahmed.

[christine_evans]

>

> 
> Now when i am trying to insert second record in first table that is employ table it say it already exist.
> 
> Please please dont reply me saying that i am inserting already existing record or same key fields.
> 
> Thanks a lot,
> Ahmed.

I'm sorry but it does sound as if you are trying to insert the same record - or rather the same record key - twice. Unless you don't believe what your database error messages are telling you.

[Former Member]

Hi ahmed,

I think there will be a problem in cardinality. Check out the cardinality n:m or check out the foreign field type in semantic attributes.

Regards,

Ragu

Edited by: Ragu Prasad on Oct 15, 2008 11:25 AM

[Former Member]

Hi Raghu,

Please see my reply and also i have for all the fields the same cardinalities like 1: CN and foreign key types as key fields/candidates still i am able to produce the same error.

Please help me.

Thanks,

Ahmed.