Hi, Its not always required to open the cursor to get a single record.Its works fine most of the time,only it creates problem when fetching only id.
With Regards Selvakannan.S "Peter Cooper" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Selvakannan > > in embedded sql you need to declare and use a cursor > > &sql(declare c1 cursor for > select ID into :SID from BLUELOG.MonthActivity where (Month=:strMonth > and Insurance=:strInsurance and LevelId=:LID)) > > &sql(open c1) > &sql(fetch c1) > while SQLCODE=0 > { > write !,SID > &sql(fetch c1) > } > &sql(close c1) > > > > Peter > > On Fri, 21 May 2004 17:00:47 +0530, "Selvakannan. S" > <[EMAIL PROTECTED]> wrote: > > >Hi, > > > >In my database for BLUELOG.MonthActivity class there is only one record and > >the following query returns me the first record id where ever the > >condition i pass.Even if my condition not matchs then also it returns the > >first record id. > > > > set SID=0 > > &sql(select ID into :SID from BLUELOG.MonthActivity where (Month=:strMonth > >and Insurance=:strInsurance and LevelId=:LID)) > > > >Note: SID returns 1 Even if i change strInsurance or strMonth. > > > >is it Cache SQL bug? > > > >Pls correct me if i am worng. > > > > > >With Regards > >Selvakannan.S > > > > > > >
