|
|
Posted by Ben on 11/20/07 15:24
On 20 Nov, 14:34, Ben <bor...@gmail.com> wrote:
> 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- Hide quoted text -
>
> - Show quoted text -
Hey!
nevermind, my stupid brain thought of another idea, appologies for the
post it seems really stupid now >.< why didint i think of count....
Sigh
Thanks for your help anyway! :D
Regards
Ben
Navigation:
[Reply to this message]
|