DADE -> Unable to link a query object to another query object where the SQL was edited manually...

rbuser

Hi,
in the Data tab (DADE) of the report designer, when I modify manually a
query (Edit SQL), I can't link it to another query object anymore... It
works fine when the object is built via the query wizard/designer but as
soon as we modify it manually, we can't link it to another query object.
After manually editing a query, lots of options become disabled including
the link option... Is there a workaround?

Thanks in advance.
Yann St-Germain

digitalmetaphors

This is the intended behavior. DADE isn't able to validate the SQL that is
manually entered. The workaround is to use the query designer to configure
your query, and not to manually edit the SQL:)


Cheers,

Jim Bennett
Digital Metaphors

rbuser

Ok, that's what I thought too... thanks for the info...

The thing is that I wanted to use a select in a select:
select bla bla bla where id in (select distinct id from bla bla bla)

Anyway... I found a workaround by using the AutoSearchCriteria instead.

Once again, thanks for the feedback.
Yann

digitalmetaphors

Yes, if the SQL is valid, you can enter a subselect to get the search
criteria for a field in the dataview.


Cheers,

Jim Bennett
Digital Metaphors