PDA

View Full Version : dbExplorer Filters active state



phvwijk
1-May-2017, 09:23 AM
Hi,

Select a table and goto the ddo's/Filters tab
Add a new filter.
Click on the Active filter. Makes sense why adding a filter which is not active at first.

You will get the following error:

e:\df\vdf19\bin\dbexplor.exe
Cannot find field Attempt to map fieldname: Table = Days_Trip (20), Source = MSSQLDRV.Field_Map

Error: 4100

MSG_ERROR_REPORT (433) - oErrorDialog (91) - at address 67317
MSG_CONSTRAIN (346) - oDays_Trip_DD (2050) - at address 86468
MSG_REBUILD_CONSTRAINTS (345) - oDays_Trip_DD (2050) - in native code
MSG_REBUILDALLCONSTRAINTS (1774) - oDays_Trip_DD (2050) - in native code
MSG_ONSELECTEDROWDATACHANGED (8214) - oActiveColumn (1653) - at address 95608
MSG_NOTIFYSELECTEDROWCHANGED (7935) - oObject (1660) - at address 38767
MSG_UPDATEDATAFORSELECTEDROW (7970) - oObject (1623) - at address 39032
MSG_UPDATEDATASOURCEFORSELECTEDROW (8213) - oActiveColumn (1653) - at address 40777
MSG_UPDATECURRENTVALUE (8189) - oActiveColumn (1653) - at address 40357
GET_NOTIFYITEMCHECKED (8195) - oActiveColumn (1653) - at address 40430
MSG_NOTIFYITEMCHECKED (9894) - oFiltersGrid (1595) - at address 60996
MSG_ONCOMITEMCHECK (7698) - oFiltersGrid (1595) - at address 59670
[start] - at address 101455


Peter

Vincent Oorsprong
5-May-2017, 03:19 AM
Peter,

When adding a new filter a new grid line is added and you have to pick the column to filter on, the mode and the value. So not making a new filter (via 'Add Filter') active makes sense.

Now to the reported error. The grid line contains two checkboxes. The checkbox "Active" is to make the filter active or not and the checkbox "Filter Column" tells the system to interprete the value as a column name. If you tick the 2nd checkbox and the value is not an existing column name you get the reported error.

I will enhance the situation a bit in the way that it should not attempt to find a column if the value is an empty string. I doubt if the system should do more like testing on allowed column name characters, for now will skip that.