Update Query

Results 1 to 2 of 2

Thread: Update Query

  1. #1
    Join Date
    Dec 1969

    Default Update Query

    Hi,<BR><BR>How do I perform a batch "UPDATE" of a particular table and a column within that table e.g. I wish to perform a batch update of a column called "Prices" with a value I type in a textbox? The rows in that table have nothing is common hence I can&#039;t state e.g. UPDATE where PriceID = &#039;" & PriceID & "&#039;", etc. <BR><BR>Thanks!

  2. #2
    Join Date
    Dec 1969

    Default If you wish...

    to update all rows in the table don&#039;t include a WHERE clause, if you only want to update certain rows then you must specify which rows with a WHERE clause

Posting Permissions

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