Home DADE

Where are the field names validated in the Query Designer

edited August 2007 in DADE
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

Comments

  • edited August 2007
    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

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited August 2007
    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



This discussion has been closed.