Welcome to the SQLitening support forums!
Started by Gary Stout, January 04, 2013, 01:39:56 pm
'Update all contributions with head of house name changeslSel "Select * FROM Contributions WHERE FamilyID = '" & Trim$(CurrentFamilyID$) & "'", %rs1Do While slGetRow(%rs1) slExe "Begin Immediate" SQL$ = "UPDATE Contributions SET Last = '" & Trim$(NewLast$) & "', First = '" & Trim$(NewFirst$) & "' WHERE FamilyID = '" & Trim$(CurrentFamilyID$) & "'" slExe Sql$ slExe "End"Loop
Quote from: Bern Ertl on January 04, 2013, 02:34:34 pmI don't understand why you are using a select statement and a loop.
Quote You should be able to execute the UPDATE statement as written one time and it will update all records where the FamilyID index = CurrentFamilyID