Not all code paths return a value

Question

I have the following method. 

      public static DebOop AddToDict(string rc, string memberNbr, string person, string group, string subGroup         , string plancode, iDB2DataReader dr

     {

         DebOop returnvalue = null;

         DebOop record = new DebOop();

         //Main data

         record.SubscriberNumber = dr.GetiDB2Char(0);

         record.PersonNumber = dr.GetiDB2Char(1);

         record.GroupID = dr.GetiDB2Char(2);

         record.Subgroup = dr.GetiDB2Char(3);

         record.Plancode = dr.GetiDB2Char(4);

  . . . . . skipped many records that do the same . . . . . . .

         record.FamDoaOutNetRM = dr.GetiDB2Decimal(85);

         record.returnCode = rc;

         //Finished record 

         returnvalue = record;         

      }

I get the following error:

Error 1 'DedOopData.DebOop.AddToDict(string, string, string, string, string, string, IBM.Data.DB2.iSeries.iDB2DataReader)': not all code paths return a value C:\DedOopData\DedOopData\DebOop.cs 125 28 DedOopData

There is only one path.  So why am I getting the error?  Is this the best way to pass back the Class record?

Thanks,

Arep

Answer 1

Hi Anoop,

 

Please try this SQL and let me know if it works for you

 

declare @storeid bigint
set @storeid=19
select  I.NameOfStores, I.ReferenceNo, SUM(Inwards.InwardQty) InwardQty,  SUM(ISNULL(Issued.IssuedQty,0)) IssuedQty, SUM((ISNULL(Inwards.InwardQty,0)-ISNULL(Issued.IssuedQty,0)))as Balance
from InventoryInwards as I
LEFT JOIN
        (select ReferenceNo,  nameofStores, ISNULL(Sum(ISNULL(Qty,0)),0) as InwardQty
        from InventoryInwards where StoreID=@storeid
        group By NameOfStores, ReferenceNo, Unit) as Inwards ON I.NameOfStores = Inwards.NameOfStores
        and i.ReferenceNo=Inwards.ReferenceNo

left JOIN
        (select   nameofStores, ISNULL(Sum(ISNULL(Qty,0)),0) as IssuedQty
        from InventoryIssued where StoreID=@storeid
        group By NameOfStores, ReferenceNo, unit) as Issued on I.NameOfStores= Issued.NameOfStores



where i.StoreID = @storeid
group by I.NameOfStores, I.ReferenceNo, I.Unit

Answer 2

Thanks Ankit... that was I missing out.