Posted by Jason Lepack on 11/20/07 13:33

What language is your "Program" in? Check the recordcount on the
dataset returned and go from there, don't return the dummy record.

Cheers,
Jason Lepack


On Nov 20, 5:57 am, Ben <bor...@gmail.com> wrote:
> Hello,
>
> im having a problem integrating an SQL statement with my program,
> it works fine when theres a result but throws an error when there is
> no result,
> is there anyway in SQL to make up a row if there isnt one that matches
> the query for example in this i could put indicator values in the
> returned fields then a simple check to see if its a proper field of my
> indicator field
>
> I know ISNULL works with single values but that only works if there is
> a row returned
>
> Does anyone know of any SQL syntax for MS SQL that when no row is
> returned it makes on up and parses it back
>
> Thank you in advance for your help!!
>
> Ben

[Back to original message]