Update 2 tables

Results 1 to 3 of 3

Thread: Update 2 tables

  1. #1
    Join Date
    Dec 1969

    Default Update 2 tables

    Is it possible to write a statement that will add records to 2 different tables?<BR><BR>Any ideas would be good.<BR><BR>Cheers, Tom ==&#062; thvr@bton.ac.uk

  2. #2
    Join Date
    Dec 1969

    Default 2 tables 2 commands

    Don&#039;t believe there is any way around it, you can only do one update/insert at a time.<BR><BR>-- Whol

  3. #3
    Join Date
    Dec 1969

    Default RE: 2 tables 2 commands

    Try using a Stored Procedure. Your ASP code will execute only execute one command and you can edit, modify as many tables as you want.

Posting Permissions

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