An object representing a SQL select query, which can be serialized into a SQL statement.

It is easier to deal with object-wrappers than string-parsing a raw SQL-query.

If you omit the WHERE clause, every row in the table is updated with the same value.

If you want to use an object property in an expression, you need to specify a memory variable and then use that variable in the expression.

You can include one subquery in the SET clause to specify an expression.

Microsoft is conducting an online survey to understand your opinion of the Msdn Web site.

is incorrect; that last statement is always going to be adding 0 since that's the value you just assigned to $total Units Ordered in the preceding statement.

For that section to make sense, I believe you'll want to reverse the order of those two statements.

If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.

UPDATE Target SET Column_Name1 = e Expression1 [, Column_Name2 = e Expression2 ...] [FROM [FORCE] Table_List_Item , ...] | [JOIN [ Table_List_Item] WHERE Filter Condition1 [AND | OR Filter Condition2 ...] Specifies the columns in the table to update and their new values.My original method was to nest a couple loops building an SQL statement like so: function updateflds() Dim i,k For k = 0 To UBound(ar Form Values) For i = 0 to UBound(ar Form DBFields) flds = flds ar Form DBFields(i) & " = '" _ & ar Form Values(k) & "', " Next Next flds = trim(flds) end function But this didn't work for obvious reasons (the first loop made the second loop execute more than supposed to) So - how would I do this? Is there a reason why one loop that does multiple executes a bad idea?Dim inc For inc = 0 to Ubound(ar DBFields) SQLUpdate = Update your Table Set col Form Fields = 'ar Form Fields(inc)' Where col DBFields = ar DBFields(inc) Conn.