QuestionQ270

Develop and test code

An organization has 1,000 vendors in a vendor group named Employee. A field named DlvTerm describes delivery terms for a vendor.

Set DlvTerm to Cash for all vendors in the vendor group, updating all vendor records in that group in one bulk operation.

Which two code segments can be used? Each correct answer is a complete solution.

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

Yes or No
StatementsYesNo
A
B
C
D
Explanation

update_recordset updates all rows that satisfy its where clause as one set-based database operation. Query::update_recordset likewise applies a mapped field value to the record set selected by the query. A record-by-record while select update does not satisfy the requirement to update the vendor group in a single bulk operation.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!