nested datawindows and rowscopy()

[Steve Sensenig]

Hi, all. I have a composite dw with three nested reports. I successfully
getchild() on the main nested report (the one which will actually have the
"detail" of the report. I want to copy data from another datawindow into
this datawindowchild. The rowscopy() function returns 1, but rowcount() on
the nested report returns 0 (the rowcount() on the other datawindow is 6 and
all of this works when copying to a non-nested report). To top it all off,
when I display the nested report, it displays not 0, not 6, but ALL the rows
in the database, as if there had been no where clause on the SELECT
statement.

I even tried replacing the rowscopy() with a sharedata, which also returns 1
(successful), but has the exact same result of the nested report containing
all the rows in the database.

Any ideas??? This is PB6.5. Code sample below......

TIA,
Steve Sensenig
RFD and Associates, Inc.
Austin, TX
sens...@millenicom.com

--------code sample----------

dw_result.getchild('nested_report',ldwc_nested)
ldwc_nested.settransobject(SQLCA) // is this necessary??
ldwc_nested.rowsdiscard(1,ldwc_nested.rowcount(),primary!)
li_ret =
dw_template.rowscopy(1,dw_template.rowcount(),primary!,ldwc_nested,1,primary
!)
// li_ret = 1 on the above function

--------end code sample--------

[François Jamin]

HI,
We use the Dot Notation for the same functionality and it works fine.
Try this instead of the rowscopy() function.
François

Steve Sensenig <nospam_...@millenicom.com> wrote in article
<CZsfSPob$GA...@forums.sybase.com>...

[Steve Sensenig]

Me.Object.Thanks.Communicate()

thank you. the dot notation did work. However, I have a followup question.
It works if I'm setting a nested report's data to equal the data of a
non-nested report. However, if I try the same thing to set a nested
report's data equal to another nested report's data, I get an "error
accessing external object property data." Any thoughts?

sample:
dw_1.Object.nested_report.Object.data =
dw_2.Object.nested_report.Object.data

TIA,
steve

"François Jamin" <fja...@ctp.com> wrote in message
news:01bf6eed$e2cc2f40$516a...@chvev0276.nestec.ch...

[François Jamin]

Hi,

Perhaps your datawindow dw_2 is not a composite datawindow so can't access
to the nested datawindow (limitation of getchild () function ) or this
operation is not supported.

Try to use an array to get the data :

array=dw_1.Object.nested_report.Object.data
dw_2.Object.nested_report.Object.data = array

François

Steve Sensenig <nospam_...@millenicom.com> wrote in article

<0LeqSiZc$GA...@forums.sybase.com>...