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 in the Datawindow

3 posts in DataWindow Last posting was on 2009-03-31 16:53:42.0Z
Ben Posted on 2009-03-28 06:20:18.0Z
Sender: 2001.49cdb8ab.1804289383@sybase.com
From: Ben
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: OLE in the Datawindow
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <49cdc1a2.2127.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 27 Mar 2009 22:20:18 -0800
X-Trace: forums-1-dub 1238221218 10.22.241.41 (27 Mar 2009 22:20:18 -0800)
X-Original-Trace: 27 Mar 2009 22:20:18 -0800, 10.22.241.41
Lines: 18
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89061
Article PK: 418313

Hi gurus,
Is there any way to get a handle of the OLE control that is
defined on a BLOB column inside the datawindow? Let's say I
use OLE on a BLOB column for MS Word, then in the script, I
want to say,
OleObject loleWord
loleWord = dw_1.getTheOLEReference()
...
loleWord.Selection.TypeText(dw_1.getItemString(1,
"colname"))

That way I can keep the MS Word inside my PB app and save
the Word doc in the database, and I can populate the data
into the Word doc. Is that possible?

Thanks.

Ben


Ben Posted on 2009-03-31 16:51:19.0Z
Sender: 5078.49d24489.1804289383@sybase.com
From: Ben
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: OLE in the Datawindow
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <49d24a07.50ff.1681692777@sybase.com>
References: <49cdc1a2.2127.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 31 Mar 2009 08:51:19 -0800
X-Trace: forums-1-dub 1238518279 10.22.241.41 (31 Mar 2009 08:51:19 -0800)
X-Original-Trace: 31 Mar 2009 08:51:19 -0800, 10.22.241.41
Lines: 35
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89077
Article PK: 418329

Hi all, does anyone know if Sybase might consider doing
something like this in PB 12? I think it will be really
great if they have something like this for the dw. That RTE
control is really clumsy at best. We went out and bought the
TX Text Control before PB 11, and then PB 11 uses TX Text
Control, and the nightmare is certain things only work in
either one of them, because I heard that TX Text Control has
placed some limitations on what Sybase can do with it! I
think that is a really dumb idea. Now none of them can
satisfy my users: I can move around OK in the TX Text
Control editor automatically rather easily by using tabs and
line feeds, but I can insert data later! I can insert data
in the PB RTE control relatively easily but I cannot move
around automatically at tall because the tabs and line feeds
do not work there!

Ben

> Hi gurus,
> Is there any way to get a handle of the OLE control that
> is defined on a BLOB column inside the datawindow? Let's
> say I use OLE on a BLOB column for MS Word, then in the
> script, I want to say,
> OleObject loleWord
> loleWord = dw_1.getTheOLEReference()
> ...
> loleWord.Selection.TypeText(dw_1.getItemString(1,
> "colname"))
>
> That way I can keep the MS Word inside my PB app and save
> the Word doc in the database, and I can populate the data
> into the Word doc. Is that possible?
>
> Thanks.
>
> Ben


Ben Posted on 2009-03-31 16:53:42.0Z
Sender: 5078.49d24489.1804289383@sybase.com
From: Ben
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: OLE in the Datawindow
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <49d24a96.510e.1681692777@sybase.com>
References: <49d24a07.50ff.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 31 Mar 2009 08:53:42 -0800
X-Trace: forums-1-dub 1238518422 10.22.241.41 (31 Mar 2009 08:53:42 -0800)
X-Original-Trace: 31 Mar 2009 08:53:42 -0800, 10.22.241.41
Lines: 38
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89078
Article PK: 418330

Correction: "but I can insert data later!" should be "but I
can't insert data later!"

> Hi all, does anyone know if Sybase might consider doing
> something like this in PB 12? I think it will be really
> great if they have something like this for the dw. That
> RTE control is really clumsy at best. We went out and
> bought the TX Text Control before PB 11, and then PB 11
> uses TX Text Control, and the nightmare is certain things
> only work in either one of them, because I heard that TX
> Text Control has placed some limitations on what Sybase
> can do with it! I think that is a really dumb idea. Now
> none of them can satisfy my users: I can move around OK in
> the TX Text Control editor automatically rather easily by
> using tabs and line feeds, but I can insert data later! I
> can insert data in the PB RTE control relatively easily
> but I cannot move around automatically at tall because the
> tabs and line feeds do not work there!
>
> Ben
> > Hi gurus,
> > Is there any way to get a handle of the OLE control that
> > is defined on a BLOB column inside the datawindow? Let's
> > say I use OLE on a BLOB column for MS Word, then in the
> > script, I want to say,
> > OleObject loleWord
> > loleWord = dw_1.getTheOLEReference()
> > ...
> > loleWord.Selection.TypeText(dw_1.getItemString(1,
> > "colname"))
> >
> > That way I can keep the MS Word inside my PB app and
> > save the Word doc in the database, and I can populate
> > the data into the Word doc. Is that possible?
> >
> > Thanks.
> >
> > Ben