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.

NULL value in dropdown

5 posts in DataWindow Last posting was on 2009-04-02 19:39:40.0Z
Sri Posted on 2009-04-02 12:15:11.0Z
From: Sri <crazysrinath@gmail.com>
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: NULL value in dropdown
Date: Thu, 2 Apr 2009 05:15:11 -0700 (PDT)
Organization: http://groups.google.com
Lines: 26
Message-ID: <af8307c5-baa9-49a8-b835-4c35c7e2c13b@f41g2000pra.googlegroups.com>
NNTP-Posting-Host: 162.119.240.109
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-Trace: posting.google.com 1238674511 14493 127.0.0.1 (2 Apr 2009 12:15:11 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Thu, 2 Apr 2009 12:15:11 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: f41g2000pra.googlegroups.com; posting-host=162.119.240.109; posting-account=F9e4SQoAAABWwr_PYyru5O1UuI7c9I0p
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; InfoPath.1; .NET CLR 2.0.50727),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!postnews.google.com!f41g2000pra.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89103
Article PK: 418356

Hi All,

I have a window where the drop down window values are populated on the
basis of a checkbox and radio button selection. When check box is ON
one set values are populated. When radio button is ON other set of
values of values are populated. I do this with the help of filtering
the dropdown. I have written in the item changed event of the
datawindow the codes to populate the values as and when the user
changes his selection.

My problem is when both the options are NOT selected. That time I want
a empty value (NULL) to be displayed in the dropdown. The datawindow
is non editable. I have tried all these below codes

(datawindowchild ldwc_test)

ldwc_test.setitem(row,column,setnull(temp))
ldwc_test.object.columndescription = setnull(tempstring)

datawindow.object.column[row] =setnull(temp)

i = ldwc_test.insertrow(1)
ldwc_test.scrolltorow(i)

Please let me know how to set the value as empty or null in dropdown..


"Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel Posted on 2009-04-02 13:10:07.0Z
From: "Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel@yahoo!.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <af8307c5-baa9-49a8-b835-4c35c7e2c13b@f41g2000pra.googlegroups.com>
Subject: Re: NULL value in dropdown
Lines: 46
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: <49d4b92f$1@forums-1-dub>
Date: 2 Apr 2009 05:10:07 -0800
X-Trace: forums-1-dub 1238677807 10.22.241.152 (2 Apr 2009 05:10:07 -0800)
X-Original-Trace: 2 Apr 2009 05:10:07 -0800, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89104
Article PK: 418353

You are trying to use the return from setnull, which is an integer.
String temp
SetNull(temp)
ldwc_test.setitem(row,column,temp)

There is an enhancement request pending to have a null! keyword so you could
code
ldwc_test.setitem(row,column,null!)
without the extra declaration.


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

"Sri" <crazysrinath@gmail.com> wrote in message
news:af8307c5-baa9-49a8-b835-4c35c7e2c13b@f41g2000pra.googlegroups.com...
> Hi All,
>
> I have a window where the drop down window values are populated on the
> basis of a checkbox and radio button selection. When check box is ON
> one set values are populated. When radio button is ON other set of
> values of values are populated. I do this with the help of filtering
> the dropdown. I have written in the item changed event of the
> datawindow the codes to populate the values as and when the user
> changes his selection.
>
> My problem is when both the options are NOT selected. That time I want
> a empty value (NULL) to be displayed in the dropdown. The datawindow
> is non editable. I have tried all these below codes
>
> (datawindowchild ldwc_test)
>
> ldwc_test.setitem(row,column,setnull(temp))
> ldwc_test.object.columndescription = setnull(tempstring)
>
> datawindow.object.column[row] =setnull(temp)
>
> i = ldwc_test.insertrow(1)
> ldwc_test.scrolltorow(i)
>
> Please let me know how to set the value as empty or null in dropdown..
>


Jeremy Lakeman Posted on 2009-04-02 14:36:45.0Z
From: Jeremy Lakeman <jeremy.lakeman@gmail.com>
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: NULL value in dropdown
Date: Thu, 2 Apr 2009 07:36:45 -0700 (PDT)
Organization: http://groups.google.com
Lines: 52
Message-ID: <45d5c05f-523b-48eb-a2ab-67fd104598ab@f41g2000pra.googlegroups.com>
References: <af8307c5-baa9-49a8-b835-4c35c7e2c13b@f41g2000pra.googlegroups.com> <49d4b92f$1@forums-1-dub>
NNTP-Posting-Host: 114.30.106.123
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
X-Trace: posting.google.com 1238683005 9373 127.0.0.1 (2 Apr 2009 14:36:45 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Thu, 2 Apr 2009 14:36:45 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: f41g2000pra.googlegroups.com; posting-host=114.30.106.123; posting-account=euaBtgoAAAC_vDxfsxmpMKlBxHaHpmRS
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.2; en-US; rv:1.9.1b3) Gecko/20090305 Firefox/3.1b3,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!nntp1.roc.gblx.net!nntp.gblx.net!nntp.gblx.net!nlpi057.nbdc.sbc.com!prodigy.net!border1.nntp.dca.giganews.com!nntp.giganews.com!postnews.google.com!f41g2000pra.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89110
Article PK: 418358

I have a global any variable called null, which can then be casted to
the required type...
ldwc_test.setitem(row,column,long(null))

On Apr 2, 11:10 pm, "Jerry Siegel [TeamSybase]"

<jNOsSPAMsiegel@yahoo!.com> wrote:
> You are trying to use the return from setnull, which is an integer.
> String temp
> SetNull(temp)
> ldwc_test.setitem(row,column,temp)
>
> There is an enhancement request pending to have a null! keyword so you could
> code
> ldwc_test.setitem(row,column,null!)
> without the extra declaration.
>
> --
> Report Bugs:http://case-express.sybase.com/cx/welcome.do
> Product Enhancement Requests:http://my.isug.com/cgi-bin/1/c/submit_enhancement
>
> "Sri" <crazysrin...@gmail.com> wrote in message
>
> news:af8307c5-baa9-49a8-b835-4c35c7e2c13b@f41g2000pra.googlegroups.com...
>
> > Hi All,
>
> > I have a window where the drop down window values are populated on the
> > basis of a checkbox and radio button selection. When check box is ON
> > one set values are populated. When radio button is ON other set of
> > values of values are populated. I do this with the help of filtering
> > the dropdown. I have written in the item changed event of the
> > datawindow the codes to populate the values as and when the user
> > changes his selection.
>
> > My problem is when both the options are NOT selected. That time I want
> > a empty value (NULL) to be displayed in the dropdown. The datawindow
> > is non editable. I have tried all these below codes
>
> > (datawindowchild ldwc_test)
>
> > ldwc_test.setitem(row,column,setnull(temp))
> > ldwc_test.object.columndescription = setnull(tempstring)
>
> > datawindow.object.column[row] =setnull(temp)
>
> > i = ldwc_test.insertrow(1)
> > ldwc_test.scrolltorow(i)
>
> > Please let me know how to set the value as empty or null in dropdown..


Sri Posted on 2009-04-02 17:39:29.0Z
From: Sri <crazysrinath@gmail.com>
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: NULL value in dropdown
Date: Thu, 2 Apr 2009 10:39:29 -0700 (PDT)
Organization: http://groups.google.com
Lines: 81
Message-ID: <4d7e8317-f8eb-42c5-bfcb-fe1d60d1e70b@j9g2000prh.googlegroups.com>
References: <af8307c5-baa9-49a8-b835-4c35c7e2c13b@f41g2000pra.googlegroups.com> <49d4b92f$1@forums-1-dub> <45d5c05f-523b-48eb-a2ab-67fd104598ab@f41g2000pra.googlegroups.com>
NNTP-Posting-Host: 122.164.116.97
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
X-Trace: posting.google.com 1238693970 5145 127.0.0.1 (2 Apr 2009 17:39:30 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Thu, 2 Apr 2009 17:39:30 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: j9g2000prh.googlegroups.com; posting-host=122.164.116.97; posting-account=F9e4SQoAAABWwr_PYyru5O1UuI7c9I0p
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.0; Trident/4.0; SLCC1; .NET CLR 2.0.50727; Media Center PC 5.0; .NET CLR 3.0.04506; InfoPath.2),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!postnews.google.com!j9g2000prh.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89111
Article PK: 418363

Hi Thanks both of you for your replies.

So in my item changed event of my dw for the checkbox and radio button
selection I write the following code for the condition that neither of
them are selected

datawindowchild ldwc
long ll_newrow
String temp
SetNull(temp)
ll_newrow = ldwc.insertrow( 0 ) /*since my dropdown doesn hve a null
value while retrieving*/
ldwc_test.setitem(ll_newrow ,display-column,temp)

Please confirm the above code.. Will this insert a new row everytime
the user selects neither of the options because its written in item
chnged event?

On Apr 2, 7:36 pm, Jeremy Lakeman <jeremy.lake...@gmail.com> wrote:
> I have a global any variable called null, which can then be casted to
> the required type...
> ldwc_test.setitem(row,column,long(null))
>
> On Apr 2, 11:10 pm, "Jerry Siegel [TeamSybase]"
>
>
>
> <jNOsSPAMsiegel@yahoo!.com> wrote:
> > You are trying to use the return from setnull, which is an integer.
> > String temp
> > SetNull(temp)
> > ldwc_test.setitem(row,column,temp)
>
> > There is an enhancement request pending to have a null! keyword so you could
> > code
> > ldwc_test.setitem(row,column,null!)
> > without the extra declaration.
>
> > --
> > Report Bugs:http://case-express.sybase.com/cx/welcome.do
> > Product Enhancement Requests:http://my.isug.com/cgi-bin/1/c/submit_enhancement
>
> > "Sri" <crazysrin...@gmail.com> wrote in message
>
> >news:af8307c5-baa9-49a8-b835-4c35c7e2c13b@f41g2000pra.googlegroups.com...
>
> > > Hi All,
>
> > > I have a window where the drop down window values are populated on the
> > > basis of a checkbox and radio button selection. When check box is ON
> > > one set values are populated. When radio button is ON other set of
> > > values of values are populated. I do this with the help of filtering
> > > the dropdown. I have written in the item changed event of the
> > > datawindow the codes to populate the values as and when the user
> > > changes his selection.
>
> > > My problem is when both the options are NOT selected. That time I want
> > > a empty value (NULL) to be displayed in the dropdown. The datawindow
> > > is non editable. I have tried all these below codes
>
> > > (datawindowchild ldwc_test)
>
> > > ldwc_test.setitem(row,column,setnull(temp))
> > > ldwc_test.object.columndescription = setnull(tempstring)
>
> > > datawindow.object.column[row] =setnull(temp)
>
> > > i = ldwc_test.insertrow(1)
> > > ldwc_test.scrolltorow(i)
>
> > > Please let me know how to set the value as empty or null in dropdown..- Hide quoted text -
>
> - Show quoted text -


"Paul Horan[Sybase]" <phoran_remove Posted on 2009-04-02 19:39:40.0Z
From: "Paul Horan[Sybase]" <phoran_remove@remove_sybase.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <af8307c5-baa9-49a8-b835-4c35c7e2c13b@f41g2000pra.googlegroups.com> <49d4b92f$1@forums-1-dub> <45d5c05f-523b-48eb-a2ab-67fd104598ab@f41g2000pra.googlegroups.com> <4d7e8317-f8eb-42c5-bfcb-fe1d60d1e70b@j9g2000prh.googlegroups.com>
Subject: Re: NULL value in dropdown
Lines: 93
Organization: Sybase
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
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: <49d5147c@forums-1-dub>
Date: 2 Apr 2009 11:39:40 -0800
X-Trace: forums-1-dub 1238701180 10.22.241.152 (2 Apr 2009 11:39:40 -0800)
X-Original-Trace: 2 Apr 2009 11:39:40 -0800, vip152.sybase.com
X-Authenticated-User: teamsybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89112
Article PK: 418366

I wouldn't do it there.

Just change the SQL of the dropdowndw to include a "NULL" value.

(original SQL)
UNION ALL
Select NULL, 'None' from dummy ;

--
Paul Horan[Sybase]
paulhoran.pbdjmagazine.com

"Sri" <crazysrinath@gmail.com> wrote in message
news:4d7e8317-f8eb-42c5-bfcb-fe1d60d1e70b@j9g2000prh.googlegroups.com...

Hi Thanks both of you for your replies.

So in my item changed event of my dw for the checkbox and radio button
selection I write the following code for the condition that neither of
them are selected

datawindowchild ldwc
long ll_newrow
String temp
SetNull(temp)
ll_newrow = ldwc.insertrow( 0 ) /*since my dropdown doesn hve a null
value while retrieving*/
ldwc_test.setitem(ll_newrow ,display-column,temp)

Please confirm the above code.. Will this insert a new row everytime
the user selects neither of the options because its written in item
chnged event?

On Apr 2, 7:36 pm, Jeremy Lakeman <jeremy.lake...@gmail.com> wrote:
> I have a global any variable called null, which can then be casted to
> the required type...
> ldwc_test.setitem(row,column,long(null))
>
> On Apr 2, 11:10 pm, "Jerry Siegel [TeamSybase]"
>
>
>
> <jNOsSPAMsiegel@yahoo!.com> wrote:
> > You are trying to use the return from setnull, which is an integer.
> > String temp
> > SetNull(temp)
> > ldwc_test.setitem(row,column,temp)
>
> > There is an enhancement request pending to have a null! keyword so you
> > could
> > code
> > ldwc_test.setitem(row,column,null!)
> > without the extra declaration.
>
> > --
> > Report Bugs:http://case-express.sybase.com/cx/welcome.do
> > Product Enhancement
> > Requests:http://my.isug.com/cgi-bin/1/c/submit_enhancement
>
> > "Sri" <crazysrin...@gmail.com> wrote in message
>
> >news:af8307c5-baa9-49a8-b835-4c35c7e2c13b@f41g2000pra.googlegroups.com...
>
> > > Hi All,
>
> > > I have a window where the drop down window values are populated on the
> > > basis of a checkbox and radio button selection. When check box is ON
> > > one set values are populated. When radio button is ON other set of
> > > values of values are populated. I do this with the help of filtering
> > > the dropdown. I have written in the item changed event of the
> > > datawindow the codes to populate the values as and when the user
> > > changes his selection.
>
> > > My problem is when both the options are NOT selected. That time I want
> > > a empty value (NULL) to be displayed in the dropdown. The datawindow
> > > is non editable. I have tried all these below codes
>
> > > (datawindowchild ldwc_test)
>
> > > ldwc_test.setitem(row,column,setnull(temp))
> > > ldwc_test.object.columndescription = setnull(tempstring)
>
> > > datawindow.object.column[row] =setnull(temp)
>
> > > i = ldwc_test.insertrow(1)
> > > ldwc_test.scrolltorow(i)
>
> > > Please let me know how to set the value as empty or null in
> > > dropdown..- Hide quoted text -
>
> - Show quoted text -