Multiple Updates

Results 1 to 2 of 2

Thread: Multiple Updates

  1. #1
    Zola Guest

    Default Multiple Updates

    Is it possible to update more than one table on the same form? Can I just use an SQL statement and proceed as I would for one table, or would I have to identify which table the data should be posted to?<BR><BR>TIA =)

  2. #2
    Join Date
    Dec 1969
    Posts
    2,849

    Default RE: Multiple Updates

    Just do two SQL statements:<BR><BR>SQL = "UPDATE Table1 SET something = SomethingElse"<BR>objConn.Execute SQL<BR><BR>SQL = "UPDATE Table2 SET somethingNew = SomethingElseNew"<BR>objConn.Execute SQL<BR><BR>That&#039s it! Do two SQL calls from one page... Hope this helps! Happy Programming!<BR>

Posting Permissions

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