> right ryan,
> it is returning duplicate record for last record..so what should i do?
> thks

If you remove the second suspend it will only return values for each record
returned by the for-select query.

The second suspend will return the values that are in still in the
:USERFNAME, :USERLNAME, :RSALEDATE, :PERIOD, :NSALES variables from the last
iteration of the for-select.

Cheers,

-Ryan

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