Why tOracleRow filter the rows?

[Anonymous]

Hello,
I want to make an sql to a table in order to look up for a date if exist, and if does not exist, show a null but i dont want to filter the row if the query doesn't gives a result
My sql is
select 'YES' as RESULT from table where fieldA > '50'
Thanks

[Anonymous]

I would select the amount of datasets.

select count(1) as count_ds from table where fieldA > '50'

This query returns always as value and you can filter for 0 or greater 0.

[Anonymous]

the component tOracleRow does not filter at all. I guess you are working with the component tParseRecordset? This component returns as much output rows as the result set of the query have rows.

[Anonymous]

Hi,
We usually use t<DB>Input to execute a select query, you have to use a tParseRecordSet after t<DB>Row to parse the record set if you use t<DB>Row to execute a select query.
Best regards
Sabrina