AddNew/Update and multiple tables

Results 1 to 2 of 2

Thread: AddNew/Update and multiple tables

  1. #1
    Join Date
    Dec 1969

    Default AddNew/Update and multiple tables

    Is it possible to add new records (or update) where the recordset is based on more than one table?<BR><BR>In Access you can sometimes do this and sometimes not - dependng whether it can identify the table to be updated. Is it the same in ASP?<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: AddNew/Update and multiple tables

    For inserts/updates, you&#039re better off to use...<BR><BR>INSERT INTO MYTABLE (FIELD1, FIELD2, FIELD3) VALUES (VAL1, VAL2, VAL3)<BR>&#039remember to use apostrophes if they are non-numeric fields<BR>&#039and dates except in Access where dates are framed with #s<BR><BR>UPDATE MYTABLE SET FIELD1 = VAL1 WHERE FIELD2 = SOMECRITERION<BR>&#039again, remember the apostrophes or #s

Posting Permissions

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