Dynamic composite datawindows

dvaz...@banxico.org.mx

unread,

Dec 21, 2000, 5:47:50 PM12/21/00

to

Hi,

Does anyone know how to create a composite datawindow dynamically?

I have the syntax for the composite datawindow and the nested reports,
which I create separately, but I don´t know how to relate the nested
reports to the composite datawindow.

Any suggestions will be welcome.

Many thanks,

David Vazquez

Vladimir Gendler

unread,

Dec 21, 2000, 8:46:20 PM12/21/00

to

Take a look at n_cst_dwsrv_report - Custom Class
user object and in particular at its function
of_CreateComposite().
If you are using PFC you can use it otherwise
you can "steal" its code - source is available.

Regards, Vladimir.

David Vázquez >

unread,

Dec 27, 2000, 8:40:33 PM12/27/00

to

I checked the function of_CreateComposite()of the object
n_cst_dwsrv_report, but it creates a composite datawindow using an array of
existing datawindows.

However, both the composite datawindow and the datawindows I want to
include in it are created dynamically.

Any suggestions?

Thanks in advance,

David Vázquez
e-mail: dvaz...@banxico.org.mx

Philip Salgannik

unread,

Dec 27, 2000, 8:55:32 PM12/27/00

to

Read the advice that was already posted in this thread - search www.deja.com

pbm_thisusuallydoesnothelp:-))
Philip Salgannik

"David Vázquez >" <dvaz...@banxico.org.mx> wrote in message
news:E04D4AAB2CDF437D000934C3852569C3.0008392A852569C3@webforums...

Vladimir Gendler

unread,

Dec 27, 2000, 8:59:44 PM12/27/00

to

So, it solves your problem.
Instead of supplying DW as a parameter to this
function go in the body of this function,
create a DW there and use it where a parameter
is used. Of course, if you do not need many
DW (this is why an array parameter) eliminate
or loops pertaining to this array parameter.

David Vazquez

unread,

Dec 28, 2000, 12:44:10 PM12/28/00

to

Actually, that was the solution I was trying when I wrote the previous
message but I had some problems creating the columns. Although I used the
syntax from the exported datawindow and adde the string "create " at the
beginning, I think I need to check the syntax using the tools in PB.

By the way, is it possible that the following syntax:

table(column=(type=char(10) updatewhereclause=yes name=prueba
dbname="prueba" )

can become something like this using Modify()?

table(
column=(type=long update=yes updatewhereclause=yes key=yes name=boveda
dbname="boveda.boveda" )
column=(type=char(70) update=yes updatewhereclause=yes name=nombre_completo
dbname="boveda.nombre_completo" )
retrieve="PBSELECT(TABLE(NAME=~"boveda~")
COLUMN(NAME=~"boveda.boveda~")COLUMN(NAME=~"boveda.nombre_completo~"))"
update="boveda"
updatewhere=1
updatekeyinplace=no
)

This is because the solution given at deja.com suggests the rows be copied
from the dynamic dw, but I was wondering if I can do the retrieve to the
composite.

Many thanks,

David Vázquez

"Philip Salgannik" <phi...@rcn.com>
on 12/27/2000 at 08:55 PM powersoft.public.powerbuilder.datawindow Re:
Dynamic composite datawindows

Re: Dynamic composite datawindows

David Vázquez

unread,

Dec 28, 2000, 12:24:07 PM12/28/00

to

The question is:

How do I associate a report object (from the composite dw) with the
datawindow that was created dynamically, which has no dataobject?

I'm sorry if I'm being so insistent.

Regards,

David Vázquez

Vladimir Gendler <vgen...@socal.rr.com>
on 12/27/2000 at 08:59 PM powersoft.public.powerbuilder.datawindow Re:
Dynamic composite datawindows

Re: Dynamic composite datawindows

So, it solves your problem. Instead of supplying DW as a parameter to this