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.

PB11.5 ShareData

24 posts in DataWindow Last posting was on 2008-12-18 13:39:28.0Z
Mark Hulser Posted on 2008-12-15 15:26:12.0Z
Sender: 3521.4946706b.1804289383@sybase.com
From: Mark Hulser
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: PB11.5 ShareData
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <49467714.35df.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 15 Dec 2008 07:26:12 -0800
X-Trace: forums-1-dub 1229354772 10.22.241.41 (15 Dec 2008 07:26:12 -0800)
X-Original-Trace: 15 Dec 2008 07:26:12 -0800, 10.22.241.41
Lines: 5
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:88400
Article PK: 417654

Is there a problem with ShareData in PB 11.5? I have a
window with dw_1.ShareData(dw_2) in the Open event; I call
the Retrieve on dw_1, the data is retrieved, but then the
application crashes. If I comment out the ShareData, it
works. This works in PB 10.5.


"Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel Posted on 2008-12-15 15:38:49.0Z
From: "Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel@yahoo!.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <49467714.35df.1681692777@sybase.com>
Subject: Re: PB11.5 ShareData
Lines: 10
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: <49467a09$1@forums-1-dub>
Date: 15 Dec 2008 07:38:49 -0800
X-Trace: forums-1-dub 1229355529 10.22.241.152 (15 Dec 2008 07:38:49 -0800)
X-Original-Trace: 15 Dec 2008 07:38:49 -0800, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:88401
Article PK: 417655

AFAIK it should work. Try posting the ShareData as a workaround.

<Mark Hulser> wrote in message news:49467714.35df.1681692777@sybase.com...
> Is there a problem with ShareData in PB 11.5? I have a
> window with dw_1.ShareData(dw_2) in the Open event; I call
> the Retrieve on dw_1, the data is retrieved, but then the
> application crashes. If I comment out the ShareData, it
> works. This works in PB 10.5.


Mark Hulser Posted on 2008-12-15 16:05:14.0Z
Sender: 3521.4946706b.1804289383@sybase.com
From: Mark Hulser
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: PB11.5 ShareData
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4946803a.371d.1681692777@sybase.com>
References: <49467a09$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 15 Dec 2008 08:05:14 -0800
X-Trace: forums-1-dub 1229357114 10.22.241.41 (15 Dec 2008 08:05:14 -0800)
X-Original-Trace: 15 Dec 2008 08:05:14 -0800, 10.22.241.41
Lines: 16
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:88402
Article PK: 417657

dw_1.Post ShareData(dw_2)

didn't work.

> AFAIK it should work. Try posting the ShareData as a
> workaround.
>
> <Mark Hulser> wrote in message
> > news:49467714.35df.1681692777@sybase.com... Is there a
> > problem with ShareData in PB 11.5? I have a window with
> > dw_1.ShareData(dw_2) in the Open event; I call the
> > Retrieve on dw_1, the data is retrieved, but then the
> > application crashes. If I comment out the ShareData, it
> works. This works in PB 10.5.
>
>


"Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel Posted on 2008-12-15 16:14:38.0Z
From: "Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel@yahoo!.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <49467a09$1@forums-1-dub> <4946803a.371d.1681692777@sybase.com>
Subject: Re: PB11.5 ShareData
Lines: 24
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: <4946826e$1@forums-1-dub>
Date: 15 Dec 2008 08:14:38 -0800
X-Trace: forums-1-dub 1229357678 10.22.241.152 (15 Dec 2008 08:14:38 -0800)
X-Original-Trace: 15 Dec 2008 08:14:38 -0800, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:88404
Article PK: 417659

Is this in the IDE or the deployed app or both?
Any error message or does it just die with a Windows error?
I just tried retrieve and sharedata in the open event in my sandbox code -
worked fine.

<Mark Hulser> wrote in message news:4946803a.371d.1681692777@sybase.com...
> dw_1.Post ShareData(dw_2)
>
> didn't work.
>
>> AFAIK it should work. Try posting the ShareData as a
>> workaround.
>>
>> <Mark Hulser> wrote in message
>> > news:49467714.35df.1681692777@sybase.com... Is there a
>> > problem with ShareData in PB 11.5? I have a window with
>> > dw_1.ShareData(dw_2) in the Open event; I call the
>> > Retrieve on dw_1, the data is retrieved, but then the
>> > application crashes. If I comment out the ShareData, it
>> works. This works in PB 10.5.
>>
>>


Mark Hulser Posted on 2008-12-16 14:51:45.0Z
Sender: 3521.4946706b.1804289383@sybase.com
From: Mark Hulser
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: PB11.5 ShareData
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4947c081.539e.1681692777@sybase.com>
References: <4946826e$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 16 Dec 2008 06:51:45 -0800
X-Trace: forums-1-dub 1229439105 10.22.241.41 (16 Dec 2008 06:51:45 -0800)
X-Original-Trace: 16 Dec 2008 06:51:45 -0800, 10.22.241.41
Lines: 35
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:88411
Article PK: 417666

The crash happens when running the compiled application and
the IDE. Its a windows crash. Further - I oversimplied the
issue, its a complicated window: approx 8 datawindows
sharing the same result set; its updatable; the where clause
is added dynamically to the sql select using SetSqlSelect();
the where clause involves a temp table.

If I comment the Retrieve, the window opens. If I comment
all of the ShareDatas, the window opens. But when I try to
Retrieve with the ShareDatas, crash.

> Is this in the IDE or the deployed app or both?
> Any error message or does it just die with a Windows
> error? I just tried retrieve and sharedata in the open
> event in my sandbox code - worked fine.
>
> <Mark Hulser> wrote in message
> > news:4946803a.371d.1681692777@sybase.com... dw_1.Post
> ShareData(dw_2) >
> > didn't work.
> >
> >> AFAIK it should work. Try posting the ShareData as a
> >> workaround.
> >>
> >> <Mark Hulser> wrote in message
> >> > news:49467714.35df.1681692777@sybase.com... Is there
> a >> > problem with ShareData in PB 11.5? I have a window
> with >> > dw_1.ShareData(dw_2) in the Open event; I call
> the >> > Retrieve on dw_1, the data is retrieved, but then
> the >> > application crashes. If I comment out the
> ShareData, it >> works. This works in PB 10.5.
> >>
> >>
>
>


Chris Werner Posted on 2008-12-16 15:10:02.0Z
From: "Chris Werner" <cwAT{PleaseNoSpam}f-s.de>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <4946826e$1@forums-1-dub> <4947c081.539e.1681692777@sybase.com>
Subject: Re: PB11.5 ShareData
Lines: 49
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: <4947c4ca@forums-1-dub>
Date: 16 Dec 2008 07:10:02 -0800
X-Trace: forums-1-dub 1229440202 10.22.241.152 (16 Dec 2008 07:10:02 -0800)
X-Original-Trace: 16 Dec 2008 07:10:02 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:88412
Article PK: 417665

Hi Mark,

just a shot in the dark: When happens the setSQLSelect()?
After the shareData()? I'd try to avoid that. Could you call all
shareData() after altering the SELECT statement?

Chris Werner
f+s software gmbh


<Mark Hulser> schrieb im Newsbeitrag
news:4947c081.539e.1681692777@sybase.com...

> The crash happens when running the compiled application and
> the IDE. Its a windows crash. Further - I oversimplied the
> issue, its a complicated window: approx 8 datawindows
> sharing the same result set; its updatable; the where clause
> is added dynamically to the sql select using SetSqlSelect();
> the where clause involves a temp table.
>
> If I comment the Retrieve, the window opens. If I comment
> all of the ShareDatas, the window opens. But when I try to
> Retrieve with the ShareDatas, crash.
>
>> Is this in the IDE or the deployed app or both?
>> Any error message or does it just die with a Windows
>> error? I just tried retrieve and sharedata in the open
>> event in my sandbox code - worked fine.
>>
>> <Mark Hulser> wrote in message
>> > news:4946803a.371d.1681692777@sybase.com... dw_1.Post
>> ShareData(dw_2) >
>> > didn't work.
>> >
>> >> AFAIK it should work. Try posting the ShareData as a
>> >> workaround.
>> >>
>> >> <Mark Hulser> wrote in message
>> >> > news:49467714.35df.1681692777@sybase.com... Is there
>> a >> > problem with ShareData in PB 11.5? I have a window
>> with >> > dw_1.ShareData(dw_2) in the Open event; I call
>> the >> > Retrieve on dw_1, the data is retrieved, but then
>> the >> > application crashes. If I comment out the
>> ShareData, it >> works. This works in PB 10.5.
>> >>
>> >>
>>
>>


Mark Hulser Posted on 2008-12-16 15:31:09.0Z
Sender: 53f6.4947c36c.1804289383@sybase.com
From: Mark Hulser
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: PB11.5 ShareData
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4947c9bd.548d.1681692777@sybase.com>
References: <4947c4ca@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 16 Dec 2008 07:31:09 -0800
X-Trace: forums-1-dub 1229441469 10.22.241.41 (16 Dec 2008 07:31:09 -0800)
X-Original-Trace: 16 Dec 2008 07:31:09 -0800, 10.22.241.41
Lines: 51
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:88414
Article PK: 417668

I altered the order of things, but it made no difference.

> Hi Mark,
>
> just a shot in the dark: When happens the setSQLSelect()?
> After the shareData()? I'd try to avoid that. Could you
> call all shareData() after altering the SELECT statement?
>
> Chris Werner
> f+s software gmbh
>
>
> <Mark Hulser> schrieb im Newsbeitrag
> news:4947c081.539e.1681692777@sybase.com...
> > The crash happens when running the compiled application
> > and the IDE. Its a windows crash. Further - I
> > oversimplied the issue, its a complicated window: approx
> > 8 datawindows sharing the same result set; its updatable
> > ; the where clause is added dynamically to the sql
> > select using SetSqlSelect(); the where clause involves a
> temp table. >
> > If I comment the Retrieve, the window opens. If I
> > comment all of the ShareDatas, the window opens. But
> > when I try to Retrieve with the ShareDatas, crash.
> >
> >> Is this in the IDE or the deployed app or both?
> >> Any error message or does it just die with a Windows
> >> error? I just tried retrieve and sharedata in the open
> >> event in my sandbox code - worked fine.
> >>
> >> <Mark Hulser> wrote in message
> >> > news:4946803a.371d.1681692777@sybase.com... dw_1.Post
> >> ShareData(dw_2) >
> >> > didn't work.
> >> >
> >> >> AFAIK it should work. Try posting the ShareData as a
> >> >> workaround.
> >> >>
> >> >> <Mark Hulser> wrote in message
> >> >> > news:49467714.35df.1681692777@sybase.com... Is
> there >> a >> > problem with ShareData in PB 11.5? I have
> a window >> with >> > dw_1.ShareData(dw_2) in the Open
> event; I call >> the >> > Retrieve on dw_1, the data is
> retrieved, but then >> the >> > application crashes. If I
> comment out the >> ShareData, it >> works. This works in
> PB 10.5. >> >>
> >> >>
> >>
> >>
>
>


"Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel Posted on 2008-12-16 15:31:05.0Z
From: "Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel@yahoo!.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <4946826e$1@forums-1-dub> <4947c081.539e.1681692777@sybase.com>
Subject: Re: PB11.5 ShareData
Lines: 44
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: <4947c9b9@forums-1-dub>
Date: 16 Dec 2008 07:31:05 -0800
X-Trace: forums-1-dub 1229441465 10.22.241.152 (16 Dec 2008 07:31:05 -0800)
X-Original-Trace: 16 Dec 2008 07:31:05 -0800, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:88413
Article PK: 417667

The WHERE shouldn't matter except in the source DW, just that the result
sets match.
I'm guessing here - it sounds like something is pointing to an object that
isn't there any more: invalid memory address. Any chance that some other
code is getting in the way? Have you tried running through the debugger?

<Mark Hulser> wrote in message news:4947c081.539e.1681692777@sybase.com...
> The crash happens when running the compiled application and
> the IDE. Its a windows crash. Further - I oversimplied the
> issue, its a complicated window: approx 8 datawindows
> sharing the same result set; its updatable; the where clause
> is added dynamically to the sql select using SetSqlSelect();
> the where clause involves a temp table.
>
> If I comment the Retrieve, the window opens. If I comment
> all of the ShareDatas, the window opens. But when I try to
> Retrieve with the ShareDatas, crash.
>
>> Is this in the IDE or the deployed app or both?
>> Any error message or does it just die with a Windows
>> error? I just tried retrieve and sharedata in the open
>> event in my sandbox code - worked fine.
>>
>> <Mark Hulser> wrote in message
>> > news:4946803a.371d.1681692777@sybase.com... dw_1.Post
>> ShareData(dw_2) >
>> > didn't work.
>> >
>> >> AFAIK it should work. Try posting the ShareData as a
>> >> workaround.
>> >>
>> >> <Mark Hulser> wrote in message
>> >> > news:49467714.35df.1681692777@sybase.com... Is there
>> a >> > problem with ShareData in PB 11.5? I have a window
>> with >> > dw_1.ShareData(dw_2) in the Open event; I call
>> the >> > Retrieve on dw_1, the data is retrieved, but then
>> the >> > application crashes. If I comment out the
>> ShareData, it >> works. This works in PB 10.5.
>> >>
>> >>
>>
>>


Mark Hulser Posted on 2008-12-16 15:51:22.0Z
Sender: 53f6.4947c36c.1804289383@sybase.com
From: Mark Hulser
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: PB11.5 ShareData
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4947ce7a.54f1.1681692777@sybase.com>
References: <4947c9b9@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 16 Dec 2008 07:51:22 -0800
X-Trace: forums-1-dub 1229442682 10.22.241.41 (16 Dec 2008 07:51:22 -0800)
X-Original-Trace: 16 Dec 2008 07:51:22 -0800, 10.22.241.41
Lines: 51
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:88415
Article PK: 417669

It is an invalid memory thing, but the weird thing is it
works in 10.5.

I may have to drop back and do some major re-work.

> The WHERE shouldn't matter except in the source DW, just
> that the result sets match.
> I'm guessing here - it sounds like something is pointing
> to an object that isn't there any more: invalid memory
> address. Any chance that some other code is getting in
> the way? Have you tried running through the debugger?
>
> <Mark Hulser> wrote in message
> > news:4947c081.539e.1681692777@sybase.com... The crash
> > happens when running the compiled application and the
> > IDE. Its a windows crash. Further - I oversimplied the
> > issue, its a complicated window: approx 8 datawindows
> sharing the same result set; its updatable; the where
> > clause is added dynamically to the sql select using
> > SetSqlSelect(); the where clause involves a temp table.
> >
> > If I comment the Retrieve, the window opens. If I
> > comment all of the ShareDatas, the window opens. But
> > when I try to Retrieve with the ShareDatas, crash.
> >
> >> Is this in the IDE or the deployed app or both?
> >> Any error message or does it just die with a Windows
> >> error? I just tried retrieve and sharedata in the open
> >> event in my sandbox code - worked fine.
> >>
> >> <Mark Hulser> wrote in message
> >> > news:4946803a.371d.1681692777@sybase.com... dw_1.Post
> >> ShareData(dw_2) >
> >> > didn't work.
> >> >
> >> >> AFAIK it should work. Try posting the ShareData as a
> >> >> workaround.
> >> >>
> >> >> <Mark Hulser> wrote in message
> >> >> > news:49467714.35df.1681692777@sybase.com... Is
> there >> a >> > problem with ShareData in PB 11.5? I have
> a window >> with >> > dw_1.ShareData(dw_2) in the Open
> event; I call >> the >> > Retrieve on dw_1, the data is
> retrieved, but then >> the >> > application crashes. If I
> comment out the >> ShareData, it >> works. This works in
> PB 10.5. >> >>
> >> >>
> >>
> >>
>
>


"Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel Posted on 2008-12-16 16:31:03.0Z
From: "Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel@yahoo!.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <4947c9b9@forums-1-dub> <4947ce7a.54f1.1681692777@sybase.com>
Subject: Re: PB11.5 ShareData
Lines: 63
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: <4947d7c7$1@forums-1-dub>
Date: 16 Dec 2008 08:31:03 -0800
X-Trace: forums-1-dub 1229445063 10.22.241.152 (16 Dec 2008 08:31:03 -0800)
X-Original-Trace: 16 Dec 2008 08:31:03 -0800, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:88416
Article PK: 417670

It would not be the first time hinky code that worked in an earlier version
was caught by a tightened newer version.
The Open event is supposed to fire after all the controls in the window have
been instantiated but before it displays. I suggested the debugger to find
out which line of code is failing, or perhaps that when there is a delay
something gets a chance to happen and it doesn't fail. A common technique is
to put code into an event that is posted from Open to be sure everything is
ready to go before it runs.

<Mark Hulser> wrote in message news:4947ce7a.54f1.1681692777@sybase.com...
> It is an invalid memory thing, but the weird thing is it
> works in 10.5.
>
> I may have to drop back and do some major re-work.
>
>> The WHERE shouldn't matter except in the source DW, just
>> that the result sets match.
>> I'm guessing here - it sounds like something is pointing
>> to an object that isn't there any more: invalid memory
>> address. Any chance that some other code is getting in
>> the way? Have you tried running through the debugger?
>>
>> <Mark Hulser> wrote in message
>> > news:4947c081.539e.1681692777@sybase.com... The crash
>> > happens when running the compiled application and the
>> > IDE. Its a windows crash. Further - I oversimplied the
>> > issue, its a complicated window: approx 8 datawindows
>> sharing the same result set; its updatable; the where
>> > clause is added dynamically to the sql select using
>> > SetSqlSelect(); the where clause involves a temp table.
>> >
>> > If I comment the Retrieve, the window opens. If I
>> > comment all of the ShareDatas, the window opens. But
>> > when I try to Retrieve with the ShareDatas, crash.
>> >
>> >> Is this in the IDE or the deployed app or both?
>> >> Any error message or does it just die with a Windows
>> >> error? I just tried retrieve and sharedata in the open
>> >> event in my sandbox code - worked fine.
>> >>
>> >> <Mark Hulser> wrote in message
>> >> > news:4946803a.371d.1681692777@sybase.com... dw_1.Post
>> >> ShareData(dw_2) >
>> >> > didn't work.
>> >> >
>> >> >> AFAIK it should work. Try posting the ShareData as a
>> >> >> workaround.
>> >> >>
>> >> >> <Mark Hulser> wrote in message
>> >> >> > news:49467714.35df.1681692777@sybase.com... Is
>> there >> a >> > problem with ShareData in PB 11.5? I have
>> a window >> with >> > dw_1.ShareData(dw_2) in the Open
>> event; I call >> the >> > Retrieve on dw_1, the data is
>> retrieved, but then >> the >> > application crashes. If I
>> comment out the >> ShareData, it >> works. This works in
>> PB 10.5. >> >>
>> >> >>
>> >>
>> >>
>>
>>


Mark Hulser Posted on 2008-12-17 14:11:00.0Z
Sender: 53f6.4947c36c.1804289383@sybase.com
From: Mark Hulser
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: PB11.5 ShareData
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <49490874.7284.1681692777@sybase.com>
References: <4947d7c7$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 17 Dec 2008 06:11:00 -0800
X-Trace: forums-1-dub 1229523060 10.22.241.41 (17 Dec 2008 06:11:00 -0800)
X-Original-Trace: 17 Dec 2008 06:11:00 -0800, 10.22.241.41
Lines: 77
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:88423
Article PK: 417675

I have run it in the debugger many times; it fails on the
Retrieve(). I've looked at the objects in memory, everything
is instantiated when the Retrieve occurs. The RetrieveRow
event has script that counts the rows, and I can see the
count in Microhelp, so I know the data is retrieved. But
before the next line executes, the memory error occurs.

I have re-structured the code a little bit: the Retrieve
script is posted from the Open event; the ShareDatas are
posted from the Retrieve script. Of the 10 datawindows that
ShareData, 4 are successful, 6 are not.

> It would not be the first time hinky code that worked in
> an earlier version was caught by a tightened newer
> version. The Open event is supposed to fire after all the
> controls in the window have been instantiated but before
> it displays. I suggested the debugger to find out which
> line of code is failing, or perhaps that when there is a
> delay something gets a chance to happen and it doesn't
> fail. A common technique is to put code into an event
> that is posted from Open to be sure everything is ready
> to go before it runs.
>
> <Mark Hulser> wrote in message
> > news:4947ce7a.54f1.1681692777@sybase.com... It is an
> > invalid memory thing, but the weird thing is it works in
> 10.5. >
> > I may have to drop back and do some major re-work.
> >
> >> The WHERE shouldn't matter except in the source DW,
> just >> that the result sets match.
> >> I'm guessing here - it sounds like something is
> pointing >> to an object that isn't there any more:
> invalid memory >> address. Any chance that some other
> code is getting in >> the way? Have you tried running
> through the debugger? >>
> >> <Mark Hulser> wrote in message
> >> > news:4947c081.539e.1681692777@sybase.com... The crash
> >> > happens when running the compiled application and the
> >> > IDE. Its a windows crash. Further - I oversimplied
> the >> > issue, its a complicated window: approx 8
> datawindows >> sharing the same result set; its updatable;
> the where >> > clause is added dynamically to the sql
> select using >> > SetSqlSelect(); the where clause
> involves a temp table. >> >
> >> > If I comment the Retrieve, the window opens. If I
> >> > comment all of the ShareDatas, the window opens. But
> >> > when I try to Retrieve with the ShareDatas, crash.
> >> >
> >> >> Is this in the IDE or the deployed app or both?
> >> >> Any error message or does it just die with a Windows
> >> >> error? I just tried retrieve and sharedata in the
> open >> >> event in my sandbox code - worked fine.
> >> >>
> >> >> <Mark Hulser> wrote in message
> >> >> > news:4946803a.371d.1681692777@sybase.com...
> dw_1.Post >> >> ShareData(dw_2) >
> >> >> > didn't work.
> >> >> >
> >> >> >> AFAIK it should work. Try posting the ShareData
> as a >> >> >> workaround.
> >> >> >>
> >> >> >> <Mark Hulser> wrote in message
> >> >> >> > news:49467714.35df.1681692777@sybase.com... Is
> >> there >> a >> > problem with ShareData in PB 11.5? I
> have >> a window >> with >> > dw_1.ShareData(dw_2) in the
> Open >> event; I call >> the >> > Retrieve on dw_1, the
> data is >> retrieved, but then >> the >> > application
> crashes. If I >> comment out the >> ShareData, it >>
> works. This works in >> PB 10.5. >> >>
> >> >> >>
> >> >>
> >> >>
> >>
> >>
>
>


Chris Pollach Posted on 2008-12-17 14:14:15.0Z
From: "Chris Pollach" <cpollach@travel-net.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <4947d7c7$1@forums-1-dub> <49490874.7284.1681692777@sybase.com>
Subject: Re: PB11.5 ShareData
Lines: 92
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3350
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <49490937$1@forums-1-dub>
Date: 17 Dec 2008 06:14:15 -0800
X-Trace: forums-1-dub 1229523255 10.22.241.152 (17 Dec 2008 06:14:15 -0800)
X-Original-Trace: 17 Dec 2008 06:14:15 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:88424
Article PK: 417676

Hi Mark;

Considering the extensive amount of EBF's coming out against PB 11.5 - I
wonder if this is not just a bug. Would you be able to test your application
under PB 11.2?

--
Regards ... Chris
ISUG - NA RUG Director
http://chrispollach.pbdjmagazine.com

<Mark Hulser> wrote in message news:49490874.7284.1681692777@sybase.com...
>I have run it in the debugger many times; it fails on the
> Retrieve(). I've looked at the objects in memory, everything
> is instantiated when the Retrieve occurs. The RetrieveRow
> event has script that counts the rows, and I can see the
> count in Microhelp, so I know the data is retrieved. But
> before the next line executes, the memory error occurs.
>
> I have re-structured the code a little bit: the Retrieve
> script is posted from the Open event; the ShareDatas are
> posted from the Retrieve script. Of the 10 datawindows that
> ShareData, 4 are successful, 6 are not.
>
>> It would not be the first time hinky code that worked in
>> an earlier version was caught by a tightened newer
>> version. The Open event is supposed to fire after all the
>> controls in the window have been instantiated but before
>> it displays. I suggested the debugger to find out which
>> line of code is failing, or perhaps that when there is a
>> delay something gets a chance to happen and it doesn't
>> fail. A common technique is to put code into an event
>> that is posted from Open to be sure everything is ready
>> to go before it runs.
>>
>> <Mark Hulser> wrote in message
>> > news:4947ce7a.54f1.1681692777@sybase.com... It is an
>> > invalid memory thing, but the weird thing is it works in
>> 10.5. >
>> > I may have to drop back and do some major re-work.
>> >
>> >> The WHERE shouldn't matter except in the source DW,
>> just >> that the result sets match.
>> >> I'm guessing here - it sounds like something is
>> pointing >> to an object that isn't there any more:
>> invalid memory >> address. Any chance that some other
>> code is getting in >> the way? Have you tried running
>> through the debugger? >>
>> >> <Mark Hulser> wrote in message
>> >> > news:4947c081.539e.1681692777@sybase.com... The crash
>> >> > happens when running the compiled application and the
>> >> > IDE. Its a windows crash. Further - I oversimplied
>> the >> > issue, its a complicated window: approx 8
>> datawindows >> sharing the same result set; its updatable;
>> the where >> > clause is added dynamically to the sql
>> select using >> > SetSqlSelect(); the where clause
>> involves a temp table. >> >
>> >> > If I comment the Retrieve, the window opens. If I
>> >> > comment all of the ShareDatas, the window opens. But
>> >> > when I try to Retrieve with the ShareDatas, crash.
>> >> >
>> >> >> Is this in the IDE or the deployed app or both?
>> >> >> Any error message or does it just die with a Windows
>> >> >> error? I just tried retrieve and sharedata in the
>> open >> >> event in my sandbox code - worked fine.
>> >> >>
>> >> >> <Mark Hulser> wrote in message
>> >> >> > news:4946803a.371d.1681692777@sybase.com...
>> dw_1.Post >> >> ShareData(dw_2) >
>> >> >> > didn't work.
>> >> >> >
>> >> >> >> AFAIK it should work. Try posting the ShareData
>> as a >> >> >> workaround.
>> >> >> >>
>> >> >> >> <Mark Hulser> wrote in message
>> >> >> >> > news:49467714.35df.1681692777@sybase.com... Is
>> >> there >> a >> > problem with ShareData in PB 11.5? I
>> have >> a window >> with >> > dw_1.ShareData(dw_2) in the
>> Open >> event; I call >> the >> > Retrieve on dw_1, the
>> data is >> retrieved, but then >> the >> > application
>> crashes. If I >> comment out the >> ShareData, it >>
>> works. This works in >> PB 10.5. >> >>
>> >> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>>
>>


Mark Hulser Posted on 2008-12-17 15:44:56.0Z
Sender: 53f6.4947c36c.1804289383@sybase.com
From: Mark Hulser
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: PB11.5 ShareData
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <49491e78.743a.1681692777@sybase.com>
References: <49490937$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 17 Dec 2008 07:44:56 -0800
X-Trace: forums-1-dub 1229528696 10.22.241.41 (17 Dec 2008 07:44:56 -0800)
X-Original-Trace: 17 Dec 2008 07:44:56 -0800, 10.22.241.41
Lines: 97
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:88426
Article PK: 417679

I migrated the application from 10.5 to 11.2, tested the
issue, and I have the same problem in 11.2.

I will move forward with Sybase.

> Hi Mark;
>
> Considering the extensive amount of EBF's coming out
> against PB 11.5 - I wonder if this is not just a bug.
> Would you be able to test your application under PB 11.2?
>
> --
> Regards ... Chris
> ISUG - NA RUG Director
> http://chrispollach.pbdjmagazine.com
>
>
> <Mark Hulser> wrote in message
> news:49490874.7284.1681692777@sybase.com... >I have run it
> > in the debugger many times; it fails on the Retrieve().
> > I've looked at the objects in memory, everything is
> > instantiated when the Retrieve occurs. The RetrieveRow
> > event has script that counts the rows, and I can see the
> > count in Microhelp, so I know the data is retrieved. But
> before the next line executes, the memory error occurs. >
> > I have re-structured the code a little bit: the Retrieve
> > script is posted from the Open event; the ShareDatas are
> > posted from the Retrieve script. Of the 10 datawindows
> > that ShareData, 4 are successful, 6 are not.
> >
> >> It would not be the first time hinky code that worked
> in >> an earlier version was caught by a tightened newer
> >> version. The Open event is supposed to fire after all
> the >> controls in the window have been instantiated but
> before >> it displays. I suggested the debugger to find
> out which >> line of code is failing, or perhaps that when
> there is a >> delay something gets a chance to happen and
> it doesn't >> fail. A common technique is to put code
> into an event >> that is posted from Open to be sure
> everything is ready >> to go before it runs.
> >>
> >> <Mark Hulser> wrote in message
> >> > news:4947ce7a.54f1.1681692777@sybase.com... It is an
> >> > invalid memory thing, but the weird thing is it works
> in >> 10.5. >
> >> > I may have to drop back and do some major re-work.
> >> >
> >> >> The WHERE shouldn't matter except in the source DW,
> >> just >> that the result sets match.
> >> >> I'm guessing here - it sounds like something is
> >> pointing >> to an object that isn't there any more:
> >> invalid memory >> address. Any chance that some other
> >> code is getting in >> the way? Have you tried running
> >> through the debugger? >>
> >> >> <Mark Hulser> wrote in message
> >> >> > news:4947c081.539e.1681692777@sybase.com... The
> crash >> >> > happens when running the compiled
> application and the >> >> > IDE. Its a windows crash.
> Further - I oversimplied >> the >> > issue, its a
> complicated window: approx 8 >> datawindows >> sharing the
> same result set; its updatable; >> the where >> > clause
> is added dynamically to the sql >> select using >> >
> SetSqlSelect(); the where clause >> involves a temp table.
> >> > >> >> > If I comment the Retrieve, the window opens.
> If I >> >> > comment all of the ShareDatas, the window
> opens. But >> >> > when I try to Retrieve with the
> ShareDatas, crash. >> >> >
> >> >> >> Is this in the IDE or the deployed app or both?
> >> >> >> Any error message or does it just die with a
> Windows >> >> >> error? I just tried retrieve and
> sharedata in the >> open >> >> event in my sandbox code -
> worked fine. >> >> >>
> >> >> >> <Mark Hulser> wrote in message
> >> >> >> > news:4946803a.371d.1681692777@sybase.com...
> >> dw_1.Post >> >> ShareData(dw_2) >
> >> >> >> > didn't work.
> >> >> >> >
> >> >> >> >> AFAIK it should work. Try posting the
> ShareData >> as a >> >> >> workaround.
> >> >> >> >>
> >> >> >> >> <Mark Hulser> wrote in message
> >> >> >> >> > news:49467714.35df.1681692777@sybase.com...
> Is >> >> there >> a >> > problem with ShareData in PB
> 11.5? I >> have >> a window >> with >> >
> dw_1.ShareData(dw_2) in the >> Open >> event; I call >>
> the >> > Retrieve on dw_1, the >> data is >> retrieved,
> but then >> the >> > application >> crashes. If I >>
> comment out the >> ShareData, it >> >> works. This works
> in >> PB 10.5. >> >> >> >> >> >>
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >>
> >>
>
>


Chris Pollach Posted on 2008-12-17 16:00:45.0Z
From: "Chris Pollach" <cpollach@travel-net.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <49490937$1@forums-1-dub> <49491e78.743a.1681692777@sybase.com>
Subject: Re: PB11.5 ShareData
Lines: 115
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3350
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4949222d$1@forums-1-dub>
Date: 17 Dec 2008 08:00:45 -0800
X-Trace: forums-1-dub 1229529645 10.22.241.152 (17 Dec 2008 08:00:45 -0800)
X-Original-Trace: 17 Dec 2008 08:00:45 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:88427
Article PK: 417681

Good idea.

In the mean time, can you look at the DW objects affected using the
Source Code edit mode and check to see if the header in the SRD file says
"release 11.5;"? If not, try changing that - save the source - then
regenerate your application (or at least your affected DWO's) and then
retry.

--
Regards ... Chris
ISUG - NA RUG Director
http://chrispollach.pbdjmagazine.com

<Mark Hulser> wrote in message news:49491e78.743a.1681692777@sybase.com...
>I migrated the application from 10.5 to 11.2, tested the
> issue, and I have the same problem in 11.2.
>
> I will move forward with Sybase.
>
>> Hi Mark;
>>
>> Considering the extensive amount of EBF's coming out
>> against PB 11.5 - I wonder if this is not just a bug.
>> Would you be able to test your application under PB 11.2?
>>
>> --
>> Regards ... Chris
>> ISUG - NA RUG Director
>> http://chrispollach.pbdjmagazine.com
>>
>>
>> <Mark Hulser> wrote in message
>> news:49490874.7284.1681692777@sybase.com... >I have run it
>> > in the debugger many times; it fails on the Retrieve().
>> > I've looked at the objects in memory, everything is
>> > instantiated when the Retrieve occurs. The RetrieveRow
>> > event has script that counts the rows, and I can see the
>> > count in Microhelp, so I know the data is retrieved. But
>> before the next line executes, the memory error occurs. >
>> > I have re-structured the code a little bit: the Retrieve
>> > script is posted from the Open event; the ShareDatas are
>> > posted from the Retrieve script. Of the 10 datawindows
>> > that ShareData, 4 are successful, 6 are not.
>> >
>> >> It would not be the first time hinky code that worked
>> in >> an earlier version was caught by a tightened newer
>> >> version. The Open event is supposed to fire after all
>> the >> controls in the window have been instantiated but
>> before >> it displays. I suggested the debugger to find
>> out which >> line of code is failing, or perhaps that when
>> there is a >> delay something gets a chance to happen and
>> it doesn't >> fail. A common technique is to put code
>> into an event >> that is posted from Open to be sure
>> everything is ready >> to go before it runs.
>> >>
>> >> <Mark Hulser> wrote in message
>> >> > news:4947ce7a.54f1.1681692777@sybase.com... It is an
>> >> > invalid memory thing, but the weird thing is it works
>> in >> 10.5. >
>> >> > I may have to drop back and do some major re-work.
>> >> >
>> >> >> The WHERE shouldn't matter except in the source DW,
>> >> just >> that the result sets match.
>> >> >> I'm guessing here - it sounds like something is
>> >> pointing >> to an object that isn't there any more:
>> >> invalid memory >> address. Any chance that some other
>> >> code is getting in >> the way? Have you tried running
>> >> through the debugger? >>
>> >> >> <Mark Hulser> wrote in message
>> >> >> > news:4947c081.539e.1681692777@sybase.com... The
>> crash >> >> > happens when running the compiled
>> application and the >> >> > IDE. Its a windows crash.
>> Further - I oversimplied >> the >> > issue, its a
>> complicated window: approx 8 >> datawindows >> sharing the
>> same result set; its updatable; >> the where >> > clause
>> is added dynamically to the sql >> select using >> >
>> SetSqlSelect(); the where clause >> involves a temp table.
>> >> > >> >> > If I comment the Retrieve, the window opens.
>> If I >> >> > comment all of the ShareDatas, the window
>> opens. But >> >> > when I try to Retrieve with the
>> ShareDatas, crash. >> >> >
>> >> >> >> Is this in the IDE or the deployed app or both?
>> >> >> >> Any error message or does it just die with a
>> Windows >> >> >> error? I just tried retrieve and
>> sharedata in the >> open >> >> event in my sandbox code -
>> worked fine. >> >> >>
>> >> >> >> <Mark Hulser> wrote in message
>> >> >> >> > news:4946803a.371d.1681692777@sybase.com...
>> >> dw_1.Post >> >> ShareData(dw_2) >
>> >> >> >> > didn't work.
>> >> >> >> >
>> >> >> >> >> AFAIK it should work. Try posting the
>> ShareData >> as a >> >> >> workaround.
>> >> >> >> >>
>> >> >> >> >> <Mark Hulser> wrote in message
>> >> >> >> >> > news:49467714.35df.1681692777@sybase.com...
>> Is >> >> there >> a >> > problem with ShareData in PB
>> 11.5? I >> have >> a window >> with >> >
>> dw_1.ShareData(dw_2) in the >> Open >> event; I call >>
>> the >> > Retrieve on dw_1, the >> data is >> retrieved,
>> but then >> the >> > application >> crashes. If I >>
>> comment out the >> ShareData, it >> >> works. This works
>> in >> PB 10.5. >> >> >> >> >> >>
>> >> >> >>
>> >> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>>
>>


Mark Hulser Posted on 2008-12-17 16:33:17.0Z
Sender: 53f6.4947c36c.1804289383@sybase.com
From: Mark Hulser
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: PB11.5 ShareData
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <494929cd.7580.1681692777@sybase.com>
References: <4949222d$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 17 Dec 2008 08:33:17 -0800
X-Trace: forums-1-dub 1229531597 10.22.241.41 (17 Dec 2008 08:33:17 -0800)
X-Original-Trace: 17 Dec 2008 08:33:17 -0800, 10.22.241.41
Lines: 120
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:88428
Article PK: 417682

Good suggestion - I hadn't thought of that - but it didn't
work. They all had "release 10.5" which I changed to
"release 11.5", imported the source, regenerated entire app
- still the same problem.

> Good idea.
>
> In the mean time, can you look at the DW objects
> affected using the Source Code edit mode and check to see
> if the header in the SRD file says "release 11.5;"? If
> not, try changing that - save the source - then
> regenerate your application (or at least your affected
> DWO's) and then retry.
>
> --
> Regards ... Chris
> ISUG - NA RUG Director
> http://chrispollach.pbdjmagazine.com
>
>
> <Mark Hulser> wrote in message
> news:49491e78.743a.1681692777@sybase.com... >I migrated
> > the application from 10.5 to 11.2, tested the issue, and
> I have the same problem in 11.2. >
> > I will move forward with Sybase.
> >
> >> Hi Mark;
> >>
> >> Considering the extensive amount of EBF's coming
> out >> against PB 11.5 - I wonder if this is not just a
> bug. >> Would you be able to test your application under
> PB 11.2? >>
> >> --
> >> Regards ... Chris
> >> ISUG - NA RUG Director
> >> http://chrispollach.pbdjmagazine.com
> >>
> >>
> >> <Mark Hulser> wrote in message
> >> news:49490874.7284.1681692777@sybase.com... >I have run
> it >> > in the debugger many times; it fails on the
> Retrieve(). >> > I've looked at the objects in memory,
> everything is >> > instantiated when the Retrieve occurs.
> The RetrieveRow >> > event has script that counts the rows
> , and I can see the >> > count in Microhelp, so I know the
> data is retrieved. But >> before the next line executes,
> the memory error occurs. > >> > I have re-structured the
> code a little bit: the Retrieve >> > script is posted from
> the Open event; the ShareDatas are >> > posted from the
> Retrieve script. Of the 10 datawindows >> > that ShareData
> , 4 are successful, 6 are not. >> >
> >> >> It would not be the first time hinky code that
> worked >> in >> an earlier version was caught by a
> tightened newer >> >> version. The Open event is supposed
> to fire after all >> the >> controls in the window have
> been instantiated but >> before >> it displays. I
> suggested the debugger to find >> out which >> line of
> code is failing, or perhaps that when >> there is a >>
> delay something gets a chance to happen and >> it doesn't
> >> fail. A common technique is to put code >> into an
> event >> that is posted from Open to be sure >> everything
> is ready >> to go before it runs. >> >>
> >> >> <Mark Hulser> wrote in message
> >> >> > news:4947ce7a.54f1.1681692777@sybase.com... It is
> an >> >> > invalid memory thing, but the weird thing is it
> works >> in >> 10.5. >
> >> >> > I may have to drop back and do some major re-work.
> >> >> >
> >> >> >> The WHERE shouldn't matter except in the source
> DW, >> >> just >> that the result sets match.
> >> >> >> I'm guessing here - it sounds like something is
> >> >> pointing >> to an object that isn't there any more:
> >> >> invalid memory >> address. Any chance that some
> other >> >> code is getting in >> the way? Have you tried
> running >> >> through the debugger? >>
> >> >> >> <Mark Hulser> wrote in message
> >> >> >> > news:4947c081.539e.1681692777@sybase.com... The
> >> crash >> >> > happens when running the compiled
> >> application and the >> >> > IDE. Its a windows crash.
> >> Further - I oversimplied >> the >> > issue, its a
> >> complicated window: approx 8 >> datawindows >> sharing
> the >> same result set; its updatable; >> the where >> >
> clause >> is added dynamically to the sql >> select using
> >> > >> SetSqlSelect(); the where clause >> involves a
> temp table. >> >> > >> >> > If I comment the Retrieve, the
> window opens. >> If I >> >> > comment all of the
> ShareDatas, the window >> opens. But >> >> > when I try to
> Retrieve with the >> ShareDatas, crash. >> >> >
> >> >> >> >> Is this in the IDE or the deployed app or
> both? >> >> >> >> Any error message or does it just die
> with a >> Windows >> >> >> error? I just tried retrieve
> and >> sharedata in the >> open >> >> event in my sandbox
> code - >> worked fine. >> >> >>
> >> >> >> >> <Mark Hulser> wrote in message
> >> >> >> >> > news:4946803a.371d.1681692777@sybase.com...
> >> >> dw_1.Post >> >> ShareData(dw_2) >
> >> >> >> >> > didn't work.
> >> >> >> >> >
> >> >> >> >> >> AFAIK it should work. Try posting the
> >> ShareData >> as a >> >> >> workaround.
> >> >> >> >> >>
> >> >> >> >> >> <Mark Hulser> wrote in message
> >> >> >> >> >> >
> news:49467714.35df.1681692777@sybase.com... >> Is >> >>
> there >> a >> > problem with ShareData in PB >> 11.5? I >>
> have >> a window >> with >> > >> dw_1.ShareData(dw_2) in
> the >> Open >> event; I call >> >> the >> > Retrieve on
> dw_1, the >> data is >> retrieved, >> but then >> the >> >
> application >> crashes. If I >> >> comment out the >>
> ShareData, it >> >> works. This works >> in >> PB 10.5. >>
> >> >> >> >> >> >> >> >> >>
> >> >> >> >>
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >>
> >>
>
>


Bruce Armstrong [TeamSybase] Posted on 2008-12-17 18:16:39.0Z
From: "Bruce Armstrong [TeamSybase]" <NOCANSPAM_bruce.armstrong@teamsybase.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <4947d7c7$1@forums-1-dub> <49490874.7284.1681692777@sybase.com> <49490937$1@forums-1-dub>
Subject: Re: PB11.5 ShareData
Lines: 109
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: <49494207$1@forums-1-dub>
Date: 17 Dec 2008 10:16:39 -0800
X-Trace: forums-1-dub 1229537799 10.22.241.152 (17 Dec 2008 10:16:39 -0800)
X-Original-Trace: 17 Dec 2008 10:16:39 -0800, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:88430
Article PK: 417683

Chris. What the @#$%^& are you talking about? The publically released EBFs
so far this year (and the dates released) are:

11.5 10/29

11.2 11/26 9/10 5/28

11.1 11/17 1/2

10.5.1 9/15 6/24 4/21 3/17 2/5

"Chris Pollach" <cpollach@travel-net.com> wrote in message
news:49490937$1@forums-1-dub...
> Hi Mark;
>
> Considering the extensive amount of EBF's coming out against PB 11.5 -
> I wonder if this is not just a bug. Would you be able to test your
> application under PB 11.2?
>
> --
> Regards ... Chris
> ISUG - NA RUG Director
> http://chrispollach.pbdjmagazine.com
>
>
> <Mark Hulser> wrote in message news:49490874.7284.1681692777@sybase.com...
>>I have run it in the debugger many times; it fails on the
>> Retrieve(). I've looked at the objects in memory, everything
>> is instantiated when the Retrieve occurs. The RetrieveRow
>> event has script that counts the rows, and I can see the
>> count in Microhelp, so I know the data is retrieved. But
>> before the next line executes, the memory error occurs.
>>
>> I have re-structured the code a little bit: the Retrieve
>> script is posted from the Open event; the ShareDatas are
>> posted from the Retrieve script. Of the 10 datawindows that
>> ShareData, 4 are successful, 6 are not.
>>
>>> It would not be the first time hinky code that worked in
>>> an earlier version was caught by a tightened newer
>>> version. The Open event is supposed to fire after all the
>>> controls in the window have been instantiated but before
>>> it displays. I suggested the debugger to find out which
>>> line of code is failing, or perhaps that when there is a
>>> delay something gets a chance to happen and it doesn't
>>> fail. A common technique is to put code into an event
>>> that is posted from Open to be sure everything is ready
>>> to go before it runs.
>>>
>>> <Mark Hulser> wrote in message
>>> > news:4947ce7a.54f1.1681692777@sybase.com... It is an
>>> > invalid memory thing, but the weird thing is it works in
>>> 10.5. >
>>> > I may have to drop back and do some major re-work.
>>> >
>>> >> The WHERE shouldn't matter except in the source DW,
>>> just >> that the result sets match.
>>> >> I'm guessing here - it sounds like something is
>>> pointing >> to an object that isn't there any more:
>>> invalid memory >> address. Any chance that some other
>>> code is getting in >> the way? Have you tried running
>>> through the debugger? >>
>>> >> <Mark Hulser> wrote in message
>>> >> > news:4947c081.539e.1681692777@sybase.com... The crash
>>> >> > happens when running the compiled application and the
>>> >> > IDE. Its a windows crash. Further - I oversimplied
>>> the >> > issue, its a complicated window: approx 8
>>> datawindows >> sharing the same result set; its updatable;
>>> the where >> > clause is added dynamically to the sql
>>> select using >> > SetSqlSelect(); the where clause
>>> involves a temp table. >> >
>>> >> > If I comment the Retrieve, the window opens. If I
>>> >> > comment all of the ShareDatas, the window opens. But
>>> >> > when I try to Retrieve with the ShareDatas, crash.
>>> >> >
>>> >> >> Is this in the IDE or the deployed app or both?
>>> >> >> Any error message or does it just die with a Windows
>>> >> >> error? I just tried retrieve and sharedata in the
>>> open >> >> event in my sandbox code - worked fine.
>>> >> >>
>>> >> >> <Mark Hulser> wrote in message
>>> >> >> > news:4946803a.371d.1681692777@sybase.com...
>>> dw_1.Post >> >> ShareData(dw_2) >
>>> >> >> > didn't work.
>>> >> >> >
>>> >> >> >> AFAIK it should work. Try posting the ShareData
>>> as a >> >> >> workaround.
>>> >> >> >>
>>> >> >> >> <Mark Hulser> wrote in message
>>> >> >> >> > news:49467714.35df.1681692777@sybase.com... Is
>>> >> there >> a >> > problem with ShareData in PB 11.5? I
>>> have >> a window >> with >> > dw_1.ShareData(dw_2) in the
>>> Open >> event; I call >> the >> > Retrieve on dw_1, the
>>> data is >> retrieved, but then >> the >> > application
>>> crashes. If I >> comment out the >> ShareData, it >>
>>> works. This works in >> PB 10.5. >> >>
>>> >> >> >>
>>> >> >>
>>> >> >>
>>> >>
>>> >>
>>>
>>>
>
>


Chris Pollach Posted on 2008-12-17 18:23:27.0Z
From: "Chris Pollach" <cpollach@travel-net.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <4947d7c7$1@forums-1-dub> <49490874.7284.1681692777@sybase.com> <49490937$1@forums-1-dub> <49494207$1@forums-1-dub>
Subject: Re: PB11.5 ShareData
Lines: 121
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3350
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4949439f$1@forums-1-dub>
Date: 17 Dec 2008 10:23:27 -0800
X-Trace: forums-1-dub 1229538207 10.22.241.152 (17 Dec 2008 10:23:27 -0800)
X-Original-Trace: 17 Dec 2008 10:23:27 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:88431
Article PK: 417685

Exactly .. since he is having the same problem with 11.2 and between the two
there have been 4 EBF releases - If these EBF's did not resolve his problem
then it seems to me that it is more likely to be a current bug. Thus,
opening a case with Sybase would seem to be prudent IMHO.


"Bruce Armstrong [TeamSybase]" <NOCANSPAM_bruce.armstrong@teamsybase.com>

wrote in message news:49494207$1@forums-1-dub...
>
> Chris. What the @#$%^& are you talking about? The publically released
> EBFs so far this year (and the dates released) are:
>
> 11.5 10/29
>
> 11.2 11/26 9/10 5/28
>
> 11.1 11/17 1/2
>
> 10.5.1 9/15 6/24 4/21 3/17 2/5
>
>
> "Chris Pollach" <cpollach@travel-net.com> wrote in message
> news:49490937$1@forums-1-dub...
>> Hi Mark;
>>
>> Considering the extensive amount of EBF's coming out against PB 11.5 -
>> I wonder if this is not just a bug. Would you be able to test your
>> application under PB 11.2?
>>
>> --
>> Regards ... Chris
>> ISUG - NA RUG Director
>> http://chrispollach.pbdjmagazine.com
>>
>>
>> <Mark Hulser> wrote in message
>> news:49490874.7284.1681692777@sybase.com...
>>>I have run it in the debugger many times; it fails on the
>>> Retrieve(). I've looked at the objects in memory, everything
>>> is instantiated when the Retrieve occurs. The RetrieveRow
>>> event has script that counts the rows, and I can see the
>>> count in Microhelp, so I know the data is retrieved. But
>>> before the next line executes, the memory error occurs.
>>>
>>> I have re-structured the code a little bit: the Retrieve
>>> script is posted from the Open event; the ShareDatas are
>>> posted from the Retrieve script. Of the 10 datawindows that
>>> ShareData, 4 are successful, 6 are not.
>>>
>>>> It would not be the first time hinky code that worked in
>>>> an earlier version was caught by a tightened newer
>>>> version. The Open event is supposed to fire after all the
>>>> controls in the window have been instantiated but before
>>>> it displays. I suggested the debugger to find out which
>>>> line of code is failing, or perhaps that when there is a
>>>> delay something gets a chance to happen and it doesn't
>>>> fail. A common technique is to put code into an event
>>>> that is posted from Open to be sure everything is ready
>>>> to go before it runs.
>>>>
>>>> <Mark Hulser> wrote in message
>>>> > news:4947ce7a.54f1.1681692777@sybase.com... It is an
>>>> > invalid memory thing, but the weird thing is it works in
>>>> 10.5. >
>>>> > I may have to drop back and do some major re-work.
>>>> >
>>>> >> The WHERE shouldn't matter except in the source DW,
>>>> just >> that the result sets match.
>>>> >> I'm guessing here - it sounds like something is
>>>> pointing >> to an object that isn't there any more:
>>>> invalid memory >> address. Any chance that some other
>>>> code is getting in >> the way? Have you tried running
>>>> through the debugger? >>
>>>> >> <Mark Hulser> wrote in message
>>>> >> > news:4947c081.539e.1681692777@sybase.com... The crash
>>>> >> > happens when running the compiled application and the
>>>> >> > IDE. Its a windows crash. Further - I oversimplied
>>>> the >> > issue, its a complicated window: approx 8
>>>> datawindows >> sharing the same result set; its updatable;
>>>> the where >> > clause is added dynamically to the sql
>>>> select using >> > SetSqlSelect(); the where clause
>>>> involves a temp table. >> >
>>>> >> > If I comment the Retrieve, the window opens. If I
>>>> >> > comment all of the ShareDatas, the window opens. But
>>>> >> > when I try to Retrieve with the ShareDatas, crash.
>>>> >> >
>>>> >> >> Is this in the IDE or the deployed app or both?
>>>> >> >> Any error message or does it just die with a Windows
>>>> >> >> error? I just tried retrieve and sharedata in the
>>>> open >> >> event in my sandbox code - worked fine.
>>>> >> >>
>>>> >> >> <Mark Hulser> wrote in message
>>>> >> >> > news:4946803a.371d.1681692777@sybase.com...
>>>> dw_1.Post >> >> ShareData(dw_2) >
>>>> >> >> > didn't work.
>>>> >> >> >
>>>> >> >> >> AFAIK it should work. Try posting the ShareData
>>>> as a >> >> >> workaround.
>>>> >> >> >>
>>>> >> >> >> <Mark Hulser> wrote in message
>>>> >> >> >> > news:49467714.35df.1681692777@sybase.com... Is
>>>> >> there >> a >> > problem with ShareData in PB 11.5? I
>>>> have >> a window >> with >> > dw_1.ShareData(dw_2) in the
>>>> Open >> event; I call >> the >> > Retrieve on dw_1, the
>>>> data is >> retrieved, but then >> the >> > application
>>>> crashes. If I >> comment out the >> ShareData, it >>
>>>> works. This works in >> PB 10.5. >> >>
>>>> >> >> >>
>>>> >> >>
>>>> >> >>
>>>> >>
>>>> >>
>>>>
>>>>
>>
>>
>
>


Mark Hulser Posted on 2008-12-17 18:36:32.0Z
Sender: 53f6.4947c36c.1804289383@sybase.com
From: Mark Hulser
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: PB11.5 ShareData
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <494946b0.787a.1681692777@sybase.com>
References: <4949439f$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 17 Dec 2008 10:36:32 -0800
X-Trace: forums-1-dub 1229538992 10.22.241.41 (17 Dec 2008 10:36:32 -0800)
X-Original-Trace: 17 Dec 2008 10:36:32 -0800, 10.22.241.41
Lines: 131
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:88432
Article PK: 417686

For 11.5, I'm using Build 3050 (the latest).

For 11.2, I have Build 8047; I didn't think it necessary to
download and apply all the bug fixes for 11.2 since I don't
use it.

I took this app from 10.5.1 (6021) to 11.5; I skipped 11.0,
11.1, and 11.2.

> Exactly .. since he is having the same problem with 11.2
> and between the two there have been 4 EBF releases - If
> these EBF's did not resolve his problem then it seems to
> me that it is more likely to be a current bug. Thus,
> opening a case with Sybase would seem to be prudent IMHO.
>
>
> "Bruce Armstrong [TeamSybase]"
> <NOCANSPAM_bruce.armstrong@teamsybase.com> wrote in
> message news:49494207$1@forums-1-dub... >
> > Chris. What the @#$%^& are you talking about? The
> > publically released EBFs so far this year (and the
> dates released) are: >
> > 11.5 10/29
> >
> > 11.2 11/26 9/10 5/28
> >
> > 11.1 11/17 1/2
> >
> > 10.5.1 9/15 6/24 4/21 3/17 2/5
> >
> >
> > "Chris Pollach" <cpollach@travel-net.com> wrote in
> > message news:49490937$1@forums-1-dub...
> >> Hi Mark;
> >>
> >> Considering the extensive amount of EBF's coming out
> against PB 11.5 - >> I wonder if this is not just a bug.
> Would you be able to test your >> application under PB
> 11.2? >>
> >> --
> >> Regards ... Chris
> >> ISUG - NA RUG Director
> >> http://chrispollach.pbdjmagazine.com
> >>
> >>
> >> <Mark Hulser> wrote in message
> >> news:49490874.7284.1681692777@sybase.com...
> >>>I have run it in the debugger many times; it fails on
> the >>> Retrieve(). I've looked at the objects in memory,
> everything >>> is instantiated when the Retrieve occurs.
> The RetrieveRow >>> event has script that counts the rows,
> and I can see the >>> count in Microhelp, so I know the
> data is retrieved. But >>> before the next line executes,
> the memory error occurs. >>>
> >>> I have re-structured the code a little bit: the
> Retrieve >>> script is posted from the Open event; the
> ShareDatas are >>> posted from the Retrieve script. Of the
> 10 datawindows that >>> ShareData, 4 are successful, 6 are
> not. >>>
> >>>> It would not be the first time hinky code that worked
> in >>>> an earlier version was caught by a tightened
> newer >>>> version. The Open event is supposed to fire
> after all the >>>> controls in the window have been
> instantiated but before >>>> it displays. I suggested the
> debugger to find out which >>>> line of code is failing,
> or perhaps that when there is a >>>> delay something gets
> a chance to happen and it doesn't >>>> fail. A common
> technique is to put code into an event >>>> that is
> posted from Open to be sure everything is ready >>>> to
> go before it runs. >>>>
> >>>> <Mark Hulser> wrote in message
> >>>> > news:4947ce7a.54f1.1681692777@sybase.com... It is
> an >>>> > invalid memory thing, but the weird thing is it
> works in >>>> 10.5. >
> >>>> > I may have to drop back and do some major re-work.
> >>>> >
> >>>> >> The WHERE shouldn't matter except in the source DW
> , >>>> just >> that the result sets match.
> >>>> >> I'm guessing here - it sounds like something is
> >>>> pointing >> to an object that isn't there any more:
> >>>> invalid memory >> address. Any chance that some other
> >>>> code is getting in >> the way? Have you tried running
> >>>> through the debugger? >>
> >>>> >> <Mark Hulser> wrote in message
> >>>> >> > news:4947c081.539e.1681692777@sybase.com... The
> crash >>>> >> > happens when running the compiled
> application and the >>>> >> > IDE. Its a windows crash.
> Further - I oversimplied >>>> the >> > issue, its a
> complicated window: approx 8 >>>> datawindows >> sharing
> the same result set; its updatable; >>>> the where >> >
> clause is added dynamically to the sql >>>> select using
> >> > SetSqlSelect(); the where clause >>>> involves a temp
> table. >> > >>>> >> > If I comment the Retrieve, the
> window opens. If I >>>> >> > comment all of the ShareDatas
> , the window opens. But >>>> >> > when I try to Retrieve
> with the ShareDatas, crash. >>>> >> >
> >>>> >> >> Is this in the IDE or the deployed app or both?
> >>>> >> >> Any error message or does it just die with a
> Windows >>>> >> >> error? I just tried retrieve and
> sharedata in the >>>> open >> >> event in my sandbox code
> - worked fine. >>>> >> >>
> >>>> >> >> <Mark Hulser> wrote in message
> >>>> >> >> > news:4946803a.371d.1681692777@sybase.com...
> >>>> dw_1.Post >> >> ShareData(dw_2) >
> >>>> >> >> > didn't work.
> >>>> >> >> >
> >>>> >> >> >> AFAIK it should work. Try posting the
> ShareData >>>> as a >> >> >> workaround.
> >>>> >> >> >>
> >>>> >> >> >> <Mark Hulser> wrote in message
> >>>> >> >> >> >
> news:49467714.35df.1681692777@sybase.com... Is >>>> >>
> there >> a >> > problem with ShareData in PB 11.5? I >>>>
> have >> a window >> with >> > dw_1.ShareData(dw_2) in the
> >>>> Open >> event; I call >> the >> > Retrieve on dw_1,
> the >>>> data is >> retrieved, but then >> the >> >
> application >>>> crashes. If I >> comment out the >>
> ShareData, it >> >>>> works. This works in >> PB 10.5. >>
> >> >>>> >> >> >>
> >>>> >> >>
> >>>> >> >>
> >>>> >>
> >>>> >>
> >>>>
> >>>>
> >>
> >>
> >
> >
>
>


Chris Pollach Posted on 2008-12-18 13:39:28.0Z
From: "Chris Pollach" <cpollach@travel-net.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <4949439f$1@forums-1-dub> <494946b0.787a.1681692777@sybase.com>
Subject: Re: PB11.5 ShareData
Lines: 147
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3350
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <494a5290$1@forums-1-dub>
Date: 18 Dec 2008 05:39:28 -0800
X-Trace: forums-1-dub 1229607568 10.22.241.152 (18 Dec 2008 05:39:28 -0800)
X-Original-Trace: 18 Dec 2008 05:39:28 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:88446
Article PK: 417705

Sounds like you have found a unique situation. I was on the Beta for
11.5 and am currently using applications under 11.2/11.5 utilizing the
ShareData feature with no problems. I keep thinking that your problem is
unique to the DWO's that you are using that may no have been migrated
properly. This being said, I know that it can be a frustrating and time
consuming process to discover the exact reason for the failure.

You mentioned before that ... "Of the 10 DataWindows that ShareData, 4
are successful, 6 are not". So I am now wondering what particular aspect is
different about the 4 that cause the problem?

<Mark Hulser> wrote in message news:494946b0.787a.1681692777@sybase.com...
> For 11.5, I'm using Build 3050 (the latest).
>
> For 11.2, I have Build 8047; I didn't think it necessary to
> download and apply all the bug fixes for 11.2 since I don't
> use it.
>
> I took this app from 10.5.1 (6021) to 11.5; I skipped 11.0,
> 11.1, and 11.2.
>
>> Exactly .. since he is having the same problem with 11.2
>> and between the two there have been 4 EBF releases - If
>> these EBF's did not resolve his problem then it seems to
>> me that it is more likely to be a current bug. Thus,
>> opening a case with Sybase would seem to be prudent IMHO.
>>
>>
>> "Bruce Armstrong [TeamSybase]"
>> <NOCANSPAM_bruce.armstrong@teamsybase.com> wrote in
>> message news:49494207$1@forums-1-dub... >
>> > Chris. What the @#$%^& are you talking about? The
>> > publically released EBFs so far this year (and the
>> dates released) are: >
>> > 11.5 10/29
>> >
>> > 11.2 11/26 9/10 5/28
>> >
>> > 11.1 11/17 1/2
>> >
>> > 10.5.1 9/15 6/24 4/21 3/17 2/5
>> >
>> >
>> > "Chris Pollach" <cpollach@travel-net.com> wrote in
>> > message news:49490937$1@forums-1-dub...
>> >> Hi Mark;
>> >>
>> >> Considering the extensive amount of EBF's coming out
>> against PB 11.5 - >> I wonder if this is not just a bug.
>> Would you be able to test your >> application under PB
>> 11.2? >>
>> >> --
>> >> Regards ... Chris
>> >> ISUG - NA RUG Director
>> >> http://chrispollach.pbdjmagazine.com
>> >>
>> >>
>> >> <Mark Hulser> wrote in message
>> >> news:49490874.7284.1681692777@sybase.com...
>> >>>I have run it in the debugger many times; it fails on
>> the >>> Retrieve(). I've looked at the objects in memory,
>> everything >>> is instantiated when the Retrieve occurs.
>> The RetrieveRow >>> event has script that counts the rows,
>> and I can see the >>> count in Microhelp, so I know the
>> data is retrieved. But >>> before the next line executes,
>> the memory error occurs. >>>
>> >>> I have re-structured the code a little bit: the
>> Retrieve >>> script is posted from the Open event; the
>> ShareDatas are >>> posted from the Retrieve script. Of the
>> 10 datawindows that >>> ShareData, 4 are successful, 6 are
>> not. >>>
>> >>>> It would not be the first time hinky code that worked
>> in >>>> an earlier version was caught by a tightened
>> newer >>>> version. The Open event is supposed to fire
>> after all the >>>> controls in the window have been
>> instantiated but before >>>> it displays. I suggested the
>> debugger to find out which >>>> line of code is failing,
>> or perhaps that when there is a >>>> delay something gets
>> a chance to happen and it doesn't >>>> fail. A common
>> technique is to put code into an event >>>> that is
>> posted from Open to be sure everything is ready >>>> to
>> go before it runs. >>>>
>> >>>> <Mark Hulser> wrote in message
>> >>>> > news:4947ce7a.54f1.1681692777@sybase.com... It is
>> an >>>> > invalid memory thing, but the weird thing is it
>> works in >>>> 10.5. >
>> >>>> > I may have to drop back and do some major re-work.
>> >>>> >
>> >>>> >> The WHERE shouldn't matter except in the source DW
>> , >>>> just >> that the result sets match.
>> >>>> >> I'm guessing here - it sounds like something is
>> >>>> pointing >> to an object that isn't there any more:
>> >>>> invalid memory >> address. Any chance that some other
>> >>>> code is getting in >> the way? Have you tried running
>> >>>> through the debugger? >>
>> >>>> >> <Mark Hulser> wrote in message
>> >>>> >> > news:4947c081.539e.1681692777@sybase.com... The
>> crash >>>> >> > happens when running the compiled
>> application and the >>>> >> > IDE. Its a windows crash.
>> Further - I oversimplied >>>> the >> > issue, its a
>> complicated window: approx 8 >>>> datawindows >> sharing
>> the same result set; its updatable; >>>> the where >> >
>> clause is added dynamically to the sql >>>> select using
>> >> > SetSqlSelect(); the where clause >>>> involves a temp
>> table. >> > >>>> >> > If I comment the Retrieve, the
>> window opens. If I >>>> >> > comment all of the ShareDatas
>> , the window opens. But >>>> >> > when I try to Retrieve
>> with the ShareDatas, crash. >>>> >> >
>> >>>> >> >> Is this in the IDE or the deployed app or both?
>> >>>> >> >> Any error message or does it just die with a
>> Windows >>>> >> >> error? I just tried retrieve and
>> sharedata in the >>>> open >> >> event in my sandbox code
>> - worked fine. >>>> >> >>
>> >>>> >> >> <Mark Hulser> wrote in message
>> >>>> >> >> > news:4946803a.371d.1681692777@sybase.com...
>> >>>> dw_1.Post >> >> ShareData(dw_2) >
>> >>>> >> >> > didn't work.
>> >>>> >> >> >
>> >>>> >> >> >> AFAIK it should work. Try posting the
>> ShareData >>>> as a >> >> >> workaround.
>> >>>> >> >> >>
>> >>>> >> >> >> <Mark Hulser> wrote in message
>> >>>> >> >> >> >
>> news:49467714.35df.1681692777@sybase.com... Is >>>> >>
>> there >> a >> > problem with ShareData in PB 11.5? I >>>>
>> have >> a window >> with >> > dw_1.ShareData(dw_2) in the
>> >>>> Open >> event; I call >> the >> > Retrieve on dw_1,
>> the >>>> data is >> retrieved, but then >> the >> >
>> application >>>> crashes. If I >> comment out the >>
>> ShareData, it >> >>>> works. This works in >> PB 10.5. >>
>> >> >>>> >> >> >>
>> >>>> >> >>
>> >>>> >> >>
>> >>>> >>
>> >>>> >>
>> >>>>
>> >>>>
>> >>
>> >>
>> >
>> >
>>
>>


Bruce Armstrong [TeamSybase] Posted on 2008-12-17 20:02:51.0Z
From: "Bruce Armstrong [TeamSybase]" <NOCANSPAM_bruce.armstrong@teamsybase.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <4947d7c7$1@forums-1-dub> <49490874.7284.1681692777@sybase.com> <49490937$1@forums-1-dub> <49494207$1@forums-1-dub> <4949439f$1@forums-1-dub>
Subject: Re: PB11.5 ShareData
Lines: 129
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; Response
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <49495aeb$1@forums-1-dub>
Date: 17 Dec 2008 12:02:51 -0800
X-Trace: forums-1-dub 1229544171 10.22.241.152 (17 Dec 2008 12:02:51 -0800)
X-Original-Trace: 17 Dec 2008 12:02:51 -0800, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:88435
Article PK: 417690

There has been 1, count them 1, published EBF for 11.5 since it was
released. The other EBFs are for other versions.

"Chris Pollach" <cpollach@travel-net.com> wrote in message
news:4949439f$1@forums-1-dub...
>
> Exactly .. since he is having the same problem with 11.2 and between the
> two there have been 4 EBF releases - If these EBF's did not resolve his
> problem then it seems to me that it is more likely to be a current bug.
> Thus, opening a case with Sybase would seem to be prudent IMHO.
>
>
> "Bruce Armstrong [TeamSybase]" <NOCANSPAM_bruce.armstrong@teamsybase.com>
> wrote in message news:49494207$1@forums-1-dub...
>>
>> Chris. What the @#$%^& are you talking about? The publically released
>> EBFs so far this year (and the dates released) are:
>>
>> 11.5 10/29
>>
>> 11.2 11/26 9/10 5/28
>>
>> 11.1 11/17 1/2
>>
>> 10.5.1 9/15 6/24 4/21 3/17 2/5
>>
>>
>> "Chris Pollach" <cpollach@travel-net.com> wrote in message
>> news:49490937$1@forums-1-dub...
>>> Hi Mark;
>>>
>>> Considering the extensive amount of EBF's coming out against PB
>>> 11.5 - I wonder if this is not just a bug. Would you be able to test
>>> your application under PB 11.2?
>>>
>>> --
>>> Regards ... Chris
>>> ISUG - NA RUG Director
>>> http://chrispollach.pbdjmagazine.com
>>>
>>>
>>> <Mark Hulser> wrote in message
>>> news:49490874.7284.1681692777@sybase.com...
>>>>I have run it in the debugger many times; it fails on the
>>>> Retrieve(). I've looked at the objects in memory, everything
>>>> is instantiated when the Retrieve occurs. The RetrieveRow
>>>> event has script that counts the rows, and I can see the
>>>> count in Microhelp, so I know the data is retrieved. But
>>>> before the next line executes, the memory error occurs.
>>>>
>>>> I have re-structured the code a little bit: the Retrieve
>>>> script is posted from the Open event; the ShareDatas are
>>>> posted from the Retrieve script. Of the 10 datawindows that
>>>> ShareData, 4 are successful, 6 are not.
>>>>
>>>>> It would not be the first time hinky code that worked in
>>>>> an earlier version was caught by a tightened newer
>>>>> version. The Open event is supposed to fire after all the
>>>>> controls in the window have been instantiated but before
>>>>> it displays. I suggested the debugger to find out which
>>>>> line of code is failing, or perhaps that when there is a
>>>>> delay something gets a chance to happen and it doesn't
>>>>> fail. A common technique is to put code into an event
>>>>> that is posted from Open to be sure everything is ready
>>>>> to go before it runs.
>>>>>
>>>>> <Mark Hulser> wrote in message
>>>>> > news:4947ce7a.54f1.1681692777@sybase.com... It is an
>>>>> > invalid memory thing, but the weird thing is it works in
>>>>> 10.5. >
>>>>> > I may have to drop back and do some major re-work.
>>>>> >
>>>>> >> The WHERE shouldn't matter except in the source DW,
>>>>> just >> that the result sets match.
>>>>> >> I'm guessing here - it sounds like something is
>>>>> pointing >> to an object that isn't there any more:
>>>>> invalid memory >> address. Any chance that some other
>>>>> code is getting in >> the way? Have you tried running
>>>>> through the debugger? >>
>>>>> >> <Mark Hulser> wrote in message
>>>>> >> > news:4947c081.539e.1681692777@sybase.com... The crash
>>>>> >> > happens when running the compiled application and the
>>>>> >> > IDE. Its a windows crash. Further - I oversimplied
>>>>> the >> > issue, its a complicated window: approx 8
>>>>> datawindows >> sharing the same result set; its updatable;
>>>>> the where >> > clause is added dynamically to the sql
>>>>> select using >> > SetSqlSelect(); the where clause
>>>>> involves a temp table. >> >
>>>>> >> > If I comment the Retrieve, the window opens. If I
>>>>> >> > comment all of the ShareDatas, the window opens. But
>>>>> >> > when I try to Retrieve with the ShareDatas, crash.
>>>>> >> >
>>>>> >> >> Is this in the IDE or the deployed app or both?
>>>>> >> >> Any error message or does it just die with a Windows
>>>>> >> >> error? I just tried retrieve and sharedata in the
>>>>> open >> >> event in my sandbox code - worked fine.
>>>>> >> >>
>>>>> >> >> <Mark Hulser> wrote in message
>>>>> >> >> > news:4946803a.371d.1681692777@sybase.com...
>>>>> dw_1.Post >> >> ShareData(dw_2) >
>>>>> >> >> > didn't work.
>>>>> >> >> >
>>>>> >> >> >> AFAIK it should work. Try posting the ShareData
>>>>> as a >> >> >> workaround.
>>>>> >> >> >>
>>>>> >> >> >> <Mark Hulser> wrote in message
>>>>> >> >> >> > news:49467714.35df.1681692777@sybase.com... Is
>>>>> >> there >> a >> > problem with ShareData in PB 11.5? I
>>>>> have >> a window >> with >> > dw_1.ShareData(dw_2) in the
>>>>> Open >> event; I call >> the >> > Retrieve on dw_1, the
>>>>> data is >> retrieved, but then >> the >> > application
>>>>> crashes. If I >> comment out the >> ShareData, it >>
>>>>> works. This works in >> PB 10.5. >> >>
>>>>> >> >> >>
>>>>> >> >>
>>>>> >> >>
>>>>> >>
>>>>> >>
>>>>>
>>>>>
>>>
>>>
>>
>>
>
>


"Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel Posted on 2008-12-17 14:24:40.0Z
From: "Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel@yahoo!.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <4947d7c7$1@forums-1-dub> <49490874.7284.1681692777@sybase.com>
Subject: Re: PB11.5 ShareData
Lines: 86
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: <49490ba8$1@forums-1-dub>
Date: 17 Dec 2008 06:24:40 -0800
X-Trace: forums-1-dub 1229523880 10.22.241.152 (17 Dec 2008 06:24:40 -0800)
X-Original-Trace: 17 Dec 2008 06:24:40 -0800, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:88425
Article PK: 417678

The debugger is intrusive, so it is <guess type="wild">possible</guess> that
it induces a delay that allows slow instantiations to catch up. Nevertheless
this sure sounds like a bug. I'd check the fix lists for the EBFs that are
currently out, or maybe just try the latest one. If that doesn't fix it you
will need to open a case with Sybase.

<Mark Hulser> wrote in message news:49490874.7284.1681692777@sybase.com...
>I have run it in the debugger many times; it fails on the
> Retrieve(). I've looked at the objects in memory, everything
> is instantiated when the Retrieve occurs. The RetrieveRow
> event has script that counts the rows, and I can see the
> count in Microhelp, so I know the data is retrieved. But
> before the next line executes, the memory error occurs.
>
> I have re-structured the code a little bit: the Retrieve
> script is posted from the Open event; the ShareDatas are
> posted from the Retrieve script. Of the 10 datawindows that
> ShareData, 4 are successful, 6 are not.
>
>> It would not be the first time hinky code that worked in
>> an earlier version was caught by a tightened newer
>> version. The Open event is supposed to fire after all the
>> controls in the window have been instantiated but before
>> it displays. I suggested the debugger to find out which
>> line of code is failing, or perhaps that when there is a
>> delay something gets a chance to happen and it doesn't
>> fail. A common technique is to put code into an event
>> that is posted from Open to be sure everything is ready
>> to go before it runs.
>>
>> <Mark Hulser> wrote in message
>> > news:4947ce7a.54f1.1681692777@sybase.com... It is an
>> > invalid memory thing, but the weird thing is it works in
>> 10.5. >
>> > I may have to drop back and do some major re-work.
>> >
>> >> The WHERE shouldn't matter except in the source DW,
>> just >> that the result sets match.
>> >> I'm guessing here - it sounds like something is
>> pointing >> to an object that isn't there any more:
>> invalid memory >> address. Any chance that some other
>> code is getting in >> the way? Have you tried running
>> through the debugger? >>
>> >> <Mark Hulser> wrote in message
>> >> > news:4947c081.539e.1681692777@sybase.com... The crash
>> >> > happens when running the compiled application and the
>> >> > IDE. Its a windows crash. Further - I oversimplied
>> the >> > issue, its a complicated window: approx 8
>> datawindows >> sharing the same result set; its updatable;
>> the where >> > clause is added dynamically to the sql
>> select using >> > SetSqlSelect(); the where clause
>> involves a temp table. >> >
>> >> > If I comment the Retrieve, the window opens. If I
>> >> > comment all of the ShareDatas, the window opens. But
>> >> > when I try to Retrieve with the ShareDatas, crash.
>> >> >
>> >> >> Is this in the IDE or the deployed app or both?
>> >> >> Any error message or does it just die with a Windows
>> >> >> error? I just tried retrieve and sharedata in the
>> open >> >> event in my sandbox code - worked fine.
>> >> >>
>> >> >> <Mark Hulser> wrote in message
>> >> >> > news:4946803a.371d.1681692777@sybase.com...
>> dw_1.Post >> >> ShareData(dw_2) >
>> >> >> > didn't work.
>> >> >> >
>> >> >> >> AFAIK it should work. Try posting the ShareData
>> as a >> >> >> workaround.
>> >> >> >>
>> >> >> >> <Mark Hulser> wrote in message
>> >> >> >> > news:49467714.35df.1681692777@sybase.com... Is
>> >> there >> a >> > problem with ShareData in PB 11.5? I
>> have >> a window >> with >> > dw_1.ShareData(dw_2) in the
>> Open >> event; I call >> the >> > Retrieve on dw_1, the
>> data is >> retrieved, but then >> the >> > application
>> crashes. If I >> comment out the >> ShareData, it >>
>> works. This works in >> PB 10.5. >> >>
>> >> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>>
>>


"Jason 'Bug' Fenter [TeamSybase]" <NO_SPAMMING_jason.fenter_ Posted on 2008-12-17 18:52:32.0Z
From: "Jason 'Bug' Fenter [TeamSybase]" <NO_SPAMMING_jason.fenter_@_teamsybase.com>
User-Agent: Thunderbird 2.0.0.18 (Windows/20081105)
MIME-Version: 1.0
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: PB11.5 ShareData
References: <4947c9b9@forums-1-dub> <4947ce7a.54f1.1681692777@sybase.com>
In-Reply-To: <4947ce7a.54f1.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <49494a70$1@forums-1-dub>
Date: 17 Dec 2008 10:52:32 -0800
X-Trace: forums-1-dub 1229539952 10.22.241.152 (17 Dec 2008 10:52:32 -0800)
X-Original-Trace: 17 Dec 2008 10:52:32 -0800, vip152.sybase.com
Lines: 58
X-Authenticated-User: teamsybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:88433
Article PK: 417687

PMJI, but did you go through the datawindows to make sure that the
column specifications match exactly? I'm wondering if you have a column
defined as a decimal in one DW and a number in another... or some other
such slight quirk as that.

Also, how much data is getting shared? About 100k? About 100m?

Mark Hulser wrote:
> It is an invalid memory thing, but the weird thing is it
> works in 10.5.
>
> I may have to drop back and do some major re-work.
>
>> The WHERE shouldn't matter except in the source DW, just
>> that the result sets match.
>> I'm guessing here - it sounds like something is pointing
>> to an object that isn't there any more: invalid memory
>> address. Any chance that some other code is getting in
>> the way? Have you tried running through the debugger?
>>
>> <Mark Hulser> wrote in message
>>> news:4947c081.539e.1681692777@sybase.com... The crash
>>> happens when running the compiled application and the
>>> IDE. Its a windows crash. Further - I oversimplied the
>>> issue, its a complicated window: approx 8 datawindows
>> sharing the same result set; its updatable; the where
>>> clause is added dynamically to the sql select using
>>> SetSqlSelect(); the where clause involves a temp table.
>>>
>>> If I comment the Retrieve, the window opens. If I
>>> comment all of the ShareDatas, the window opens. But
>>> when I try to Retrieve with the ShareDatas, crash.
>>>
>>>> Is this in the IDE or the deployed app or both?
>>>> Any error message or does it just die with a Windows
>>>> error? I just tried retrieve and sharedata in the open
>>>> event in my sandbox code - worked fine.
>>>>
>>>> <Mark Hulser> wrote in message
>>>>> news:4946803a.371d.1681692777@sybase.com... dw_1.Post
>>>> ShareData(dw_2) >
>>>>> didn't work.
>>>>>
>>>>>> AFAIK it should work. Try posting the ShareData as a
>>>>>> workaround.
>>>>>>
>>>>>> <Mark Hulser> wrote in message
>>>>>>> news:49467714.35df.1681692777@sybase.com... Is
>> there >> a >> > problem with ShareData in PB 11.5? I have
>> a window >> with >> > dw_1.ShareData(dw_2) in the Open
>> event; I call >> the >> > Retrieve on dw_1, the data is
>> retrieved, but then >> the >> > application crashes. If I
>> comment out the >> ShareData, it >> works. This works in
>> PB 10.5. >> >>
>>>>
>>


Mark Hulser Posted on 2008-12-17 20:54:01.0Z
Sender: 53f6.4947c36c.1804289383@sybase.com
From: Mark Hulser
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: PB11.5 ShareData
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <494966e9.7c17.1681692777@sybase.com>
References: <49494a70$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 17 Dec 2008 12:54:01 -0800
X-Trace: forums-1-dub 1229547241 10.22.241.41 (17 Dec 2008 12:54:01 -0800)
X-Original-Trace: 17 Dec 2008 12:54:01 -0800, 10.22.241.41
Lines: 68
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:88436
Article PK: 417689

The last thing to happen to these datawindows was the 11.5
migration; so the result sets should not have changed. But
just to make sure, I compared the main datawindow with one
of the problem datawindows, and they are identical.

Its 163 columns; the amount of data that I'm retrieving from
my test database is most likely less than 1mb.

> PMJI, but did you go through the datawindows to make sure
> that the column specifications match exactly? I'm
> wondering if you have a column defined as a decimal in
> one DW and a number in another... or some other such
> slight quirk as that.
>
> Also, how much data is getting shared? About 100k? About
> 100m?
>
>
>
> Mark Hulser wrote:
> > It is an invalid memory thing, but the weird thing is it
> > works in 10.5.
> >
> > I may have to drop back and do some major re-work.
> >
> >> The WHERE shouldn't matter except in the source DW,
> just >> that the result sets match.
> >> I'm guessing here - it sounds like something is
> pointing >> to an object that isn't there any more:
> invalid memory >> address. Any chance that some other
> code is getting in >> the way? Have you tried running
> through the debugger? >>
> >> <Mark Hulser> wrote in message
> >>> news:4947c081.539e.1681692777@sybase.com... The crash
> >>> happens when running the compiled application and the
> >>> IDE. Its a windows crash. Further - I oversimplied
> the >>> issue, its a complicated window: approx 8
> datawindows >> sharing the same result set; its updatable;
> the where >>> clause is added dynamically to the sql
> select using >>> SetSqlSelect(); the where clause involves
> a temp table. >>>
> >>> If I comment the Retrieve, the window opens. If I
> >>> comment all of the ShareDatas, the window opens. But
> >>> when I try to Retrieve with the ShareDatas, crash.
> >>>
> >>>> Is this in the IDE or the deployed app or both?
> >>>> Any error message or does it just die with a Windows
> >>>> error? I just tried retrieve and sharedata in the
> open >>>> event in my sandbox code - worked fine.
> >>>>
> >>>> <Mark Hulser> wrote in message
> >>>>> news:4946803a.371d.1681692777@sybase.com...
> dw_1.Post >>>> ShareData(dw_2) >
> >>>>> didn't work.
> >>>>>
> >>>>>> AFAIK it should work. Try posting the ShareData as
> a >>>>>> workaround.
> >>>>>>
> >>>>>> <Mark Hulser> wrote in message
> >>>>>>> news:49467714.35df.1681692777@sybase.com... Is
> >> there >> a >> > problem with ShareData in PB 11.5? I
> have >> a window >> with >> > dw_1.ShareData(dw_2) in the
> Open >> event; I call >> the >> > Retrieve on dw_1, the
> data is >> retrieved, but then >> the >> > application
> crashes. If I >> comment out the >> ShareData, it >>
> works. This works in >> PB 10.5. >> >>
> >>>>
> >>