SQL Search selected or zero results returned

[Luigi2021]

Hi,

I am generating a document from templates that contain fragments that make use of a custom query. If the fragment's custom query doesn't return any results I get the following error in the System Output window:  "SQL Search selected or zero results returned". I am not sure if it makes a difference for the answer but the fragment contains a hyperlink only. How can I solve this problem?

p.s. a workaround would be to let the SQL always return some kind of value. But since I think having zero results is not an error condition (maybe a warning/hint would be more appropriate) I guess/hope that there are other options.

Thanks in Advance!

Luigi

[OpenIT Solutions]

Hi,

If the SQL for a fragement returns 0 rows, the detail of the framgment will not be included in the report. Is this what your expecting ?

Regards,

Jon.

[Luigi2021]

That is indeed what I expect.

[Luigi2021]

@OpenIT Solutions I think I misread you answer.

Do you mean that there shouldn't be an error in the case that the fragment returns 0 rows?

[Luigi2021]

I finally found the problem. My SQL looked like this:

Code: [Select]

SELECT *
FROM
(
SELECT #Concat t_object.ea_guid,t_object.Name# AS [BaseClassName.Hyperlink]
FROM t_connector  JOIN t_object  ON t_connector.End_Object_ID = t_object.Object_ID
WHERE
 t_connector.Start_Object_ID = #OBJECTID#
AND
 t_connector.Stereotype = 'TechDoc Trace'
UNION
SELECT #Concat t_object.ea_guid,t_object.Name# AS [BaseClassName.Hyperlink]
FROM t_connector  JOIN t_object  ON t_connector.Start_Object_ID = t_object.Object_ID
WHERE
 t_connector.End_Object_ID = #OBJECTID#
AND
 t_connector.Stereotype = 'TechDoc Trace'
) AS A
ORDER BY 1 ASC
Changing the * to [BaseClassName.Hyperlink] did the trick.