Posted by Ben on 11/20/07 14:34

On 20 Nov, 13:33, Jason Lepack <jlep...@gmail.com> wrote:
> 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- Hide quoted text -
>
> - Show quoted text -

The Error Message is: exception : System.NullReferenceException:
Object reference not set to an instance of an object.

and its not really programming its a prebuilt assembly which has to be
used i can only alter the code around it, but this assembly throws an
error if there is nothing there so waht i need is, if there are no
values returned that it creats a dummy value, im not sure if you can
do that using a MS SQL statement

All that this assembly returns is either one record or nothing, pretty
useless i know :/ doesnt even return a recordset

Cheers

Ben

[Back to original message]