Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. Database & SysAdmin
  3. Database
  4. how to update foreign key

how to update foreign key

Scheduled Pinned Locked Moved Database
databasehelptutorialannouncement
3 Posts 3 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • S Offline
    S Offline
    shabi uz zaman
    wrote on last edited by
    #1

    i m having 2 table rolles and forms . rolles having a pk roll_id which is foreign key in forms table. now i want to update the forms table.but it is generating error. how to write the query.

    P M 2 Replies Last reply
    0
    • S shabi uz zaman

      i m having 2 table rolles and forms . rolles having a pk roll_id which is foreign key in forms table. now i want to update the forms table.but it is generating error. how to write the query.

      P Offline
      P Offline
      Paul Conrad
      wrote on last edited by
      #2

      shabi uz zaman wrote:

      it is generating error

      That's not really helpful. You expect people to look in their crystal ball and know the answer for you. Try being more descriptive.

      "I guess it's what separates the professionals from the drag and drop, girly wirly, namby pamby, wishy washy, can't code for crap types." - Pete O'Hanlon

      1 Reply Last reply
      0
      • S shabi uz zaman

        i m having 2 table rolles and forms . rolles having a pk roll_id which is foreign key in forms table. now i want to update the forms table.but it is generating error. how to write the query.

        M Offline
        M Offline
        Mark Churchill
        wrote on last edited by
        #3

        You have defined that Roles inherit Forms... is this really what you intended?

        Mark Churchill Director Dunn & Churchill Diamond Binding: Zero to Data Layer in 3 mins

        1 Reply Last reply
        0
        Reply
        • Reply as topic
        Log in to reply
        • Oldest to Newest
        • Newest to Oldest
        • Most Votes


        • Login

        • Don't have an account? Register

        • Login or register to search.
        • First post
          Last post
        0
        • Categories
        • Recent
        • Tags
        • Popular
        • World
        • Users
        • Groups