This has caused a huge upset with all our Form applications. It’s very simple to duplicate.
Take any table and generate a Form (no matter what for you select)
Then in the SQL Where place a where clause
Assuming you have a field called “agentID”
agentID=’[id]’
Then run the form.
Error: [TABLE=“border: 1”]
[TR]
[TD][SIZE=4]The following global variables are missing:[/SIZE] id;[/TD]
[/TR]
[/TABLE]
You can try initialize the global variable in any of the Events using agentID=[id]; and you still get the same error.
This is extremely disruptive and has caused a huge nightmare.
Why cant this be correct?