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.

GenerateResultSet under PB 10.5.2

5 posts in DataWindow Last posting was on 2008-06-06 09:23:21.0Z
mhampton Posted on 2008-05-28 21:19:46.0Z
From: mhampton <mdhampton@gmail.com>
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: GenerateResultSet under PB 10.5.2
Date: Wed, 28 May 2008 14:19:46 -0700 (PDT)
Organization: http://groups.google.com
Lines: 13
Message-ID: <b6165ab4-42aa-4c7a-a96b-782f7efc6bbd@26g2000hsk.googlegroups.com>
NNTP-Posting-Host: 70.62.204.4
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-Trace: posting.google.com 1212009586 23732 127.0.0.1 (28 May 2008 21:19:46 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Wed, 28 May 2008 21:19:46 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: 26g2000hsk.googlegroups.com; posting-host=70.62.204.4; posting-account=1slC8woAAAA_hCZuBpZhfWINwjNAZy9w
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.14) Gecko/20080404 Firefox/2.0.0.14,gzip(gfe),gzip(gfe)
X-HTTP-Via: 1.1 clegw10.tmwsystems.com:800 (squid/2.6.STABLE17)
Path: forums-1-dub!forums-master!newssvr.sybase.com!news-sj-1.sprintlink.net!news-peer1.sprintlink.net!newsfeed.yul.equant.net!novia!novia!news-out.readnews.com!news-xxxfer.readnews.com!postnews.google.com!26g2000hsk.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:86982
Article PK: 416238

We're calling GenerateResultSet to pass an ADO Result set to a .NET
COM object. This code worked fine under PB 7, but when we recently
migrated from PB 7 to PB 10.5.2, there are some instances where our
applications dies with a Microsoft Visual C++ error of "The
application has requested the Runtime to terminate in an unusual way."
as soon as we call the COM function.

I've checked to see that GenerateResultSet returns 1 (it does), and
the line of code that fails is on the COM method call.

My guess is that somewhere in the deep bowels of PB or COM that there
is a problem marshaling something, but I currently don't know what. I
can reproduce the issue however.


Chris Pollach Posted on 2008-06-02 16:27:02.0Z
From: "Chris Pollach" <cpollach@travel-net.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <b6165ab4-42aa-4c7a-a96b-782f7efc6bbd@26g2000hsk.googlegroups.com>
Subject: Re: GenerateResultSet under PB 10.5.2
Lines: 29
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.3198
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <48441f56$1@forums-1-dub>
Date: 2 Jun 2008 09:27:02 -0700
X-Trace: forums-1-dub 1212424022 10.22.241.152 (2 Jun 2008 09:27:02 -0700)
X-Original-Trace: 2 Jun 2008 09:27:02 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87029
Article PK: 416286

FYI: The GRS ( ) method generates an ANSI standard RS - not ADO.

However, moving from PB 7 which would have made the RS in an ASCII
format, the GRS method in PB 10.x and above would precipitate a Unicode
based RS. I wonder if you need to align this for older C++ code that is not
expecting a Unicode base (just a guess)?

--
Regards ... Chris
http://chrispollach.pbdjmagazine.com

"mhampton" <mdhampton@gmail.com> wrote in message
news:b6165ab4-42aa-4c7a-a96b-782f7efc6bbd@26g2000hsk.googlegroups.com...
> We're calling GenerateResultSet to pass an ADO Result set to a .NET
> COM object. This code worked fine under PB 7, but when we recently
> migrated from PB 7 to PB 10.5.2, there are some instances where our
> applications dies with a Microsoft Visual C++ error of "The
> application has requested the Runtime to terminate in an unusual way."
> as soon as we call the COM function.
>
> I've checked to see that GenerateResultSet returns 1 (it does), and
> the line of code that fails is on the COM method call.
>
> My guess is that somewhere in the deep bowels of PB or COM that there
> is a problem marshaling something, but I currently don't know what. I
> can reproduce the issue however.


mhampton Posted on 2008-06-04 18:36:43.0Z
From: mhampton <mdhampton@gmail.com>
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: GenerateResultSet under PB 10.5.2
Date: Wed, 4 Jun 2008 11:36:43 -0700 (PDT)
Organization: http://groups.google.com
Lines: 34
Message-ID: <58ca3726-a571-4317-a28b-6fc272e8b2fa@w7g2000hsa.googlegroups.com>
References: <b6165ab4-42aa-4c7a-a96b-782f7efc6bbd@26g2000hsk.googlegroups.com> <48441f56$1@forums-1-dub>
NNTP-Posting-Host: 70.62.204.4
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-Trace: posting.google.com 1212604603 23415 127.0.0.1 (4 Jun 2008 18:36:43 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Wed, 4 Jun 2008 18:36:43 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: w7g2000hsa.googlegroups.com; posting-host=70.62.204.4; posting-account=1slC8woAAAA_hCZuBpZhfWINwjNAZy9w
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.14) Gecko/20080404 Firefox/2.0.0.14,gzip(gfe),gzip(gfe)
X-HTTP-Via: 1.1 clegw10.tmwsystems.com:800 (squid/2.6.STABLE17)
Path: forums-1-dub!forums-master!newssvr.sybase.com!news-sj-1.sprintlink.net!news-peer1.sprintlink.net!nntp1.phx1.gblx.net!nntp.gblx.net!nntp.gblx.net!border2.nntp.dca.giganews.com!nntp.giganews.com!postnews.google.com!w7g2000hsa.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87074
Article PK: 416330

The problem is, it isn't even getting to the COM object yet -- it is
dieing in PB code somewhere. And with other result sets, it works just
fine. I'm suspecting that it is choking on a null column or
something.

On Jun 2, 12:27 pm, "Chris Pollach" <cpoll...@travel-net.com> wrote:
> FYI: The GRS ( ) method generates an ANSI standard RS - not ADO.
>
> However, moving from PB 7 which would have made the RS in an ASCII
> format, the GRS method in PB 10.x and above would precipitate a Unicode
> based RS. I wonder if you need to align this for older C++ code that is not
> expecting a Unicode base (just a guess)?
>
> --
> Regards ... Chrishttp://chrispollach.pbdjmagazine.com
>
> "mhampton" <mdhamp...@gmail.com> wrote in message
>
> news:b6165ab4-42aa-4c7a-a96b-782f7efc6bbd@26g2000hsk.googlegroups.com...
>
> > We're calling GenerateResultSet to pass an ADO Result set to a .NET
> > COM object. This code worked fine under PB 7, but when we recently
> > migrated from PB 7 to PB 10.5.2, there are some instances where our
> > applications dies with a Microsoft Visual C++ error of "The
> > application has requested the Runtime to terminate in an unusual way."
> > as soon as we call the COM function.
>
> > I've checked to see that GenerateResultSet returns 1 (it does), and
> > the line of code that fails is on the COM method call.
>
> > My guess is that somewhere in the deep bowels of PB or COM that there
> > is a problem marshaling something, but I currently don't know what. I
> > can reproduce the issue however.


Chris Pollach Posted on 2008-06-05 13:31:41.0Z
From: "Chris Pollach" <cpollach@travel-net.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <b6165ab4-42aa-4c7a-a96b-782f7efc6bbd@26g2000hsk.googlegroups.com> <48441f56$1@forums-1-dub> <58ca3726-a571-4317-a28b-6fc272e8b2fa@w7g2000hsa.googlegroups.com>
Subject: Re: GenerateResultSet under PB 10.5.2
Lines: 45
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.3198
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4847eabd@forums-1-dub>
Date: 5 Jun 2008 06:31:41 -0700
X-Trace: forums-1-dub 1212672701 10.22.241.152 (5 Jun 2008 06:31:41 -0700)
X-Original-Trace: 5 Jun 2008 06:31:41 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87087
Article PK: 416344

It could be data related.
I am having no problems with the GRS ( ) in PB 10.2.1, 10.5.1 or 11.2
(FWIW) - even in EAServer NVUO's.

"mhampton" <mdhampton@gmail.com> wrote in message
news:58ca3726-a571-4317-a28b-6fc272e8b2fa@w7g2000hsa.googlegroups.com...
> The problem is, it isn't even getting to the COM object yet -- it is
> dieing in PB code somewhere. And with other result sets, it works just
> fine. I'm suspecting that it is choking on a null column or
> something.
>
> On Jun 2, 12:27 pm, "Chris Pollach" <cpoll...@travel-net.com> wrote:
>> FYI: The GRS ( ) method generates an ANSI standard RS - not ADO.
>>
>> However, moving from PB 7 which would have made the RS in an ASCII
>> format, the GRS method in PB 10.x and above would precipitate a Unicode
>> based RS. I wonder if you need to align this for older C++ code that is
>> not
>> expecting a Unicode base (just a guess)?
>>
>> --
>> Regards ... Chrishttp://chrispollach.pbdjmagazine.com
>>
>> "mhampton" <mdhamp...@gmail.com> wrote in message
>>
>> news:b6165ab4-42aa-4c7a-a96b-782f7efc6bbd@26g2000hsk.googlegroups.com...
>>
>> > We're calling GenerateResultSet to pass an ADO Result set to a .NET
>> > COM object. This code worked fine under PB 7, but when we recently
>> > migrated from PB 7 to PB 10.5.2, there are some instances where our
>> > applications dies with a Microsoft Visual C++ error of "The
>> > application has requested the Runtime to terminate in an unusual way."
>> > as soon as we call the COM function.
>>
>> > I've checked to see that GenerateResultSet returns 1 (it does), and
>> > the line of code that fails is on the COM method call.
>>
>> > My guess is that somewhere in the deep bowels of PB or COM that there
>> > is a problem marshaling something, but I currently don't know what. I
>> > can reproduce the issue however.
>


Clive Collie Posted on 2008-06-06 09:23:21.0Z
From: "Clive Collie" <clive_doesnt_like_spam@dillistone.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <b6165ab4-42aa-4c7a-a96b-782f7efc6bbd@26g2000hsk.googlegroups.com>
Subject: Re: GenerateResultSet under PB 10.5.2
Lines: 44
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.3198
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <48490209@forums-1-dub>
Date: 6 Jun 2008 02:23:21 -0700
X-Trace: forums-1-dub 1212744201 10.22.241.152 (6 Jun 2008 02:23:21 -0700)
X-Original-Trace: 6 Jun 2008 02:23:21 -0700, vip152.sybase.com
X-Authenticated-User: panorama
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87091
Article PK: 416349

You didn't post any code but here is what my code looks like. I don't pass
the object to a NET COM object class though I do pass it to another COM
object created in C++.


ll_err = dw_new.GenerateResultSet(lrs_resultset)

// Create a new ADOResultSet object and populate it
// from the generated result set
lrs_ADOresultset = CREATE ADOResultSet
ll_err = lrs_ADOresultset.SetResultSet(lrs_resultset)

// Pass the data in the ADOResultSet object
// to an OLEObject you can use as an ADO Recordset
gloo_ADOrecordset = CREATE OLEObject

ll_err = lrs_ADOresultset.GetRecordSet(gloo_ADOrecordset)

ole_object.Object.PasstheOleObject(gloo_ADOrecordset)

That creates a ADO type record set which I OK if what you pass it to likes
ADORecordsets. When talking to NET code, where it prefers ADO.NET type
recordsets, I have found that passing data to NET is best doen by assing XML
and creating a new ADO.NET object from that. I keep it simple and use
dw_new.Object.DataWindow.Data.XML

"mhampton" <mdhampton@gmail.com> wrote in message
news:b6165ab4-42aa-4c7a-a96b-782f7efc6bbd@26g2000hsk.googlegroups.com...
> We're calling GenerateResultSet to pass an ADO Result set to a .NET
> COM object. This code worked fine under PB 7, but when we recently
> migrated from PB 7 to PB 10.5.2, there are some instances where our
> applications dies with a Microsoft Visual C++ error of "The
> application has requested the Runtime to terminate in an unusual way."
> as soon as we call the COM function.
>
> I've checked to see that GenerateResultSet returns 1 (it does), and
> the line of code that fails is on the COM method call.
>
> My guess is that somewhere in the deep bowels of PB or COM that there
> is a problem marshaling something, but I currently don't know what. I
> can reproduce the issue however.