Skip to Content
0
Former Member
Mar 14, 2007 at 07:30 AM

Quick performance question

16 Views

What's faster: 1) Updating a UserTable by using the UserTable object

e.g.

oDb = oCompany.UserTables.Item(ItmBinLocL)
                        oDb.GetByKey(Code)
                        oDb.UserFields.Fields.Item("U_Commited").Value = CStr(C)
                        oDb.UserFields.Fields.Item("U_Availabl").Value = CStr(A)
                        oDb.Update

OR

2)Using a RecordSet.DoQuery to update the UserTable?