On Dec 7, 2010, at 4:58 AM, kobi.biton wrote:
>
> hi thanks for the reply I did look at the CASE statement however cannot seem
> to alter the returned row-count ...
Well, yeah. The row count is the count of rows returned. If there are no rows matched by the query, then what exactly
doyou expect to happen? Set the row count to 1, so that the application then tries to access the 1st row of 0???
If you need some dummy row returned even in the case where there's no match, then you'll have to construct your query
thatway...
--
Scott Ribe
scott_ribe@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice