|
|
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
Navigation:
[Reply to this message]
|