right ryan,
it is returning duplicate record for last record..so what should i do?
thks
--- In firebird-support@yahoogroups.com, "Ryan Thomas" <ryan@t...>
wrote:

>
> > Forget IBExpert / CR,
> >
> > Why do you have two suspends?
> > Every time you call suspend a record will be returned in a

selectable

> > stored procedure.
>
> But looking at the SP it should only return the last record twice,

the first

> suspend is part of the for select, the second is not.
>
> -Ryan
>
> > Adam
>
> >
> > >
> > > adam,
> > > when i run it in IBexpert it shows me correct result but when i

am

> > > displaying in crystal report it shows duplicate values
> > > thks
> > >
> >
> >
> >
> >
> >
> > ------------------------ Yahoo! Groups Sponsor
> > --------------------~-->
> > Fair play? Video games influencing politics. Click and talk back!
> > http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/67folB/TM
> > --------------------------------------------------------------
> > ------~->
> >
> > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> >
> > Visit http://firebird.sourceforge.net and click the Resources item
> > on the main (top) menu. Try Knowledgebase and FAQ links !
> >
> > Also search the knowledgebases at http://www.ibphoenix.com
> >
> > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> >
> > Yahoo! Groups Links
> >
> >
> >
> >
> >
> >
> >
>