I am fairly new to paramquery pro, but I have a working solution.
Here is the situation: I have an existing internal system utilising a number of components on an existing database.
There are a number of reports and other information interfaces, all working nicely but needing a facelift. Which is where paramquery comes in.
A lot of the data interfaces use filters. Got my operator grid working nicely, looking all pretty. But - the filters would not work for 5 fields.
On further examination, I realised that the five fields in question actually have numbers in them. (Addr1, Addr2, Addr3 etc).
As a controlled test, I changed the names of the tables to AddrOne, AddrTwo etc, and the filter started to work. Obviously because I have lots of reports and enquiry screens built on lots of sql statements, permanently renaming the fields to remove the numbers is not possible.
Why is this happening? Is there an easy solution, or is this a bug?
I am using a LAMP.
Thanks.
Rob
