What would the query construction be in SQLite to update multiple fields? I have tried all sort of syntaxes, but sofar no success yet. I now have to do it in a loop, but that is a bit slow:
For i = 2 To lMaxEntryCount For c = 1 To UBound(arrFields) strUPDATE = arrFields2(c) & "_E" & i strSQL = "UPDATE " & strNewTable & " SET " & _ strUPDATE & " = (SELECT " & arrFields(c) & _ " FROM GROUP_" & i & " T WHERE PATIENT_ID = T.PID)" RunSQLiteActionQuery2 strDB, strSQL, False, True, False, True, , True Next Next Thanks for any advice. RBS ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------