Entry

How can I update more than one record at a time? i.e record 1, 5, 9 Thanks

Sep 13th, 2002 12:29
Euan MacInnes, Stephen Haynes,

Option 1)
update table set field=value where record in (1,5,9)
Option 2)
update table set field=value where record=1 or record=5 or record=9
But Backup the table first, in case you are using a version that has 
bugs in the OR evaluation.