Calc fields in searches?

rbuser

If I create calculated fields, I notice they are not available for
queries. Is this WAD? If so, why?

Thanks,

John

digitalmetaphors

If you have a data pipeline connected to a TQuery, and you add calculated
fields to the query, you can get the data pipeline to refresh by setting
AutoCreateFields to False, then True (toggling it that is.) This should
allow you to see the fields in the Report Designer.

--
Tom Ollar
Digital Metaphors Corporation

rbuser

Tom,

Thanks...But, this is not exactly my situation-I think. The user creates a
datamodule with the query designer, adds all regular fields, creates
calculated fields, they can sort on the calc field, but cannot see it for
grouping and searching. Since the calc field is available for sorting, it is
assumed that AutoCreateFields is not the problem...Is the field string list
for grouping/searching different from the string list for sorting?

Thanks for any additional guidance you can provide.

John

digitalmetaphors

Neither is grouping nor searching on a calculated field is supported in the
visual Query Designer or Query Wizard. In order to create this type of SQL
you'll need to manually edit the SQL. You can do this by proceeding to the
last page of the Query Designer, right-clicking and accessing the Edit SQL
option. DataViews which have been manually edited cannot be visually edited
or linked...

--
Tom Ollar
Digital Metaphors Corporation

rbuser

Tom,

OK, thanks...at least I know its not supported.

John