Car Lovers’ Rule #1: If you want to enjoy a motor show, do not take a wife and a kid! Go alone! I had to work on Saturday, and after 5 o’clock it was Â£5/person, anyway 🙂 Close to the entrance, on the right hand side, there were Vauxhall cars, almost all white! Interesting theme, … Read moreBritish International Motor Show 2008
SET [VAL] = [QTY] * ABS(MR.VAL / MR.QTY)
FROM [MOVEMENT] MR
WHERE --SOME CRITERIA
[REF] = MR.AREF
AND [VAL] = 0
It does NOT complain and it seems all right, and runs without a problem, but since I selected the records with INNER JOIN and know that there are records that must be updated, we must find another way of updating those records. The problem is our table is referring to itself and … Read moreDeceiving MS SQL Server: UPDATE Command
Reading records from the database and instead of using DLookup or querying the database all the time, to improve performance we can read them into a VBA collection object and refer to it in memory. Especially, if the data in particular tables are not changing at all or changing very rarely, we can use this facility and hold the data in memory while the application is running. Beware of the number of records in your table and the amount of memory it may consume.