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.

Datawindow itemchanged behaviour...

3 posts in DataWindow Last posting was on 2009-07-21 10:08:40.0Z
Alex Castillo Posted on 2009-07-17 21:59:49.0Z
From: "Alex Castillo" <a@m.com>
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Datawindow itemchanged behaviour...
Lines: 20
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: <4a60f455$2@forums-3-dub.sybase.com>
Date: 17 Jul 2009 14:59:49 -0700
X-Trace: forums-3-dub.sybase.com 1247867989 10.22.241.152 (17 Jul 2009 14:59:49 -0700)
X-Original-Trace: 17 Jul 2009 14:59:49 -0700, vip152.sybase.com
Path: forums-1-dub!forums-master!forums-3-dub.sybase.com!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89659
Article PK: 418848

Powerbuilder 7.

I have a free form Datawindow which selects only one row of data (because
the SELECT statement within its data object states a 'WHERE
IdField=:psSomeId' clause).

The Datawindow has Update Properties which allows the user to actually
change the value within the column holding the IdField (the database tables
have cascaded updates and deletes for such IdField)

Well, when the user changes the value on the IdField column, and the
ItemChanged event fires, the application executes a set of commands,
including a 'THIS.Update()', but no Update occurs... Why?

How can I handle the need of provide the user the ability to change the
IdField's column value?

Thanks..!


"Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel Posted on 2009-07-18 01:49:40.0Z
From: "Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel@yahoo!.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <4a60f455$2@forums-3-dub.sybase.com>
Subject: Re: Datawindow itemchanged behaviour...
Lines: 35
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-RFC2646: Format=Flowed; Response
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: <4a612a34$2@forums-3-dub.sybase.com>
Date: 17 Jul 2009 18:49:40 -0700
X-Trace: forums-3-dub.sybase.com 1247881780 10.22.241.152 (17 Jul 2009 18:49:40 -0700)
X-Original-Trace: 17 Jul 2009 18:49:40 -0700, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!forums-master!forums-3-dub.sybase.com!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89660
Article PK: 418847

Because ItemChanged is a misleading name. It should be ItemChanging or
EditChanged - the data from the screen is not moved to the DW Primary!
buffer until the event completes and returns 0. So, if you call Update()
within the event, you are sending the old value to the SQL, and of course it
looks like nothing happened.

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

"Alex Castillo" <a@m.com> wrote in message
news:4a60f455$2@forums-3-dub.sybase.com...
> Powerbuilder 7.
>
> I have a free form Datawindow which selects only one row of data (because
> the SELECT statement within its data object states a 'WHERE
> IdField=:psSomeId' clause).
>
> The Datawindow has Update Properties which allows the user to actually
> change the value within the column holding the IdField (the database
> tables have cascaded updates and deletes for such IdField)
>
> Well, when the user changes the value on the IdField column, and the
> ItemChanged event fires, the application executes a set of commands,
> including a 'THIS.Update()', but no Update occurs... Why?
>
> How can I handle the need of provide the user the ability to change the
> IdField's column value?
>
> Thanks..!
>


Andreas Mykonios Posted on 2009-07-21 10:08:40.0Z
From: Andreas Mykonios <Andreas Mykonios>
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: Datawindow itemchanged behaviour...
Message-ID: <jm4b65lpsfm79l6vnl44p3r425cd46lrn8@4ax.com>
References: <4a60f455$2@forums-3-dub.sybase.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: 21 Jul 2009 03:08:40 -0700
X-Trace: forums-3-dub.sybase.com 1248170920 10.22.241.152 (21 Jul 2009 03:08:40 -0700)
X-Original-Trace: 21 Jul 2009 03:08:40 -0700, vip152.sybase.com
Lines: 28
X-Authenticated-User: powerbuilder
Path: forums-1-dub!forums-master!forums-3-dub.sybase.com!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89669
Article PK: 418857


On 17 Jul 2009 14:59:49 -0700, "Alex Castillo" <a@m.com> wrote:

>Powerbuilder 7.
>
>I have a free form Datawindow which selects only one row of data (because
>the SELECT statement within its data object states a 'WHERE
>IdField=:psSomeId' clause).
>
>The Datawindow has Update Properties which allows the user to actually
>change the value within the column holding the IdField (the database tables
>have cascaded updates and deletes for such IdField)
>
>Well, when the user changes the value on the IdField column, and the
>ItemChanged event fires, the application executes a set of commands,
>including a 'THIS.Update()', but no Update occurs... Why?
>
>How can I handle the need of provide the user the ability to change the
>IdField's column value?
>
>Thanks..!
>

I would try to post call the update()...

==

Andreas Mykonios.