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.

How to pass datastore to COM/MTS component ?

5 posts in Objects Last posting was on 2002-10-16 13:35:29.0Z
Justin Posted on 2002-10-16 10:54:06.0Z
Newsgroups: sybase.public.powerbuilder.objects
From: "Justin" <justin_frm.syb.com@energisetechnology.co.uk>
Subject: How to pass datastore to COM/MTS component ?
Date: Wed, 16 Oct 2002 11:54:06 +0100
Lines: 16
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
NNTP-Posting-Host: pc3-swin2-4-cust56.oxf.cable.ntl.com 80.7.151.56
Message-ID: <364_oe0OMRQdCHA.256@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.powerbuilder.objects:862
Article PK: 713427

I'm trying to pass the contents of a datastore to a COM/MTS component from a
PB8.0.2 (9506) client.

No matter what combination of object types I try to pass, I always get an
"error calling external object function" message.

Can you point me in the direction of some working source for this ? (the
on-line help is next to useless).

I got it working from COM server to client (the client catches the resultset
as an "Any" datatype but can't get my head around going the other way.

Thanks in advance,
Justin.


De Permentier Davy Posted on 2002-10-16 11:27:14.0Z
Newsgroups: sybase.public.powerbuilder.objects
From: "De Permentier Davy" <no_spam@my.adress>
Subject: Re: How to pass datastore to COM/MTS component ?
Date: Wed, 16 Oct 2002 13:27:14 +0200
Lines: 56
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4807.1700
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4807.1700
NNTP-Posting-Host: 193.190.121.69
Message-ID: <364_Z3DtPiQdCHA.287@forums.sybase.com>
References: <364_oe0OMRQdCHA.256@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.powerbuilder.objects:861
Article PK: 713426

Hey,

Use a Blob or ResultSet to pass data (from a datastore) to the COM/MTS
component. See pbHelp for GetFullState, SetFullState, GenerateResultSet.

Just for your information, I've included a list of how PowerBuilder data
types map to COM data types. Hope this displays correctly...

HTH,
Davy

PowerBuilder data type COM data type (variants)
Boolean Variant_BOOL
Character Unsigned char
Integer Short
UnsignedInteger Unsigned short
Long Long
UnsignedLong Unsigned long
Real Float
Double Double
Decimal Double
String BSTR
Date DATE
Time DATE
DateTime DATE
Blob SAFEARRAY (Unsigned char)
Arrays (PowerBuilder data type) SAFEARRAY (COM data type)
ResultSet LPDISPATCH
Custom class user objects* LPDISPATCH
Any Not supported
Global structures Not supported
OLEObjects Not supported

"Justin" <justin_frm.syb.com@energisetechnology.co.uk> wrote in message
news:oe0OMRQdCHA.256@forums.sybase.com...
> I'm trying to pass the contents of a datastore to a COM/MTS component from
a
> PB8.0.2 (9506) client.
>
> No matter what combination of object types I try to pass, I always get an
> "error calling external object function" message.
>
> Can you point me in the direction of some working source for this ? (the
> on-line help is next to useless).
>
> I got it working from COM server to client (the client catches the
resultset
> as an "Any" datatype but can't get my head around going the other way.
>
> Thanks in advance,
> Justin.
>
>


Justin Posted on 2002-10-16 12:40:55.0Z
Newsgroups: sybase.public.powerbuilder.objects
From: "Justin" <justin_frm.syb.com@energisetechnology.co.uk>
Subject: Re: How to pass datastore to COM/MTS component ?
Date: Wed, 16 Oct 2002 13:40:55 +0100
Lines: 69
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
NNTP-Posting-Host: pc3-swin2-4-cust56.oxf.cable.ntl.com 80.7.151.56
Message-ID: <364_rgI53MRdCHA.197@forums.sybase.com>
References: <364_oe0OMRQdCHA.256@forums.sybase.com> <364_Z3DtPiQdCHA.287@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.powerbuilder.objects:859
Article PK: 713423

Thanks - I'll try passing as a blob.

I've already exhausted just about every possibility with a resultset to no
avail !

Justin.

"De Permentier Davy" <no_spam@my.adress> wrote in message
news:Z3DtPiQdCHA.287@forums.sybase.com...
> Hey,
>
> Use a Blob or ResultSet to pass data (from a datastore) to the COM/MTS
> component. See pbHelp for GetFullState, SetFullState, GenerateResultSet.
>
> Just for your information, I've included a list of how PowerBuilder data
> types map to COM data types. Hope this displays correctly...
>
> HTH,
> Davy
>
> PowerBuilder data type COM data type (variants)
> Boolean Variant_BOOL
> Character Unsigned char
> Integer Short
> UnsignedInteger Unsigned short
> Long Long
> UnsignedLong Unsigned long
> Real Float
> Double Double
> Decimal Double
> String BSTR
> Date DATE
> Time DATE
> DateTime DATE
> Blob SAFEARRAY (Unsigned char)
> Arrays (PowerBuilder data type) SAFEARRAY (COM data type)
> ResultSet LPDISPATCH
> Custom class user objects* LPDISPATCH
> Any Not supported
> Global structures Not supported
> OLEObjects Not supported
>
>
> "Justin" <justin_frm.syb.com@energisetechnology.co.uk> wrote in message
> news:oe0OMRQdCHA.256@forums.sybase.com...
> > I'm trying to pass the contents of a datastore to a COM/MTS component
from
> a
> > PB8.0.2 (9506) client.
> >
> > No matter what combination of object types I try to pass, I always get
an
> > "error calling external object function" message.
> >
> > Can you point me in the direction of some working source for this ? (the
> > on-line help is next to useless).
> >
> > I got it working from COM server to client (the client catches the
> resultset
> > as an "Any" datatype but can't get my head around going the other way.
> >
> > Thanks in advance,
> > Justin.
> >
> >
>
>


Justin Posted on 2002-10-16 13:35:29.0Z
Newsgroups: sybase.public.powerbuilder.objects
From: "Justin" <justin_frm.syb.com@energisetechnology.co.uk>
Subject: Re: How to pass datastore to COM/MTS component ?
Date: Wed, 16 Oct 2002 14:35:29 +0100
Lines: 79
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
NNTP-Posting-Host: pc3-swin2-4-cust56.oxf.cable.ntl.com 80.7.151.56
Message-ID: <364_cCBkXrRdCHA.278@forums.sybase.com>
References: <364_oe0OMRQdCHA.256@forums.sybase.com> <364_Z3DtPiQdCHA.287@forums.sybase.com> <364_rgI53MRdCHA.197@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.powerbuilder.objects:858
Article PK: 713425

Yup - passing as a blob appears to work - thanks for the lead :-)

Justin.

"Justin" <justin_frm.syb.com@energisetechnology.co.uk> wrote in message
news:rgI53MRdCHA.197@forums.sybase.com...
> Thanks - I'll try passing as a blob.
>
> I've already exhausted just about every possibility with a resultset to no
> avail !
>
> Justin.
>
> "De Permentier Davy" <no_spam@my.adress> wrote in message
> news:Z3DtPiQdCHA.287@forums.sybase.com...
> > Hey,
> >
> > Use a Blob or ResultSet to pass data (from a datastore) to the COM/MTS
> > component. See pbHelp for GetFullState, SetFullState, GenerateResultSet.
> >
> > Just for your information, I've included a list of how PowerBuilder data
> > types map to COM data types. Hope this displays correctly...
> >
> > HTH,
> > Davy
> >
> > PowerBuilder data type COM data type (variants)
> > Boolean Variant_BOOL
> > Character Unsigned char
> > Integer Short
> > UnsignedInteger Unsigned short
> > Long Long
> > UnsignedLong Unsigned long
> > Real Float
> > Double Double
> > Decimal Double
> > String BSTR
> > Date DATE
> > Time DATE
> > DateTime DATE
> > Blob SAFEARRAY (Unsigned char)
> > Arrays (PowerBuilder data type) SAFEARRAY (COM data type)
> > ResultSet LPDISPATCH
> > Custom class user objects* LPDISPATCH
> > Any Not supported
> > Global structures Not supported
> > OLEObjects Not supported
> >
> >
> > "Justin" <justin_frm.syb.com@energisetechnology.co.uk> wrote in message
> > news:oe0OMRQdCHA.256@forums.sybase.com...
> > > I'm trying to pass the contents of a datastore to a COM/MTS component
> from
> > a
> > > PB8.0.2 (9506) client.
> > >
> > > No matter what combination of object types I try to pass, I always get
> an
> > > "error calling external object function" message.
> > >
> > > Can you point me in the direction of some working source for this ?
(the
> > > on-line help is next to useless).
> > >
> > > I got it working from COM server to client (the client catches the
> > resultset
> > > as an "Any" datatype but can't get my head around going the other way.
> > >
> > > Thanks in advance,
> > > Justin.
> > >
> > >
> >
> >
>
>


De Permentier Davy Posted on 2002-10-16 11:32:48.0Z
Newsgroups: sybase.public.powerbuilder.objects
From: "De Permentier Davy" <no_spam@my.adress>
Subject: Re: How to pass datastore to COM/MTS component ?
Date: Wed, 16 Oct 2002 13:32:48 +0200
Lines: 87
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4807.1700
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4807.1700
NNTP-Posting-Host: 193.190.121.69
Message-ID: <364_6oFb4lQdCHA.197@forums.sybase.com>
References: <364_oe0OMRQdCHA.256@forums.sybase.com> <364_Z3DtPiQdCHA.287@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.powerbuilder.objects:860
Article PK: 713424

As I thought, it didn't display correctly. Here's the list again

PowerBuilder data type COM data type (variants)
Boolean Variant_BOOL
Character Unsigned char
Integer Short
UnsignedInteger Unsigned short
Long Long
UnsignedLong Unsigned long
Real Float
Double Double
Decimal Double
String BSTR
Date DATE
Time DATE
DateTime DATE
Blob SAFEARRAY (Unsigned char)
Arrays (PB data type) SAFEARRAY (COM data type)
ResultSet LPDISPATCH
Custom class user objects LPDISPATCH
Any Not supported
Global structures Not supported
OLEObjects Not supported

"De Permentier Davy" <no_spam@my.adress> wrote in message
news:Z3DtPiQdCHA.287@forums.sybase.com...
> Hey,
>
> Use a Blob or ResultSet to pass data (from a datastore) to the COM/MTS
> component. See pbHelp for GetFullState, SetFullState, GenerateResultSet.
>
> Just for your information, I've included a list of how PowerBuilder data
> types map to COM data types. Hope this displays correctly...
>
> HTH,
> Davy
>
> PowerBuilder data type COM data type (variants)
> Boolean Variant_BOOL
> Character Unsigned char
> Integer Short
> UnsignedInteger Unsigned short
> Long Long
> UnsignedLong Unsigned long
> Real Float
> Double Double
> Decimal Double
> String BSTR
> Date DATE
> Time DATE
> DateTime DATE
> Blob SAFEARRAY (Unsigned char)
> Arrays (PowerBuilder data type) SAFEARRAY (COM data type)
> ResultSet LPDISPATCH
> Custom class user objects* LPDISPATCH
> Any Not supported
> Global structures Not supported
> OLEObjects Not supported
>
>
> "Justin" <justin_frm.syb.com@energisetechnology.co.uk> wrote in message
> news:oe0OMRQdCHA.256@forums.sybase.com...
> > I'm trying to pass the contents of a datastore to a COM/MTS component
from
> a
> > PB8.0.2 (9506) client.
> >
> > No matter what combination of object types I try to pass, I always get
an
> > "error calling external object function" message.
> >
> > Can you point me in the direction of some working source for this ? (the
> > on-line help is next to useless).
> >
> > I got it working from COM server to client (the client catches the
> resultset
> > as an "Any" datatype but can't get my head around going the other way.
> >
> > Thanks in advance,
> > Justin.
> >
> >
>
>