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.

OLE presentation style : access the activeX functions

6 posts in DataWindow Last posting was on 2009-11-26 14:14:02.0Z
O Steine Posted on 2009-11-26 10:07:47.0Z
From: "O Steine" <osteine@gmail.com>
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: OLE presentation style : access the activeX functions
Lines: 1
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
Importance: Normal
X-Newsreader: Microsoft Windows Live Mail 14.0.8089.726
X-MimeOLE: Produced By Microsoft MimeOLE V14.0.8089.726
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4b0e5373$1@forums-1-dub>
Date: 26 Nov 2009 02:07:47 -0800
X-Trace: forums-1-dub 1259230067 10.22.241.152 (26 Nov 2009 02:07:47 -0800)
X-Original-Trace: 26 Nov 2009 02:07:47 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:90346
Article PK: 409951

I use the OLE Presentation Style on a datawindow and select a ActiveX
control.

I can't seem to access the ActiveX's properties/functions and I've tried
various syntax like:

(window postopen event)

this.dw_1.object.ole_1.object.load(setting.txt)
this.dw_1.object.object.load(setting.txt)
this.dw_1.object.load(setting.txt)

None of these are successful giving a message 'Error accessing external
object'

Any ideas?


O Steine Posted on 2009-11-26 13:52:19.0Z
From: "O Steine" <osteine@gmail.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <4b0e5373$1@forums-1-dub>
In-Reply-To: <4b0e5373$1@forums-1-dub>
Subject: Re: OLE presentation style : access the activeX functions
Lines: 1
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=response
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
Importance: Normal
X-Newsreader: Microsoft Windows Live Mail 14.0.8089.726
X-MimeOLE: Produced By Microsoft MimeOLE V14.0.8089.726
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4b0e8813$1@forums-1-dub>
Date: 26 Nov 2009 05:52:19 -0800
X-Trace: forums-1-dub 1259243539 10.22.241.152 (26 Nov 2009 05:52:19 -0800)
X-Original-Trace: 26 Nov 2009 05:52:19 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:90350
Article PK: 409954

I came to think of that perhaps the reason why I can't access the ActiveX
object is that the nested report datawindow had no rows. So I added a row
using a datastore and the rowscopy function:

ls_dataobject = dw1.object.dw_ole1.dataobject
dw1.getchild( "dw_ole1", dwc)
lds_child = CREATE n_ds
lds_child.dataobject = ls_dataobject
lds_child.insertrow(0) lds_child.rowscopy(
1, 1, Primary!, dwc, 1, Primary!)

dw1.object.dw_ole1.object.ole_1.object.Load(settings.txt)

But sadly, .. nothing happens (the code runs withouth error though)


"O Steine" <osteine@gmail.com> skrev i nyhetsmeldingen:
4b0e5373$1@forums-1-dub ...

> I use the OLE Presentation Style on a datawindow and select a ActiveX
> control.
>
> I can't seem to access the ActiveX's properties/functions and I've tried
> various syntax like:
>
> (window postopen event)
>
> this.dw_1.object.ole_1.object.load(setting.txt)
> this.dw_1.object.object.load(setting.txt)
> this.dw_1.object.load(setting.txt)
>
> None of these are successful giving a message 'Error accessing external
> object'
>
> Any ideas?


Chris Pollach Posted on 2009-11-26 14:14:02.0Z
From: "Chris Pollach" <cpollach@travel-net.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <4b0e5373$1@forums-1-dub> <4b0e8813$1@forums-1-dub>
Subject: Re: OLE presentation style : access the activeX functions
Lines: 46
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5843
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: <4b0e8d2a$1@forums-1-dub>
Date: 26 Nov 2009 06:14:02 -0800
X-Trace: forums-1-dub 1259244842 10.22.241.152 (26 Nov 2009 06:14:02 -0800)
X-Original-Trace: 26 Nov 2009 06:14:02 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:90353
Article PK: 409958

Thought: How about using a separate OLE control and just write a few lines
of script to keep it positioned over the DW Control? Then you can have 100%
control over it. The only set back would be switching to Blob SQL commands
via script for the data manipulation vs using a Blob/OLE based DWO.

"O Steine" <osteine@gmail.com> wrote in message
news:4b0e8813$1@forums-1-dub...
>I came to think of that perhaps the reason why I can't access the ActiveX
>object is that the nested report datawindow had no rows. So I added a row
>using a datastore and the rowscopy function:
>
> ls_dataobject = dw1.object.dw_ole1.dataobject
> dw1.getchild( "dw_ole1", dwc)
> lds_child = CREATE n_ds
> lds_child.dataobject = ls_dataobject
> lds_child.insertrow(0) lds_child.rowscopy( 1, 1, Primary!, dwc, 1,
> Primary!)
>
> dw1.object.dw_ole1.object.ole_1.object.Load(settings.txt)
>
> But sadly, .. nothing happens (the code runs withouth error though)
>
>
> "O Steine" <osteine@gmail.com> skrev i nyhetsmeldingen:
> 4b0e5373$1@forums-1-dub ...
>> I use the OLE Presentation Style on a datawindow and select a ActiveX
>> control.
>>
>> I can't seem to access the ActiveX's properties/functions and I've tried
>> various syntax like:
>>
>> (window postopen event)
>>
>> this.dw_1.object.ole_1.object.load(setting.txt)
>> this.dw_1.object.object.load(setting.txt)
>> this.dw_1.object.load(setting.txt)
>>
>> None of these are successful giving a message 'Error accessing external
>> object'
>>
>> Any ideas?
>


Chris Pollach Posted on 2009-11-26 12:54:56.0Z
From: "Chris Pollach" <cpollach@travel-net.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <4b0e5373$1@forums-1-dub>
Subject: Re: OLE presentation style : access the activeX functions
Lines: 35
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5843
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: <4b0e7aa0$1@forums-1-dub>
Date: 26 Nov 2009 04:54:56 -0800
X-Trace: forums-1-dub 1259240096 10.22.241.152 (26 Nov 2009 04:54:56 -0800)
X-Original-Trace: 26 Nov 2009 04:54:56 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:90349
Article PK: 409956

Have you tried using PB's "Object Browser"? It can normally introspect Com
and ActiveX controls that are registered. If you see a property or method
that you fancy, use the RHMB and select "copy" to create the syntax that you
can paste back into your scripts.

HTH

--
Regards ... Chris
ISUG - NA RUG Director
Blog: http://chrispollach.pbdjmagazine.com
SourceForge: http://sourceforge.net/projects/stdfndclass

"O Steine" <osteine@gmail.com> wrote in message
news:4b0e5373$1@forums-1-dub...
>I use the OLE Presentation Style on a datawindow and select a ActiveX
>control.
>
> I can't seem to access the ActiveX's properties/functions and I've tried
> various syntax like:
>
> (window postopen event)
>
> this.dw_1.object.ole_1.object.load(setting.txt)
> this.dw_1.object.object.load(setting.txt)
> this.dw_1.object.load(setting.txt)
>
> None of these are successful giving a message 'Error accessing external
> object'
>
> Any ideas?


O Steine Posted on 2009-11-26 14:02:58.0Z
From: "O Steine" <osteine@gmail.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <4b0e5373$1@forums-1-dub> <4b0e7aa0$1@forums-1-dub>
In-Reply-To: <4b0e7aa0$1@forums-1-dub>
Subject: Re: OLE presentation style : access the activeX functions
Lines: 1
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=response
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
Importance: Normal
X-Newsreader: Microsoft Windows Live Mail 14.0.8089.726
X-MimeOLE: Produced By Microsoft MimeOLE V14.0.8089.726
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4b0e8a92@forums-1-dub>
Date: 26 Nov 2009 06:02:58 -0800
X-Trace: forums-1-dub 1259244178 10.22.241.152 (26 Nov 2009 06:02:58 -0800)
X-Original-Trace: 26 Nov 2009 06:02:58 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:90351
Article PK: 409955

No, but thanks for the tip. I wasn't aware of this browser :)

But in this case, the syntax for the ole object is correct. The problem
seems to access it while it's in a nested report.

If I create a datawindow (grid layout) and add the ActiveX Control. I can
call it with success from the window holding the datawindow control with
this syntax:

dw_1.object.ole_1.object.Load("setting.txt")

Works like a charm!

But when I use the same datawindow as a nested report in a composite
datawindow. Then I can't access the activeX.
I don't know if this is due to an error in my dot notation or that it's not
possible to access the activex control in a nested report.


"Chris Pollach" <cpollach@travel-net.com> skrev i nyhetsmeldingen:
4b0e7aa0$1@forums-1-dub ...

>
> Have you tried using PB's "Object Browser"? It can normally introspect Com
> and ActiveX controls that are registered. If you see a property or method
> that you fancy, use the RHMB and select "copy" to create the syntax that
> you can paste back into your scripts.
>
> HTH
>
> --
> Regards ... Chris
> ISUG - NA RUG Director
> Blog: http://chrispollach.pbdjmagazine.com
> SourceForge: http://sourceforge.net/projects/stdfndclass
>
>
> "O Steine" <osteine@gmail.com> wrote in message
> news:4b0e5373$1@forums-1-dub...
>>I use the OLE Presentation Style on a datawindow and select a ActiveX
>>control.
>>
>> I can't seem to access the ActiveX's properties/functions and I've tried
>> various syntax like:
>>
>> (window postopen event)
>>
>> this.dw_1.object.ole_1.object.load(setting.txt)
>> this.dw_1.object.object.load(setting.txt)
>> this.dw_1.object.load(setting.txt)
>>
>> None of these are successful giving a message 'Error accessing external
>> object'
>>
>> Any ideas?
>
>


O Steine Posted on 2009-11-26 14:05:54.0Z
From: "O Steine" <osteine@gmail.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <4b0e5373$1@forums-1-dub> <4b0e7aa0$1@forums-1-dub> <4b0e8a92@forums-1-dub>
In-Reply-To: <4b0e8a92@forums-1-dub>
Subject: Re: OLE presentation style : access the activeX functions
Lines: 1
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=response
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
Importance: Normal
X-Newsreader: Microsoft Windows Live Mail 14.0.8089.726
X-MimeOLE: Produced By Microsoft MimeOLE V14.0.8089.726
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4b0e8b42$1@forums-1-dub>
Date: 26 Nov 2009 06:05:54 -0800
X-Trace: forums-1-dub 1259244354 10.22.241.152 (26 Nov 2009 06:05:54 -0800)
X-Original-Trace: 26 Nov 2009 06:05:54 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:90352
Article PK: 409957

Ohh..Sorry..
I thought your answer was on a different (but similar) thread where my
approach was a nested report.
But again, the syntax for the ole_object is correct.

But using as a Ole presentation style .. then I can't access it



"O Steine" <osteine@gmail.com> skrev i nyhetsmeldingen:
4b0e8a92@forums-1-dub ...

> No, but thanks for the tip. I wasn't aware of this browser :)
>
> But in this case, the syntax for the ole object is correct. The problem
> seems to access it while it's in a nested report.
>
> If I create a datawindow (grid layout) and add the ActiveX Control. I can
> call it with success from the window holding the datawindow control with
> this syntax:
>
> dw_1.object.ole_1.object.Load("setting.txt")
>
> Works like a charm!
>
> But when I use the same datawindow as a nested report in a composite
> datawindow. Then I can't access the activeX.
> I don't know if this is due to an error in my dot notation or that it's
> not possible to access the activex control in a nested report.
>
>
> "Chris Pollach" <cpollach@travel-net.com> skrev i nyhetsmeldingen:
> 4b0e7aa0$1@forums-1-dub ...
>>
>> Have you tried using PB's "Object Browser"? It can normally introspect
>> Com and ActiveX controls that are registered. If you see a property or
>> method that you fancy, use the RHMB and select "copy" to create the
>> syntax that you can paste back into your scripts.
>>
>> HTH
>>
>> --
>> Regards ... Chris
>> ISUG - NA RUG Director
>> Blog: http://chrispollach.pbdjmagazine.com
>> SourceForge: http://sourceforge.net/projects/stdfndclass
>>
>>
>> "O Steine" <osteine@gmail.com> wrote in message
>> news:4b0e5373$1@forums-1-dub...
>>>I use the OLE Presentation Style on a datawindow and select a ActiveX
>>>control.
>>>
>>> I can't seem to access the ActiveX's properties/functions and I've tried
>>> various syntax like:
>>>
>>> (window postopen event)
>>>
>>> this.dw_1.object.ole_1.object.load(setting.txt)
>>> this.dw_1.object.object.load(setting.txt)
>>> this.dw_1.object.load(setting.txt)
>>>
>>> None of these are successful giving a message 'Error accessing external
>>> object'
>>>
>>> Any ideas?
>>
>>