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.

3 state checkbox question

5 posts in DataWindow Last posting was on 2009-12-12 00:07:41.0Z
David Posted on 2009-12-10 17:52:50.0Z
From: David <d.shuman.NOSPAM@att.net>
User-Agent: Thunderbird 2.0.0.23 (Windows/20090812)
MIME-Version: 1.0
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: 3 state checkbox question
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Antivirus: avast! (VPS 091210-0, 2009/12/10), Outbound message
X-Antivirus-Status: Clean
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4b213572$1@forums-1-dub>
Date: 10 Dec 2009 09:52:50 -0800
X-Trace: forums-1-dub 1260467570 10.22.241.152 (10 Dec 2009 09:52:50 -0800)
X-Original-Trace: 10 Dec 2009 09:52:50 -0800, vip152.sybase.com
Lines: 17
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:90424
Article PK: 410027

reposted from database where is was incorrectly posted, sorry.


I have a standard client server application with a Datawindow in PB
10.2.1 with a three state checkbox attached to a SQL ANYWHERE developer
11.0.1 database column. The column is created with type BIT NULL
DEFAULT NULL.

I have 1 for on, 0 for off and null for other state in the edit property
tag and when I toggle around the options using run / preview mode on the
datawindow It tells me Item 'null' does not pass the validation test.

Can I and if so how do I specify null as the other value for the
checkbox? It appears my attempted entry is incorrect. Is this possible
in more current versions of PowerBuilder if not in version 10.2.1

Thanks in advance


"Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel Posted on 2009-12-10 21:46:23.0Z
From: "Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel@yahoo!.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <4b213572$1@forums-1-dub>
Subject: Re: 3 state checkbox question
Lines: 30
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5843
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: <4b216c2f@forums-1-dub>
Date: 10 Dec 2009 13:46:23 -0800
X-Trace: forums-1-dub 1260481583 10.22.241.152 (10 Dec 2009 13:46:23 -0800)
X-Original-Trace: 10 Dec 2009 13:46:23 -0800, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:90425
Article PK: 410029

Couldn't find the documentation, but you need an exclamation on the value to
make it enumerated: null! vs null

--
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

"David" <d.shuman.NOSPAM@att.net> wrote in message
news:4b213572$1@forums-1-dub...
> reposted from database where is was incorrectly posted, sorry.
>
>
> I have a standard client server application with a Datawindow in PB
> 10.2.1 with a three state checkbox attached to a SQL ANYWHERE developer
> 11.0.1 database column. The column is created with type BIT NULL
> DEFAULT NULL.
>
> I have 1 for on, 0 for off and null for other state in the edit property
> tag and when I toggle around the options using run / preview mode on the
> datawindow It tells me Item 'null' does not pass the validation test.
>
> Can I and if so how do I specify null as the other value for the
> checkbox? It appears my attempted entry is incorrect. Is this possible
> in more current versions of PowerBuilder if not in version 10.2.1
>
> Thanks in advance


David Posted on 2009-12-11 20:47:24.0Z
From: David <d.shuman.NOSPAM@att.net>
User-Agent: Thunderbird 2.0.0.23 (Windows/20090812)
MIME-Version: 1.0
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: 3 state checkbox question
References: <4b213572$1@forums-1-dub> <4b216c2f@forums-1-dub>
In-Reply-To: <4b216c2f@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Antivirus: avast! (VPS 091211-0, 2009/12/11), Outbound message
X-Antivirus-Status: Clean
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4b22afdc$1@forums-1-dub>
Date: 11 Dec 2009 12:47:24 -0800
X-Trace: forums-1-dub 1260564444 10.22.241.152 (11 Dec 2009 12:47:24 -0800)
X-Original-Trace: 11 Dec 2009 12:47:24 -0800, vip152.sybase.com
Lines: 10
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:90431
Article PK: 410035


Jerry Siegel [TeamSybase] wrote:
> Couldn't find the documentation, but you need an exclamation on the value to
> make it enumerated: null! vs null
>

Jerry I went looking for the equivalent to the site dcx.sybase.com for
SQL Anyhwere to suggest a documentation update for PowerBuilder and was
even going to give you the credit for the update -- is there an
equivalent a facility for PowerBuilder?


"Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel Posted on 2009-12-12 00:07:41.0Z
From: "Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel@yahoo!.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <4b213572$1@forums-1-dub> <4b216c2f@forums-1-dub> <4b22afdc$1@forums-1-dub>
Subject: Re: 3 state checkbox question
Lines: 24
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5843
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: <4b22decd$1@forums-1-dub>
Date: 11 Dec 2009 16:07:41 -0800
X-Trace: forums-1-dub 1260576461 10.22.241.152 (11 Dec 2009 16:07:41 -0800)
X-Original-Trace: 11 Dec 2009 16:07:41 -0800, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:90432
Article PK: 410037

The case-express link below.
I did find something under "defining a code table" but it's thoroughly
buried and rather unclear that it applies in this case.

--
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

"David" <d.shuman.NOSPAM@att.net> wrote in message
news:4b22afdc$1@forums-1-dub...
> Jerry Siegel [TeamSybase] wrote:
>> Couldn't find the documentation, but you need an exclamation on the value
>> to make it enumerated: null! vs null
>>
>
>
> Jerry I went looking for the equivalent to the site dcx.sybase.com for SQL
> Anyhwere to suggest a documentation update for PowerBuilder and was even
> going to give you the credit for the update -- is there an equivalent a
> facility for PowerBuilder?


David Posted on 2009-12-11 11:10:07.0Z
From: David <d.shuman.NOSPAM@att.net>
User-Agent: Thunderbird 2.0.0.23 (Windows/20090812)
MIME-Version: 1.0
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: 3 state checkbox question
References: <4b213572$1@forums-1-dub> <4b216c2f@forums-1-dub>
In-Reply-To: <4b216c2f@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Antivirus: avast! (VPS 091210-1, 2009/12/10), Outbound message
X-Antivirus-Status: Clean
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4b22288f$1@forums-1-dub>
Date: 11 Dec 2009 03:10:07 -0800
X-Trace: forums-1-dub 1260529807 10.22.241.152 (11 Dec 2009 03:10:07 -0800)
X-Original-Trace: 11 Dec 2009 03:10:07 -0800, vip152.sybase.com
Lines: 2
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:90428
Article PK: 410036

Thanks