Help with UPDATE in Access ...

Results 1 to 2 of 2

Thread: Help with UPDATE in Access ...

  1. #1
    Join Date
    Dec 1969

    Default Help with UPDATE in Access ...

    When trying to update info in a field where ItemID = "number from form", My ASP page simply places the updated info into a NEW field with the next available ItemID.<BR><BR>ItemID is my primary key and therefore allows no duplicates. However, I thought the update command would overwrite the changed information while leaving the ItemID alone.<BR><BR>Any help would be greatly appreciated,<BR>JC

  2. #2
    Join Date
    Dec 1969

    Default UPDATE in *any* kind of SQL

    Show your code.<BR><BR>What are you doing?<BR><BR>Your SQL should look something like:<BR><BR>SQL = "UPDATE tablename SET (fieldname=newvalue) WHERE ItemID = " & numFromForm<BR><BR>You can, of course, set several new field values in a single statement. I can&#039t remember off the top of my head whether the parens around the fieldname/value combos are needed. <BR><BR><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