Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

How do I draw connectors between two datasets that represents data in a third linking table

6 posts in DataWindow Last posting was on 2009-08-06 09:12:18.0Z
Roger Bertilsson Posted on 2009-06-15 12:25:13.0Z
Reply-To: "Roger Bertilsson" <roger.bertilsson@eniro.com>
From: "Roger Bertilsson" <roger.bertilsson@eniro.com>
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: How do I draw connectors between two datasets that represents data in a third linking table
Lines: 26
Organization: Eniro Sverige AB
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4a363da9@forums-1-dub>
Date: 15 Jun 2009 05:25:13 -0700
X-Trace: forums-1-dub 1245068713 10.22.241.152 (15 Jun 2009 05:25:13 -0700)
X-Original-Trace: 15 Jun 2009 05:25:13 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89479
Article PK: 418670

We're using PB11.5 and we have an application working against a sql anywhere
11.0 database.

In this database we have 2 base tables tables and a third linking table that
holds a one to may relationship between the two base tables.
I would like to make a gui that to the users in a understandable way, shows
how data in basetable1 is coupled against data in basetable2.
I would like to present this with 2 separate datasets for the 2 basetables
and with connectors between these datasets that shows how each single row in
basetable2 are linked against
one or many rows in basetable2.
With "Connector" I mean lines between 1 row in dataset1 and 1 row in
dataset2. Because there is a one to many relationship there can be two lines
from row 1
in dataset1 but then pointing to separate rows in dataset 2.

Does Powerbuilder has some kind of datawindow or other type of objects that
supports that rows in a linking table are presented as connectors between 2
other data sets.

If Powerbuilder has not, do someone know of any third part product that can
meet our needs.

Thanks /Roger


"Paul Horan[Sybase]" <phoran_remove Posted on 2009-06-15 12:59:08.0Z
From: "Paul Horan[Sybase]" <phoran_remove@remove_sybase.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <4a363da9@forums-1-dub>
Subject: Re: How do I draw connectors between two datasets that represents data in a third linking table
Lines: 40
Organization: Sybase
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4a36459c$1@forums-1-dub>
Date: 15 Jun 2009 05:59:08 -0700
X-Trace: forums-1-dub 1245070748 10.22.241.152 (15 Jun 2009 05:59:08 -0700)
X-Original-Trace: 15 Jun 2009 05:59:08 -0700, vip152.sybase.com
X-Authenticated-User: teamsybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89481
Article PK: 418671

There aren't any "base" components in PB that allow for connectors as you
describe them, but it's not hard to develop that yourself in PB.

Take a look at DW-Extreme: http://www.dw-extreme.com/
Their Graphical Network Editor may be an example you can draw from (or even
use directly).

--
Paul Horan[Sybase]
http://blogs.sybase.com/phoran/

"Roger Bertilsson" <roger.bertilsson@eniro.com> wrote in message
news:4a363da9@forums-1-dub...
> We're using PB11.5 and we have an application working against a sql
> anywhere 11.0 database.
>
> In this database we have 2 base tables tables and a third linking table
> that holds a one to may relationship between the two base tables.
> I would like to make a gui that to the users in a understandable way,
> shows how data in basetable1 is coupled against data in basetable2.
> I would like to present this with 2 separate datasets for the 2 basetables
> and with connectors between these datasets that shows how each single row
> in basetable2 are linked against
> one or many rows in basetable2.
> With "Connector" I mean lines between 1 row in dataset1 and 1 row in
> dataset2. Because there is a one to many relationship there can be two
> lines from row 1
> in dataset1 but then pointing to separate rows in dataset 2.
>
> Does Powerbuilder has some kind of datawindow or other type of objects
> that supports that rows in a linking table are presented as connectors
> between 2 other data sets.
>
> If Powerbuilder has not, do someone know of any third part product that
> can meet our needs.
>
> Thanks /Roger
>


Roger Bertilsson Posted on 2009-06-15 13:38:03.0Z
Reply-To: "Roger Bertilsson" <roger.bertilsson@eniro.com>
From: "Roger Bertilsson" <roger.bertilsson@eniro.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <4a363da9@forums-1-dub> <4a36459c$1@forums-1-dub>
Subject: Re: How do I draw connectors between two datasets that represents data in a third linking table
Lines: 57
Organization: Eniro Sverige AB
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4a364ebb@forums-1-dub>
Date: 15 Jun 2009 06:38:03 -0700
X-Trace: forums-1-dub 1245073083 10.22.241.152 (15 Jun 2009 06:38:03 -0700)
X-Original-Trace: 15 Jun 2009 06:38:03 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89482
Article PK: 418673

Thanks for quick answer.

You said that it's not so hard to develop that myself in PB. Are there any
demos available on how to do this? Or at least can you tell me how to draw a
line between one row in dataset 1 and another row in dataset 2. I assume
that the two datasets must be 2 separate datawindow objects then.

I also have looked at dwextreme but I cant find any demoapplications
presenting the PB code here either. I cant find so much about pricing of the
product either.

Thanks /Roger

"Paul Horan[Sybase]" <phoran_remove@remove_sybase.com> wrote in message
news:4a36459c$1@forums-1-dub...
> There aren't any "base" components in PB that allow for connectors as you
> describe them, but it's not hard to develop that yourself in PB.
>
> Take a look at DW-Extreme: http://www.dw-extreme.com/
> Their Graphical Network Editor may be an example you can draw from (or
> even use directly).
>
> --
> Paul Horan[Sybase]
> http://blogs.sybase.com/phoran/
>
> "Roger Bertilsson" <roger.bertilsson@eniro.com> wrote in message
> news:4a363da9@forums-1-dub...
>> We're using PB11.5 and we have an application working against a sql
>> anywhere 11.0 database.
>>
>> In this database we have 2 base tables tables and a third linking table
>> that holds a one to may relationship between the two base tables.
>> I would like to make a gui that to the users in a understandable way,
>> shows how data in basetable1 is coupled against data in basetable2.
>> I would like to present this with 2 separate datasets for the 2
>> basetables and with connectors between these datasets that shows how each
>> single row in basetable2 are linked against
>> one or many rows in basetable2.
>> With "Connector" I mean lines between 1 row in dataset1 and 1 row in
>> dataset2. Because there is a one to many relationship there can be two
>> lines from row 1
>> in dataset1 but then pointing to separate rows in dataset 2.
>>
>> Does Powerbuilder has some kind of datawindow or other type of objects
>> that supports that rows in a linking table are presented as connectors
>> between 2 other data sets.
>>
>> If Powerbuilder has not, do someone know of any third part product that
>> can meet our needs.
>>
>> Thanks /Roger
>>
>
>


Philip Salgannik Posted on 2009-06-15 15:50:21.0Z
From: "Philip Salgannik" <philip@MeMyselfAndI.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <4a363da9@forums-1-dub> <4a36459c$1@forums-1-dub> <4a364ebb@forums-1-dub>
Subject: Re: How do I draw connectors between two datasets that represents data in a third linking table
Lines: 4783
Organization: MeMyselfAndI
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4a366dbd@forums-1-dub>
Date: 15 Jun 2009 08:50:21 -0700
X-Trace: forums-1-dub 1245081021 10.22.241.152 (15 Jun 2009 08:50:21 -0700)
X-Original-Trace: 15 Jun 2009 08:50:21 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89484
Article PK: 418675

Take a look at attached. Was developed by Avron Polyakov +-12 years ago (in
PB6 I think). This is migrated to PB8, still works pretty well :-)

"Roger Bertilsson" <roger.bertilsson@eniro.com> wrote in message
news:4a364ebb@forums-1-dub...
> Thanks for quick answer.
>
> You said that it's not so hard to develop that myself in PB. Are there any
> demos available on how to do this? Or at least can you tell me how to draw
> a
> line between one row in dataset 1 and another row in dataset 2. I assume
> that the two datasets must be 2 separate datawindow objects then.
>
> I also have looked at dwextreme but I cant find any demoapplications
> presenting the PB code here either. I cant find so much about pricing of
> the
> product either.
>
> Thanks /Roger
>
> "Paul Horan[Sybase]" <phoran_remove@remove_sybase.com> wrote in message
> news:4a36459c$1@forums-1-dub...
>> There aren't any "base" components in PB that allow for connectors as you
>> describe them, but it's not hard to develop that yourself in PB.
>>
>> Take a look at DW-Extreme: http://www.dw-extreme.com/
>> Their Graphical Network Editor may be an example you can draw from (or
>> even use directly).
>>
>> --
>> Paul Horan[Sybase]
>> http://blogs.sybase.com/phoran/
>>
>> "Roger Bertilsson" <roger.bertilsson@eniro.com> wrote in message
>> news:4a363da9@forums-1-dub...
>>> We're using PB11.5 and we have an application working against a sql
>>> anywhere 11.0 database.
>>>
>>> In this database we have 2 base tables tables and a third linking table
>>> that holds a one to may relationship between the two base tables.
>>> I would like to make a gui that to the users in a understandable way,
>>> shows how data in basetable1 is coupled against data in basetable2.
>>> I would like to present this with 2 separate datasets for the 2
>>> basetables and with connectors between these datasets that shows how
>>> each
>>> single row in basetable2 are linked against
>>> one or many rows in basetable2.
>>> With "Connector" I mean lines between 1 row in dataset1 and 1 row in
>>> dataset2. Because there is a one to many relationship there can be two
>>> lines from row 1
>>> in dataset1 but then pointing to separate rows in dataset 2.
>>>
>>> Does Powerbuilder has some kind of datawindow or other type of objects
>>> that supports that rows in a linking table are presented as connectors
>>> between 2 other data sets.
>>>
>>> If Powerbuilder has not, do someone know of any third part product that
>>> can meet our needs.
>>>
>>> Thanks /Roger
>>>
>>
>>
>
>
>


Philip Salgannik Posted on 2009-06-15 15:54:29.0Z
From: "Philip Salgannik" <philip@MeMyselfAndI.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <4a363da9@forums-1-dub> <4a36459c$1@forums-1-dub> <4a364ebb@forums-1-dub> <4a366dbd@forums-1-dub>
Subject: Re: How do I draw connectors between two datasets that represents data in a third linking table
Lines: 537
Organization: MeMyselfAndI
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4a366eb5@forums-1-dub>
Date: 15 Jun 2009 08:54:29 -0700
X-Trace: forums-1-dub 1245081269 10.22.241.152 (15 Jun 2009 08:54:29 -0700)
X-Original-Trace: 15 Jun 2009 08:54:29 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89485
Article PK: 418676

...and here are resources it uses

"Philip Salgannik" <philip@MeMyselfAndI.com> wrote in message
news:4a366dbd@forums-1-dub...
> Take a look at attached. Was developed by Avron Polyakov +-12 years ago
> (in
> PB6 I think). This is migrated to PB8, still works pretty well :-)
> "Roger Bertilsson" <roger.bertilsson@eniro.com> wrote in message
> news:4a364ebb@forums-1-dub...
>> Thanks for quick answer.
>>
>> You said that it's not so hard to develop that myself in PB. Are there
>> any
>> demos available on how to do this? Or at least can you tell me how to
>> draw
>> a
>> line between one row in dataset 1 and another row in dataset 2. I assume
>> that the two datasets must be 2 separate datawindow objects then.
>>
>> I also have looked at dwextreme but I cant find any demoapplications
>> presenting the PB code here either. I cant find so much about pricing of
>> the
>> product either.
>>
>> Thanks /Roger
>>
>> "Paul Horan[Sybase]" <phoran_remove@remove_sybase.com> wrote in message
>> news:4a36459c$1@forums-1-dub...
>>> There aren't any "base" components in PB that allow for connectors as
>>> you
>>> describe them, but it's not hard to develop that yourself in PB.
>>>
>>> Take a look at DW-Extreme: http://www.dw-extreme.com/
>>> Their Graphical Network Editor may be an example you can draw from (or
>>> even use directly).
>>>
>>> --
>>> Paul Horan[Sybase]
>>> http://blogs.sybase.com/phoran/
>>>
>>> "Roger Bertilsson" <roger.bertilsson@eniro.com> wrote in message
>>> news:4a363da9@forums-1-dub...
>>>> We're using PB11.5 and we have an application working against a sql
>>>> anywhere 11.0 database.
>>>>
>>>> In this database we have 2 base tables tables and a third linking table
>>>> that holds a one to may relationship between the two base tables.
>>>> I would like to make a gui that to the users in a understandable way,
>>>> shows how data in basetable1 is coupled against data in basetable2.
>>>> I would like to present this with 2 separate datasets for the 2
>>>> basetables and with connectors between these datasets that shows how
>>>> each
>>>> single row in basetable2 are linked against
>>>> one or many rows in basetable2.
>>>> With "Connector" I mean lines between 1 row in dataset1 and 1 row in
>>>> dataset2. Because there is a one to many relationship there can be two
>>>> lines from row 1
>>>> in dataset1 but then pointing to separate rows in dataset 2.
>>>>
>>>> Does Powerbuilder has some kind of datawindow or other type of objects
>>>> that supports that rows in a linking table are presented as connectors
>>>> between 2 other data sets.
>>>>
>>>> If Powerbuilder has not, do someone know of any third part product that
>>>> can meet our needs.
>>>>
>>>> Thanks /Roger
>>>>
>>>
>>>
>>
>>
>>
>
>
>


ChrissDeGrece Posted on 2009-08-06 09:12:18.0Z
From: ChrissDeGrece <chriss_degrece_NOSPAM_@yahoo.com>
User-Agent: Thunderbird 2.0.0.22 (Windows/20090605)
MIME-Version: 1.0
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: How do I draw connectors between two datasets that represents data in a third linking table
References: <4a363da9@forums-1-dub> <4a36459c$1@forums-1-dub> <4a364ebb@forums-1-dub> <4a366dbd@forums-1-dub>
In-Reply-To: <4a366dbd@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4a7a9e72$3@forums-3-dub.sybase.com>
Date: 6 Aug 2009 02:12:18 -0700
X-Trace: forums-3-dub.sybase.com 1249549938 10.22.241.152 (6 Aug 2009 02:12:18 -0700)
X-Original-Trace: 6 Aug 2009 02:12:18 -0700, vip152.sybase.com
Lines: 71
Path: forums-1-dub!forums-master!forums-3-dub.sybase.com!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89744
Article PK: 418932

Thanks a lot for the example, I was looking for a way to create the
"rectangular line" connector too. I hope your example will help.

Thanks again

Philip Salgannik wrote:
> Take a look at attached. Was developed by Avron Polyakov +-12 years ago (in
> PB6 I think). This is migrated to PB8, still works pretty well :-)
> "Roger Bertilsson" <roger.bertilsson@eniro.com> wrote in message
> news:4a364ebb@forums-1-dub...
>> Thanks for quick answer.
>>
>> You said that it's not so hard to develop that myself in PB. Are there any
>> demos available on how to do this? Or at least can you tell me how to draw
>> a
>> line between one row in dataset 1 and another row in dataset 2. I assume
>> that the two datasets must be 2 separate datawindow objects then.
>>
>> I also have looked at dwextreme but I cant find any demoapplications
>> presenting the PB code here either. I cant find so much about pricing of
>> the
>> product either.
>>
>> Thanks /Roger
>>
>> "Paul Horan[Sybase]" <phoran_remove@remove_sybase.com> wrote in message
>> news:4a36459c$1@forums-1-dub...
>>> There aren't any "base" components in PB that allow for connectors as you
>>> describe them, but it's not hard to develop that yourself in PB.
>>>
>>> Take a look at DW-Extreme: http://www.dw-extreme.com/
>>> Their Graphical Network Editor may be an example you can draw from (or
>>> even use directly).
>>>
>>> --
>>> Paul Horan[Sybase]
>>> http://blogs.sybase.com/phoran/
>>>
>>> "Roger Bertilsson" <roger.bertilsson@eniro.com> wrote in message
>>> news:4a363da9@forums-1-dub...
>>>> We're using PB11.5 and we have an application working against a sql
>>>> anywhere 11.0 database.
>>>>
>>>> In this database we have 2 base tables tables and a third linking table
>>>> that holds a one to may relationship between the two base tables.
>>>> I would like to make a gui that to the users in a understandable way,
>>>> shows how data in basetable1 is coupled against data in basetable2.
>>>> I would like to present this with 2 separate datasets for the 2
>>>> basetables and with connectors between these datasets that shows how
>>>> each
>>>> single row in basetable2 are linked against
>>>> one or many rows in basetable2.
>>>> With "Connector" I mean lines between 1 row in dataset1 and 1 row in
>>>> dataset2. Because there is a one to many relationship there can be two
>>>> lines from row 1
>>>> in dataset1 but then pointing to separate rows in dataset 2.
>>>>
>>>> Does Powerbuilder has some kind of datawindow or other type of objects
>>>> that supports that rows in a linking table are presented as connectors
>>>> between 2 other data sets.
>>>>
>>>> If Powerbuilder has not, do someone know of any third part product that
>>>> can meet our needs.
>>>>
>>>> Thanks /Roger
>>>>
>>>
>>
>>
>
>