How to update several records at once by only one Update query

// - - Begin memo item - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - //

(Memo Item created on May 17, 2008 04:24 PM)

- - - Begin title or keyword:

How to update several records at once by only one Update query

- - - End title or keyword:

 

VirtualTable_ForSettingStockToZero_WJ

 

SELECT 產品資料_WJ.產品編號, 產品資料_WJ.產品, 產品資料_WJ.庫存量, 產品資料_WJ.不再銷售

FROM 產品資料_WJ

WHERE (((產品資料_WJ.不再銷售)=True));

 

Update_VirtualTable_ForSettingStockToZero_WJ

 

PARAMETERS NewStockQuantity Short;

UPDATE VirtualTable_ForSettingStockToZero_WJ SET VirtualTable_ForSettingStockToZero_WJ.庫存量 = [NewStockQuantity];

 

// - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - End memo item - - //