Where are the field names validated in the Query Designer

rbuser

Where are the field names validated in the Query Designer?

I am trying to add functions to our data dictionary. These functions could
be a user defined function in the database or as simple as Upper(
fieldName ).

The query will run with the functions outside of the query designer. So I
actually just want to be able to override the query field name checking
procedure, possibly adding my own function name checking of the query.

Thanks.

Bill Brittain

nicocizik

Hi Bill,

Try setting the DataDictionary.ValidateTableNames and ValidateFieldNames
properties to False. This will remove the table and field validation
process from the DataDictionary and just rely on the entries inside the
dictionary.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

rbuser

Setting the ValidateTableNames and ValidateFieldNames to false does not
allow using only the data dictionary.

Still validates the field names on the actual table using

tdaMetaData.GetFieldLengthsFromDataSet

When I bypass this function, it allows the invalid tables ( in my case these
are functions in the database ) to be picked as fields.

I now am trying to track down why upon Query Designer completion, it is
trying to validate the table again.

Bill Brittain