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.

setnull to a column with dddw

2 posts in DataWindow Last posting was on 2008-06-04 07:33:24.0Z
MattN Posted on 2008-06-04 04:19:21.0Z
From: MattN <mjn1rar@gmailSPAM.com>
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: setnull to a column with dddw
Message-ID: <f55c44hicmgsdfutp1v60u7le4fk6sfqu8@4ax.com>
X-Newsreader: Forte Agent 4.2/32.1118
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 3 Jun 2008 21:19:21 -0700
X-Trace: forums-1-dub 1212553161 10.22.241.152 (3 Jun 2008 21:19:21 -0700)
X-Original-Trace: 3 Jun 2008 21:19:21 -0700, vip152.sybase.com
Lines: 29
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87059
Article PK: 416316

Am trying with the below code to undo a user selection if they make a
mistake. columns day1 - day31 use edit style dddw. So if a user makes
a mistake want to use a button to reverse the change.

columns day1 - day31 are type long


//clicked event of pb_3

string day, ls_ColNam
long row, nbrow
row= dw_1.getselectedrow(0)
nbrow= dw_1.rowcount()
ls_ColNam = dw_1.GetColumnName()

choose case ls_ColNam

case "day1"
setnull(day)
dw_1.Setitem(row,'day1',day)
return dw_1.event pfc_update (true,true)
dw_1.event pfc_retrieve()

case "day2"
setnull(day)
dw_1.Setitem(row,'day2',day)
return dw_1.event pfc_update (true,true)
dw_1.event pfc_retrieve()


MattN Posted on 2008-06-04 07:33:24.0Z
From: MattN <mjn1rar@gmailSPAM.com>
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: setnull to a column with dddw
Message-ID: <n9hc44d9o46uc3p8sq68he836486ssm3sb@4ax.com>
References: <f55c44hicmgsdfutp1v60u7le4fk6sfqu8@4ax.com>
X-Newsreader: Forte Agent 4.2/32.1118
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 4 Jun 2008 00:33:24 -0700
X-Trace: forums-1-dub 1212564804 10.22.241.152 (4 Jun 2008 00:33:24 -0700)
X-Original-Trace: 4 Jun 2008 00:33:24 -0700, vip152.sybase.com
Lines: 35
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87060
Article PK: 416318

Forget it resolved....

On 3 Jun 2008 21:19:21 -0700, MattN <mjn1rar@gmailSPAM.com> wrote:

>
>Am trying with the below code to undo a user selection if they make a
>mistake. columns day1 - day31 use edit style dddw. So if a user makes
>a mistake want to use a button to reverse the change.
>
>columns day1 - day31 are type long
>
>
>//clicked event of pb_3
>
>string day, ls_ColNam
>long row, nbrow
>row= dw_1.getselectedrow(0)
>nbrow= dw_1.rowcount()
>ls_ColNam = dw_1.GetColumnName()
>
>choose case ls_ColNam
>
> case "day1"
> setnull(day)
> dw_1.Setitem(row,'day1',day)
> return dw_1.event pfc_update (true,true)
> dw_1.event pfc_retrieve()
>
> case "day2"
> setnull(day)
> dw_1.Setitem(row,'day2',day)
> return dw_1.event pfc_update (true,true)
> dw_1.event pfc_retrieve()