I have been researching and experimenting on a recurring problem, RUNTIME ERROR: 94 Invalid Use of Null. The error mostly occurs when opening an existing MATRIX item. The matrix components are not effected and can be opened as usual.
In my research, I found a response to the same question I asked the community forum back in 2013. It replied that this problem was originally reported in QUICKSELL 2000.
QS2000 was the Sales Management System application that Quicksell Commerce and RMS was evolved from.
The answer suggested the following 3 queries.
SELECT * FROM (Item, ItemClass, and ItemClassComponent).
Run each query and look for NULL values and if found, run another query
UPDATE (Item),(ItemClass),(ItemClassComponent) SET <column name> = 0 WHERE ID = <id>
This did not solve my issue but may help others.
If any other suggestions are out there, please let me know.
