Skip to Content
avatar image
Former Member

Inserting record in a table

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Oct 15, 2008 at 09:16 AM

    May be you are trying to insert same record again.

    Please check.

    Regards

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 15, 2008 at 09:17 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      >

      >

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

  • avatar image
    Former Member
    Oct 15, 2008 at 09:24 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

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