Database update

Results 1 to 3 of 3

Thread: Database update

  1. #1
    Glance Guest

    Default Database update

    I need to find a way other than a loop to update the same field in different rows at one time. The loop takes too lond. Thanks.

  2. #2
    Join Date
    Dec 1969

    Default RE: Database update

    Try<BR><BR>UPDATE tablename SET field = value WHERE field = value<BR><BR>I&#039m not sure if that&#039s what you&#039re getting at, though, but I hope it helps.<BR><BR>Ben

  3. #3
    Join Date
    Dec 1969

    Default RE: Database update

    you should be able to just do<BR>UPDATE tblContact SET tblContact.memNotes = "zoinks";<BR>and this would set every entry under the field memNotes to "zoinks".<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