If you have an MQE with 3 queries:
Query 1 checks for records that exist
Query 2 inserts new records
Query 3 selects new (and old) records for display
You MUST set expect=”no” on the first query. Otherwise LQM uses it in place of Query3.
I use a tool called LQM (Logos Query Manager).
Its not a bad tool but unfortunately there are many undocumented features. I’ve given up trying to convince the creator to do a better job of the documentation.
I’m going to start a wiki of all the undocumented stuff I’ve found. Unfortunately it will only help about ten people worldwide I think.
So the first fix:
- When using the MQE feature of LQM 3.02 you need to ensure cache is set to at least 1. See this forum post for more details:
LQM Fix for MQE inserts multiple records
