> 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
>
>
>
>
>
>
>