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.

Dynamic Dropdowns

10 posts in DataWindow Last posting was on 2009-12-21 00:29:27.0Z
SPD0060 Posted on 2009-12-19 20:24:29.0Z
From: SPD0060 <sdavis@archi-tech-ture.com>
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Dynamic Dropdowns
Date: Sat, 19 Dec 2009 12:24:29 -0800 (PST)
Organization: http://groups.google.com
Lines: 14
Message-ID: <926249b4-61b5-43ff-9ab5-ddd59b581a41@g7g2000yqa.googlegroups.com>
NNTP-Posting-Host: 64.53.242.64
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
X-Trace: posting.google.com 1261254270 20640 127.0.0.1 (19 Dec 2009 20:24:30 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Sat, 19 Dec 2009 20:24:30 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: g7g2000yqa.googlegroups.com; posting-host=64.53.242.64; posting-account=7tUaPAoAAACDDfZ3NgtZxqThSQtCiLrn
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0; Trident/4.0; GTB6.3; SLCC1; .NET CLR 2.0.50727; InfoPath.2; .NET CLR 3.5.21022; .NET CLR 3.5.30729; .NET CLR 3.0.30729; OfficeLiveConnector.1.4; OfficeLivePatch.1.3),gzip(gfe),gzip(gfe)
Path: forums-1-dub!forums-master!newssvr.sybase.com!news-sj-1.sprintlink.net!news-peer1.sprintlink.net!nntp1.phx1.gblx.net!nntp.gblx.net!nntp.gblx.net!border2.nntp.dca.giganews.com!nntp.giganews.com!nx01.iad01.newshosting.com!newshosting.com!198.186.190.251.MISMATCH!news-out.readnews.com!transit4.readnews.com!postnews.google.com!g7g2000yqa.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:90452
Article PK: 410068

In my app I have a table that contains all the data that will be used
in all of the various ddws. I have to create a specific dwo for each
dropdown field and have the where clause select from the table based
on the name of the column (hard coded in the where clause). So I end
up with dozens of these dwos. I assume I could drill down and replace
the where clause of each dwo during the retrieve of the master dw but
that seems like replacing one kind of tedious coding work with
another. Is there any way to have a ddw change the where clause based
upon the column it's on dynamically. I'm guessing 100% "no" but I
thought I should ask and maybe someone has a good idea to suggest for
this problem.

Thanks,
SPD


"Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel Posted on 2009-12-19 22:29:06.0Z
From: "Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel@yahoo!.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <926249b4-61b5-43ff-9ab5-ddd59b581a41@g7g2000yqa.googlegroups.com>
Subject: Re: Dynamic Dropdowns
Lines: 35
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5843
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4b2d53b2@forums-1-dub>
Date: 19 Dec 2009 14:29:06 -0800
X-Trace: forums-1-dub 1261261746 10.22.241.152 (19 Dec 2009 14:29:06 -0800)
X-Original-Trace: 19 Dec 2009 14:29:06 -0800, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:90454
Article PK: 410059

Two thoughts: set up edit styles so each column in a new DW can easily be
assigned its appropriate DDDW.
Or put code in the ancestor DW to scan the columns in its dataobject, check
for DDDW style, modify SQL in the datawindowchild as appropriate. You would
want that to fire before the main DW is retrieved as that fires the retrieve
of the DDDWs. That would also be after SetTransObject, to be sure the
dataobject is correct.
I would probably have made a table for each of the columns' code tables for
simplicity of maintenance. This is based on the theory that code tables are
really business rules and should be user-maintained.

--
Report Bugs to Sybase: http://case-express.sybase.com/cx/welcome.do
Product Enhancement Requests:
http://my.isug.com/cgi-bin/1/c/submit_enhancement

"SPD0060" <sdavis@archi-tech-ture.com> wrote in message
news:926249b4-61b5-43ff-9ab5-ddd59b581a41@g7g2000yqa.googlegroups.com...
> In my app I have a table that contains all the data that will be used
> in all of the various ddws. I have to create a specific dwo for each
> dropdown field and have the where clause select from the table based
> on the name of the column (hard coded in the where clause). So I end
> up with dozens of these dwos. I assume I could drill down and replace
> the where clause of each dwo during the retrieve of the master dw but
> that seems like replacing one kind of tedious coding work with
> another. Is there any way to have a ddw change the where clause based
> upon the column it's on dynamically. I'm guessing 100% "no" but I
> thought I should ask and maybe someone has a good idea to suggest for
> this problem.
>
> Thanks,
> SPD


SPD0060 Posted on 2009-12-20 07:24:21.0Z
From: SPD0060 <sdavis@archi-tech-ture.com>
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: Dynamic Dropdowns
Date: Sat, 19 Dec 2009 23:24:21 -0800 (PST)
Organization: http://groups.google.com
Lines: 51
Message-ID: <c8a9ce2b-e0ed-4816-8c92-d08717484945@y24g2000yqb.googlegroups.com>
References: <926249b4-61b5-43ff-9ab5-ddd59b581a41@g7g2000yqa.googlegroups.com> <4b2d53b2@forums-1-dub>
NNTP-Posting-Host: 64.53.242.64
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
X-Trace: posting.google.com 1261293861 26163 127.0.0.1 (20 Dec 2009 07:24:21 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Sun, 20 Dec 2009 07:24:21 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: y24g2000yqb.googlegroups.com; posting-host=64.53.242.64; posting-account=7tUaPAoAAACDDfZ3NgtZxqThSQtCiLrn
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0; Trident/4.0; GTB6.3; SLCC1; .NET CLR 2.0.50727; InfoPath.2; .NET CLR 3.5.21022; .NET CLR 3.5.30729; .NET CLR 3.0.30729; OfficeLiveConnector.1.4; OfficeLivePatch.1.3),gzip(gfe),gzip(gfe)
Path: forums-1-dub!forums-master!newssvr.sybase.com!news-sj-1.sprintlink.net!news-peer1.sprintlink.net!nntp1.phx1.gblx.net!nntp.gblx.net!nntp.gblx.net!border2.nntp.dca.giganews.com!nntp.giganews.com!nx01.iad01.newshosting.com!209.197.12.246.MISMATCH!nx02.iad01.newshosting.com!newshosting.com!69.16.185.11.MISMATCH!npeer01.iad.highwinds-media.com!news.highwinds-media.com!feed-me.highwinds-media.com!postnews.google.com!y24g2000yqb.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:90456
Article PK: 410065

On Dec 19, 4:29 pm, "Jerry Siegel [TeamSybase]"

<jNOsSPAMsiegel@yahoo!.com> wrote:
> Two thoughts: set up edit styles so each column in a new DW can easily be
> assigned its appropriate DDDW.
> Or put code in the ancestor DW to scan the columns in its dataobject, check
> for DDDW style, modify SQL in the datawindowchild as appropriate. You would
> want that to fire before the main DW is retrieved as that fires the retrieve
> of the DDDWs. That would also be after SetTransObject, to be sure the
> dataobject is correct.
> I would probably have made a table for each of the columns' code tables for
> simplicity of maintenance. This is based on the theory that code tables are
> really business rules and should be user-maintained.
>
> --
> Report Bugs to Sybase:  http://case-express.sybase.com/cx/welcome.do
> Product Enhancement Requests:http://my.isug.com/cgi-bin/1/c/submit_enhancement
>
> "SPD0060" <sda...@archi-tech-ture.com> wrote in message
>
> news:926249b4-61b5-43ff-9ab5-ddd59b581a41@g7g2000yqa.googlegroups.com...
>
>
>
> > In my app I have a table that contains all the data that will be used
> > in all of the various ddws.  I have to create a specific dwo for each
> > dropdown field and have the where clause select from the table based
> > on the name of the column (hard coded in the where clause).  So I end
> > up with dozens of these dwos.  I assume I could drill down and replace
> > the where clause of each dwo during the retrieve of the master dw but
> > that seems like replacing one kind of tedious coding work with
> > another.  Is there any way to have a ddw change the where clause based
> > upon the column it's on dynamically.  I'm guessing 100% "no" but I
> > thought I should ask and maybe someone has a good idea to suggest for
> > this problem.
>
> > Thanks,
> > SPD- Hide quoted text -
>
> - Show quoted text -

This is what I was mulling and of course the admin users will have
access to the table on a column by column basis to mainitain it.
Thanks for the specific input it's just what I needed.


"Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel Posted on 2009-12-20 18:12:06.0Z
From: "Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel@yahoo!.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <926249b4-61b5-43ff-9ab5-ddd59b581a41@g7g2000yqa.googlegroups.com> <4b2d53b2@forums-1-dub> <c8a9ce2b-e0ed-4816-8c92-d08717484945@y24g2000yqb.googlegroups.com>
Subject: Re: Dynamic Dropdowns
Lines: 64
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5843
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4b2e68f6@forums-1-dub>
Date: 20 Dec 2009 10:12:06 -0800
X-Trace: forums-1-dub 1261332726 10.22.241.152 (20 Dec 2009 10:12:06 -0800)
X-Original-Trace: 20 Dec 2009 10:12:06 -0800, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:90458
Article PK: 410061

Yes, an alternative would be a general "Code Table Maintenance" window,
select a table from a dropdown and the appropriate DWO for the table is set
and retrieved. The negative to this is that it becomes more complex to
control security atomically (which users can modify which code tables).

--
Report Bugs to Sybase: http://case-express.sybase.com/cx/welcome.do
Product Enhancement Requests:
http://my.isug.com/cgi-bin/1/c/submit_enhancement


"SPD0060" <sdavis@archi-tech-ture.com> wrote in message
news:c8a9ce2b-e0ed-4816-8c92-d08717484945@y24g2000yqb.googlegroups.com...
On Dec 19, 4:29 pm, "Jerry Siegel [TeamSybase]"

<jNOsSPAMsiegel@yahoo!.com> wrote:
> Two thoughts: set up edit styles so each column in a new DW can easily be
> assigned its appropriate DDDW.
> Or put code in the ancestor DW to scan the columns in its dataobject,
> check
> for DDDW style, modify SQL in the datawindowchild as appropriate. You
> would
> want that to fire before the main DW is retrieved as that fires the
> retrieve
> of the DDDWs. That would also be after SetTransObject, to be sure the
> dataobject is correct.
> I would probably have made a table for each of the columns' code tables
> for
> simplicity of maintenance. This is based on the theory that code tables
> are
> really business rules and should be user-maintained.
>
> --
> Report Bugs to Sybase: http://case-express.sybase.com/cx/welcome.do
> Product Enhancement
> Requests:http://my.isug.com/cgi-bin/1/c/submit_enhancement
>
> "SPD0060" <sda...@archi-tech-ture.com> wrote in message
>
> news:926249b4-61b5-43ff-9ab5-ddd59b581a41@g7g2000yqa.googlegroups.com...
>
>
>
> > In my app I have a table that contains all the data that will be used
> > in all of the various ddws. I have to create a specific dwo for each
> > dropdown field and have the where clause select from the table based
> > on the name of the column (hard coded in the where clause). So I end
> > up with dozens of these dwos. I assume I could drill down and replace
> > the where clause of each dwo during the retrieve of the master dw but
> > that seems like replacing one kind of tedious coding work with
> > another. Is there any way to have a ddw change the where clause based
> > upon the column it's on dynamically. I'm guessing 100% "no" but I
> > thought I should ask and maybe someone has a good idea to suggest for
> > this problem.
>
> > Thanks,
> > SPD- Hide quoted text -
>
> - Show quoted text -

This is what I was mulling and of course the admin users will have
access to the table on a column by column basis to mainitain it.
Thanks for the specific input it's just what I needed.


Jeremy Lakeman Posted on 2009-12-20 03:56:43.0Z
From: Jeremy Lakeman <jeremy.lakeman@gmail.com>
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: Dynamic Dropdowns
Date: Sat, 19 Dec 2009 19:56:43 -0800 (PST)
Organization: http://groups.google.com
Lines: 35
Message-ID: <bfae73e6-ad50-4cd7-aa38-ecd51b12b553@v15g2000prn.googlegroups.com>
References: <926249b4-61b5-43ff-9ab5-ddd59b581a41@g7g2000yqa.googlegroups.com>
NNTP-Posting-Host: 122.49.175.125
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
X-Trace: posting.google.com 1261281404 18111 127.0.0.1 (20 Dec 2009 03:56:44 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Sun, 20 Dec 2009 03:56:44 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: v15g2000prn.googlegroups.com; posting-host=122.49.175.125; posting-account=euaBtgoAAAC_vDxfsxmpMKlBxHaHpmRS
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 6.1; en-GB; rv:1.9.1.6) Gecko/20091201 Firefox/3.5.6 (.NET CLR 3.5.30729),gzip(gfe),gzip(gfe)
Path: forums-1-dub!forums-master!newssvr.sybase.com!news-sj-1.sprintlink.net!news-peer1.sprintlink.net!nntp1.phx1.gblx.net!nntp.gblx.net!nntp.gblx.net!border2.nntp.dca.giganews.com!nntp.giganews.com!nx02.iad01.newshosting.com!newshosting.com!69.16.185.16.MISMATCH!npeer02.iad.highwinds-media.com!news.highwinds-media.com!feed-me.highwinds-media.com!postnews.google.com!v15g2000prn.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:90455
Article PK: 410060

Just use one dddw, turn off auto retrieve, and then;

datawindowchild ldwc
getchild('column', ldwc)
ldwc.settransobject(sqlca)
ldwc.retrieve(<type>)

And if you use a common ancestor datawindow class, you could;

long ll_col, ll_cols

ll_cols = long(this.object.datawindow.column.count)
for ll_col = 1 to ll_cols
ls_type=describe('#'+string(ll_col)+'.tag')
if ls_type<>'!' then
// as above...
end if
next

On Dec 20, 6:24 am, SPD0060 <sda...@archi-tech-ture.com> wrote:
> In my app I have a table that contains all the data that will be used
> in all of the various ddws.  I have to create a specific dwo for each
> dropdown field and have the where clause select from the table based
> on the name of the column (hard coded in the where clause).  So I end
> up with dozens of these dwos.  I assume I could drill down and replace
> the where clause of each dwo during the retrieve of the master dw but
> that seems like replacing one kind of tedious coding work with
> another.  Is there any way to have a ddw change the where clause based
> upon the column it's on dynamically.  I'm guessing 100% "no" but I
> thought I should ask and maybe someone has a good idea to suggest for
> this problem.
>
> Thanks,
> SPD


SPD0060 Posted on 2009-12-20 07:26:46.0Z
From: SPD0060 <sdavis@archi-tech-ture.com>
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: Dynamic Dropdowns
Date: Sat, 19 Dec 2009 23:26:46 -0800 (PST)
Organization: http://groups.google.com
Lines: 48
Message-ID: <ab7ee918-8745-4825-b275-ca1e4eb5f2dd@a21g2000yqc.googlegroups.com>
References: <926249b4-61b5-43ff-9ab5-ddd59b581a41@g7g2000yqa.googlegroups.com> <bfae73e6-ad50-4cd7-aa38-ecd51b12b553@v15g2000prn.googlegroups.com>
NNTP-Posting-Host: 64.53.242.64
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
X-Trace: posting.google.com 1261294006 27058 127.0.0.1 (20 Dec 2009 07:26:46 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Sun, 20 Dec 2009 07:26:46 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: a21g2000yqc.googlegroups.com; posting-host=64.53.242.64; posting-account=7tUaPAoAAACDDfZ3NgtZxqThSQtCiLrn
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0; Trident/4.0; GTB6.3; SLCC1; .NET CLR 2.0.50727; InfoPath.2; .NET CLR 3.5.21022; .NET CLR 3.5.30729; .NET CLR 3.0.30729; OfficeLiveConnector.1.4; OfficeLivePatch.1.3),gzip(gfe),gzip(gfe)
Path: forums-1-dub!forums-master!newssvr.sybase.com!news-sj-1.sprintlink.net!news-peer1.sprintlink.net!newsfeed.yul.equant.net!novia!news-out.readnews.com!news-xxxfer.readnews.com!postnews.google.com!a21g2000yqc.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:90457
Article PK: 410058


On Dec 19, 9:56 pm, Jeremy Lakeman <jeremy.lake...@gmail.com> wrote:
> Just use one dddw, turn off auto retrieve, and then;
>
> datawindowchild ldwc
> getchild('column', ldwc)
> ldwc.settransobject(sqlca)
> ldwc.retrieve(<type>)
>
> And if you use a common ancestor datawindow class, you could;
>
> long ll_col, ll_cols
>
> ll_cols = long(this.object.datawindow.column.count)
> for ll_col = 1 to ll_cols
>    ls_type=describe('#'+string(ll_col)+'.tag')
>    if ls_type<>'!' then
>       // as above...
>    end if
> next
>
> On Dec 20, 6:24 am, SPD0060 <sda...@archi-tech-ture.com> wrote:
>
>
>
> > In my app I have a table that contains all the data that will be used
> > in all of the various ddws.  I have to create a specific dwo for each
> > dropdown field and have the where clause select from the table based
> > on the name of the column (hard coded in the where clause).  So I end
> > up with dozens of these dwos.  I assume I could drill down and replace
> > the where clause of each dwo during the retrieve of the master dw but
> > that seems like replacing one kind of tedious coding work with
> > another.  Is there any way to have a ddw change the where clause based
> > upon the column it's on dynamically.  I'm guessing 100% "no" but I
> > thought I should ask and maybe someone has a good idea to suggest for
> > this problem.
>
> > Thanks,
> > SPD- Hide quoted text -
>
> - Show quoted text -

Just what the doctor ordered! Just to confirm the "!" you're
comparing in the .tag attribute is just what you might put there at
design time so that you you can identify that it is a ddw - right?

Thanks!


"Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel Posted on 2009-12-20 18:16:21.0Z
From: "Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel@yahoo!.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <926249b4-61b5-43ff-9ab5-ddd59b581a41@g7g2000yqa.googlegroups.com> <bfae73e6-ad50-4cd7-aa38-ecd51b12b553@v15g2000prn.googlegroups.com> <ab7ee918-8745-4825-b275-ca1e4eb5f2dd@a21g2000yqc.googlegroups.com>
Subject: Re: Dynamic Dropdowns
Lines: 60
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5843
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4b2e69f5$1@forums-1-dub>
Date: 20 Dec 2009 10:16:21 -0800
X-Trace: forums-1-dub 1261332981 10.22.241.152 (20 Dec 2009 10:16:21 -0800)
X-Original-Trace: 20 Dec 2009 10:16:21 -0800, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:90459
Article PK: 410062

! is returned by Modify when the property doesn't exist - that's guard code
so you don't try to work on something that's not there. To test for a DDDW
style, describe your choice of column_name.dddw.whatever and check for <>"!"

--
Report Bugs to Sybase: http://case-express.sybase.com/cx/welcome.do
Product Enhancement Requests:
http://my.isug.com/cgi-bin/1/c/submit_enhancement


"SPD0060" <sdavis@archi-tech-ture.com> wrote in message
news:ab7ee918-8745-4825-b275-ca1e4eb5f2dd@a21g2000yqc.googlegroups.com...

On Dec 19, 9:56 pm, Jeremy Lakeman <jeremy.lake...@gmail.com> wrote:
> Just use one dddw, turn off auto retrieve, and then;
>
> datawindowchild ldwc
> getchild('column', ldwc)
> ldwc.settransobject(sqlca)
> ldwc.retrieve(<type>)
>
> And if you use a common ancestor datawindow class, you could;
>
> long ll_col, ll_cols
>
> ll_cols = long(this.object.datawindow.column.count)
> for ll_col = 1 to ll_cols
> ls_type=describe('#'+string(ll_col)+'.tag')
> if ls_type<>'!' then
> // as above...
> end if
> next
>
> On Dec 20, 6:24 am, SPD0060 <sda...@archi-tech-ture.com> wrote:
>
>
>
> > In my app I have a table that contains all the data that will be used
> > in all of the various ddws. I have to create a specific dwo for each
> > dropdown field and have the where clause select from the table based
> > on the name of the column (hard coded in the where clause). So I end
> > up with dozens of these dwos. I assume I could drill down and replace
> > the where clause of each dwo during the retrieve of the master dw but
> > that seems like replacing one kind of tedious coding work with
> > another. Is there any way to have a ddw change the where clause based
> > upon the column it's on dynamically. I'm guessing 100% "no" but I
> > thought I should ask and maybe someone has a good idea to suggest for
> > this problem.
>
> > Thanks,
> > SPD- Hide quoted text -
>
> - Show quoted text -

Just what the doctor ordered! Just to confirm the "!" you're
comparing in the .tag attribute is just what you might put there at
design time so that you you can identify that it is a ddw - right?

Thanks!


SPD0060 Posted on 2009-12-20 21:37:49.0Z
From: SPD0060 <sdavis@archi-tech-ture.com>
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: Dynamic Dropdowns
Date: Sun, 20 Dec 2009 13:37:49 -0800 (PST)
Organization: http://groups.google.com
Lines: 72
Message-ID: <9172a690-289b-479e-a6db-a7ef5065512b@k17g2000yqh.googlegroups.com>
References: <926249b4-61b5-43ff-9ab5-ddd59b581a41@g7g2000yqa.googlegroups.com> <bfae73e6-ad50-4cd7-aa38-ecd51b12b553@v15g2000prn.googlegroups.com> <ab7ee918-8745-4825-b275-ca1e4eb5f2dd@a21g2000yqc.googlegroups.com> <4b2e69f5$1@forums-1-dub>
NNTP-Posting-Host: 64.53.242.64
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
X-Trace: posting.google.com 1261345070 30290 127.0.0.1 (20 Dec 2009 21:37:50 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Sun, 20 Dec 2009 21:37:50 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: k17g2000yqh.googlegroups.com; posting-host=64.53.242.64; posting-account=7tUaPAoAAACDDfZ3NgtZxqThSQtCiLrn
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0; Trident/4.0; GTB6.3; SLCC1; .NET CLR 2.0.50727; InfoPath.2; .NET CLR 3.5.21022; .NET CLR 3.5.30729; .NET CLR 3.0.30729; OfficeLiveConnector.1.4; OfficeLivePatch.1.3),gzip(gfe),gzip(gfe)
Path: forums-1-dub!forums-master!newssvr.sybase.com!news-sj-1.sprintlink.net!news-peer1.sprintlink.net!newsfeed.yul.equant.net!novia!news-out.readnews.com!transit3.readnews.com!postnews.google.com!k17g2000yqh.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:90460
Article PK: 410063

On Dec 20, 12:16 pm, "Jerry Siegel [TeamSybase]"

<jNOsSPAMsiegel@yahoo!.com> wrote:
> ! is returned by Modify when the property doesn't exist - that's guard code
> so you don't try to work on something that's not there. To test for a DDDW
> style, describe your choice of column_name.dddw.whatever and check for <>"!"
>
> --
> Report Bugs to Sybase:  http://case-express.sybase.com/cx/welcome.do
> Product Enhancement Requests:http://my.isug.com/cgi-bin/1/c/submit_enhancement
>
> "SPD0060" <sda...@archi-tech-ture.com> wrote in message
>
> news:ab7ee918-8745-4825-b275-ca1e4eb5f2dd@a21g2000yqc.googlegroups.com...
> On Dec 19, 9:56 pm, Jeremy Lakeman <jeremy.lake...@gmail.com> wrote:
>
>
>
>
>
> > Just use one dddw, turn off auto retrieve, and then;
>
> > datawindowchild ldwc
> > getchild('column', ldwc)
> > ldwc.settransobject(sqlca)
> > ldwc.retrieve(<type>)
>
> > And if you use a common ancestor datawindow class, you could;
>
> > long ll_col, ll_cols
>
> > ll_cols = long(this.object.datawindow.column.count)
> > for ll_col = 1 to ll_cols
> > ls_type=describe('#'+string(ll_col)+'.tag')
> > if ls_type<>'!' then
> > // as above...
> > end if
> > next
>
> > On Dec 20, 6:24 am, SPD0060 <sda...@archi-tech-ture.com> wrote:
>
> > > In my app I have a table that contains all the data that will be used
> > > in all of the various ddws. I have to create a specific dwo for each
> > > dropdown field and have the where clause select from the table based
> > > on the name of the column (hard coded in the where clause). So I end
> > > up with dozens of these dwos. I assume I could drill down and replace
> > > the where clause of each dwo during the retrieve of the master dw but
> > > that seems like replacing one kind of tedious coding work with
> > > another. Is there any way to have a ddw change the where clause based
> > > upon the column it's on dynamically. I'm guessing 100% "no" but I
> > > thought I should ask and maybe someone has a good idea to suggest for
> > > this problem.
>
> > > Thanks,
> > > SPD- Hide quoted text -
>
> > - Show quoted text -
>
> Just what the doctor ordered!  Just to confirm the "!" you're
> comparing in the .tag attribute is just what you might put there at
> design time so that you you can identify that it is a ddw - right?
>
> Thanks!- Hide quoted text -
>
> - Show quoted text -

Thanks - I had a feeling that "!" might be something special and I
didn't notice the "<>" - duh. Should I just use the ddw.name to see
if there is a dddw - if it's null then move on...?


"Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel Posted on 2009-12-20 22:51:36.0Z
From: "Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel@yahoo!.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <926249b4-61b5-43ff-9ab5-ddd59b581a41@g7g2000yqa.googlegroups.com> <bfae73e6-ad50-4cd7-aa38-ecd51b12b553@v15g2000prn.googlegroups.com> <ab7ee918-8745-4825-b275-ca1e4eb5f2dd@a21g2000yqc.googlegroups.com> <4b2e69f5$1@forums-1-dub> <9172a690-289b-479e-a6db-a7ef5065512b@k17g2000yqh.googlegroups.com>
Subject: Re: Dynamic Dropdowns
Lines: 94
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5843
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4b2eaa78$1@forums-1-dub>
Date: 20 Dec 2009 14:51:36 -0800
X-Trace: forums-1-dub 1261349496 10.22.241.152 (20 Dec 2009 14:51:36 -0800)
X-Original-Trace: 20 Dec 2009 14:51:36 -0800, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:90462
Article PK: 410066

Help:
If the property list contains an invalid item, Describe returns an
exclamation point (!) for that item and ignores the rest of the property
list. Describe returns a question mark (?) if there is no value for a
property.
When the value of a property contains an exclamation point or a question
mark, the value is returned in quotes so that you can distinguish between
the returned value and an invalid item or a property with no value.

I figure if there's a DDDW on the column, DDDW.name would be the first thing
to look at. DataColumn and DisplayColumn are the others needed to make DDDW
function, the rest of the properties are cosmetic.

--
Report Bugs to Sybase: http://case-express.sybase.com/cx/welcome.do
Product Enhancement Requests:
http://my.isug.com/cgi-bin/1/c/submit_enhancement


"SPD0060" <sdavis@archi-tech-ture.com> wrote in message
news:9172a690-289b-479e-a6db-a7ef5065512b@k17g2000yqh.googlegroups.com...
On Dec 20, 12:16 pm, "Jerry Siegel [TeamSybase]"

<jNOsSPAMsiegel@yahoo!.com> wrote:
> ! is returned by Modify when the property doesn't exist - that's guard
> code
> so you don't try to work on something that's not there. To test for a DDDW
> style, describe your choice of column_name.dddw.whatever and check for
> <>"!"
>
> --
> Report Bugs to Sybase: http://case-express.sybase.com/cx/welcome.do
> Product Enhancement
> Requests:http://my.isug.com/cgi-bin/1/c/submit_enhancement
>
> "SPD0060" <sda...@archi-tech-ture.com> wrote in message
>
> news:ab7ee918-8745-4825-b275-ca1e4eb5f2dd@a21g2000yqc.googlegroups.com...
> On Dec 19, 9:56 pm, Jeremy Lakeman <jeremy.lake...@gmail.com> wrote:
>
>
>
>
>
> > Just use one dddw, turn off auto retrieve, and then;
>
> > datawindowchild ldwc
> > getchild('column', ldwc)
> > ldwc.settransobject(sqlca)
> > ldwc.retrieve(<type>)
>
> > And if you use a common ancestor datawindow class, you could;
>
> > long ll_col, ll_cols
>
> > ll_cols = long(this.object.datawindow.column.count)
> > for ll_col = 1 to ll_cols
> > ls_type=describe('#'+string(ll_col)+'.tag')
> > if ls_type<>'!' then
> > // as above...
> > end if
> > next
>
> > On Dec 20, 6:24 am, SPD0060 <sda...@archi-tech-ture.com> wrote:
>
> > > In my app I have a table that contains all the data that will be used
> > > in all of the various ddws. I have to create a specific dwo for each
> > > dropdown field and have the where clause select from the table based
> > > on the name of the column (hard coded in the where clause). So I end
> > > up with dozens of these dwos. I assume I could drill down and replace
> > > the where clause of each dwo during the retrieve of the master dw but
> > > that seems like replacing one kind of tedious coding work with
> > > another. Is there any way to have a ddw change the where clause based
> > > upon the column it's on dynamically. I'm guessing 100% "no" but I
> > > thought I should ask and maybe someone has a good idea to suggest for
> > > this problem.
>
> > > Thanks,
> > > SPD- Hide quoted text -
>
> > - Show quoted text -
>
> Just what the doctor ordered! Just to confirm the "!" you're
> comparing in the .tag attribute is just what you might put there at
> design time so that you you can identify that it is a ddw - right?
>
> Thanks!- Hide quoted text -
>
> - Show quoted text -

Thanks - I had a feeling that "!" might be something special and I
didn't notice the "<>" - duh. Should I just use the ddw.name to see
if there is a dddw - if it's null then move on...?


Jeremy Lakeman Posted on 2009-12-21 00:29:27.0Z
From: Jeremy Lakeman <jeremy.lakeman@gmail.com>
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: Dynamic Dropdowns
Date: Sun, 20 Dec 2009 16:29:27 -0800 (PST)
Organization: http://groups.google.com
Lines: 96
Message-ID: <b59819ef-291b-456e-8db3-44ff5fe5fec1@k32g2000prb.googlegroups.com>
References: <926249b4-61b5-43ff-9ab5-ddd59b581a41@g7g2000yqa.googlegroups.com> <bfae73e6-ad50-4cd7-aa38-ecd51b12b553@v15g2000prn.googlegroups.com> <ab7ee918-8745-4825-b275-ca1e4eb5f2dd@a21g2000yqc.googlegroups.com> <4b2e69f5$1@forums-1-dub> <9172a690-289b-479e-a6db-a7ef5065512b@k17g2000yqh.googlegroups.com>
NNTP-Posting-Host: 122.49.175.125
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
X-Trace: posting.google.com 1261355367 25317 127.0.0.1 (21 Dec 2009 00:29:27 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Mon, 21 Dec 2009 00:29:27 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: k32g2000prb.googlegroups.com; posting-host=122.49.175.125; posting-account=euaBtgoAAAC_vDxfsxmpMKlBxHaHpmRS
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 6.1; en-GB; rv:1.9.1.6) Gecko/20091201 Firefox/3.5.6 (.NET CLR 3.5.30729),gzip(gfe),gzip(gfe)
Path: forums-1-dub!forums-master!newssvr.sybase.com!news-sj-1.sprintlink.net!news-peer1.sprintlink.net!newsfeed.yul.equant.net!novia!news-out.readnews.com!transit3.readnews.com!postnews.google.com!k32g2000prb.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:90463
Article PK: 410067


On Dec 21, 7:37 am, SPD0060 <sda...@archi-tech-ture.com> wrote:
> On Dec 20, 12:16 pm, "Jerry Siegel [TeamSybase]"
>
>
>
> <jNOsSPAMsiegel@yahoo!.com> wrote:
> > ! is returned by Modify when the property doesn't exist - that's guard code
> > so you don't try to work on something that's not there. To test for a DDDW
> > style, describe your choice of column_name.dddw.whatever and check for <>"!"
>
> > --
> > Report Bugs to Sybase:  http://case-express.sybase.com/cx/welcome.do
> > Product Enhancement Requests:http://my.isug.com/cgi-bin/1/c/submit_enhancement
>
> > "SPD0060" <sda...@archi-tech-ture.com> wrote in message
>
> >news:ab7ee918-8745-4825-b275-ca1e4eb5f2dd@a21g2000yqc.googlegroups.com...
> > On Dec 19, 9:56 pm, Jeremy Lakeman <jeremy.lake...@gmail.com> wrote:
>
> > > Just use one dddw, turn off auto retrieve, and then;
>
> > > datawindowchild ldwc
> > > getchild('column', ldwc)
> > > ldwc.settransobject(sqlca)
> > > ldwc.retrieve(<type>)
>
> > > And if you use a common ancestor datawindow class, you could;
>
> > > long ll_col, ll_cols
>
> > > ll_cols = long(this.object.datawindow.column.count)
> > > for ll_col = 1 to ll_cols
> > > ls_type=describe('#'+string(ll_col)+'.tag')
> > > if ls_type<>'!' then
> > > // as above...
> > > end if
> > > next
>
> > > On Dec 20, 6:24 am, SPD0060 <sda...@archi-tech-ture.com> wrote:
>
> > > > In my app I have a table that contains all the data that will be used
> > > > in all of the various ddws. I have to create a specific dwo for each
> > > > dropdown field and have the where clause select from the table based
> > > > on the name of the column (hard coded in the where clause). So I end
> > > > up with dozens of these dwos. I assume I could drill down and replace
> > > > the where clause of each dwo during the retrieve of the master dw but
> > > > that seems like replacing one kind of tedious coding work with
> > > > another. Is there any way to have a ddw change the where clause based
> > > > upon the column it's on dynamically. I'm guessing 100% "no" but I
> > > > thought I should ask and maybe someone has a good idea to suggest for
> > > > this problem.
>
> > > > Thanks,
> > > > SPD- Hide quoted text -
>
> > > - Show quoted text -
>
> > Just what the doctor ordered!  Just to confirm the "!" you're
> > comparing in the .tag attribute is just what you might put there at
> > design time so that you you can identify that it is a ddw - right?
>
> > Thanks!- Hide quoted text -
>
> > - Show quoted text -
>
> Thanks - I had a feeling that "!" might be something special and I
> didn't notice the "<>" - duh.  Should I just use the ddw.name to see
> if there is a dddw - if it's null then move on...?

Yeah, and if you store the drop down type in the tag property, you
only need one dataobject for the dropdown.

perhaps (insert name of your single dddw);

if describe("#"+string(ll_col)+".dddw.name") = "d_generic_dddw"
then
ls_type=describe("#"+string(ll_col)+".tag")
...
ldwc.retrieve(ls_type)
end if

Though you could write a more generic solution that could retrieve
*any* drop down with *any* number and type of arguments...