topic Re: Inserting record in a table in Application Development and Automation Discussions

Inserting record in a table

Former Member — Wed, 15 Oct 2008 09:13:49 GMT

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.

Re: Inserting record in a table

Former Member — Wed, 15 Oct 2008 09:16:11 GMT

May be you are trying to insert same record again.

Please check.

Regards

Re: Inserting record in a table

Former Member — Wed, 15 Oct 2008 09:17:14 GMT

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

Re: Inserting record in a table

Former Member — Wed, 15 Oct 2008 09:24:41 GMT

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

Re: Inserting record in a table

Former Member — Wed, 15 Oct 2008 09:27:26 GMT

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.

Re: Inserting record in a table

Former Member — Wed, 15 Oct 2008 09:32:27 GMT

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.

Re: Inserting record in a table

christine_evans — Wed, 15 Oct 2008 09:32:50 GMT


> 
> 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.