copying/transfering datawindow results to another datawindow

I have a window which display all the records in the datawindow and at
runtime, I have the option of filtering the data.  Once the data is
filtered/unfiltered, I would like all the results to open in a new window
generated in a specific report (datawindow).

  So, how can I copy all the data from the filtered results? and how do I
pass these filtered results to the report datawindow?


0
Mark
1/10/2001 3:43:42 AM
sybase.powerbuilder.datawindow 28057 articles. 5 followers. Follow

3 Replies
1978 Views

Similar Articles

[PageSpeed] 36
Get it on Google Play
Get it on Apple App Store

You can use one of the following

*    dw_source.RowsCopy(1, il_Rows, Filter!, dw_dest, 1, Filter!)

or

*  dw_dest.Object.Data = dw_source.Object.Data           (all date of all
buffers is copied)

This only works when the columns/sequence  of both  datawindows are
'compatible'(the same).
In other cases you can allways copie field by field (getItem from dw_source
and SetItem in dw_dest)



Mark <thegame_2000@hotmail.com> wrote in message
news:$M630mreAHA.216@forums.sybase.com...
> I have a window which display all the records in the datawindow and at
> runtime, I have the option of filtering the data.  Once the data is
> filtered/unfiltered, I would like all the results to open in a new window
> generated in a specific report (datawindow).
>
>   So, how can I copy all the data from the filtered results? and how do I
> pass these filtered results to the report datawindow?
>
>


0
Dimitri
1/10/2001 8:10:34 AM
Even if the results sets are different and you copy a field at a time, you
don't have to loop through the rows using Get/SetItem.  Something like:
dw_dest.object.column1.primary = dw_source.object.column2.primary
(etc)
will do the trick

S.

--
Simon Caldwell
Get Real Systems Ltd
Holtby Manor, Stamford Bridge Road, York, YO19 5LL
Tel 01904 481999 Fax 01904 481666
Visit us at www.getrealsystems.com

Specialists in e-Procurement and supply chain technology


"Dimitri Van der Veken" <dimitri@servico.be> wrote in message
news:wzHE#8teAHA.294@forums.sybase.com...
> You can use one of the following
>
> *    dw_source.RowsCopy(1, il_Rows, Filter!, dw_dest, 1, Filter!)
>
> or
>
> *  dw_dest.Object.Data = dw_source.Object.Data           (all date of all
> buffers is copied)
>
> This only works when the columns/sequence  of both  datawindows are
> 'compatible'(the same).
> In other cases you can allways copie field by field (getItem from
dw_source
> and SetItem in dw_dest)
>
>
>
> Mark <thegame_2000@hotmail.com> wrote in message
> news:$M630mreAHA.216@forums.sybase.com...
> > I have a window which display all the records in the datawindow and at
> > runtime, I have the option of filtering the data.  Once the data is
> > filtered/unfiltered, I would like all the results to open in a new
window
> > generated in a specific report (datawindow).
> >
> >   So, how can I copy all the data from the filtered results? and how do
I
> > pass these filtered results to the report datawindow?
> >
> >
>
>


0
Simon
1/10/2001 9:22:24 AM
Look up ShareData ()

Mark wrote in message <$M630mreAHA.216@forums.sybase.com>...
>I have a window which display all the records in the datawindow and at
>runtime, I have the option of filtering the data.  Once the data is
>filtered/unfiltered, I would like all the results to open in a new window
>generated in a specific report (datawindow).
>
>  So, how can I copy all the data from the filtered results? and how do I
>pass these filtered results to the report datawindow?
>
>


0
Jerry
1/10/2001 2:30:50 PM
Reply: