Results 1 to 2 of 2

Thread: relational records cann delete - how to catch the error

  1. Sep 29th, 2003, 01:08 AM #1
    parthi_75
    parthi_75 is offline

    Thread Starter
    Addicted Member
    Join Date
    Feb 2001
    Location
    bkk
    Posts
    224

    relational records cann delete - how to catch the error

    hi all
    i have a table related with another table probably master and tranasaction. when user tryies to delete a record in the master it has to indicate that the record is related or exists in a trasactional table. is it possible to check without checking the transaction table. replies and help will be appreciated
    thanks
    parthi
    Reply With Quote Reply With Quote
  2. Sep 30th, 2003, 05:46 PM #2
    randem
    randem is offline
    Banned randem's Avatar
    Join Date
    Oct 2002
    Location
    Maui, Hawaii
    Posts
    11,385
    parthi_75


    Use Relationships. This is what relational databases are for. If you try to delete the master while transactions exist you will get an error. Trap the error and do what you need to do.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width