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.

image display in datawindow - inkcontrol or new 12.5 image tableblob control

6 posts in Appeon (partner product) Last posting was on 2012-07-24 11:36:25.0Z
Mike S Posted on 2012-07-21 17:18:20.0Z
From: "Mike S" <M@M.com>
Subject: image display in datawindow - inkcontrol or new 12.5 image tableblob control
Newsgroups: sybase.public.appeon
User-Agent: XanaNews/1.18.1.6
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <500ae45c$1@forums-1-dub>
Date: 21 Jul 2012 10:18:20 -0700
X-Trace: forums-1-dub 1342891100 172.20.134.152 (21 Jul 2012 10:18:20 -0700)
X-Original-Trace: 21 Jul 2012 10:18:20 -0700, vip152.sybase.com
Lines: 16
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:3007
Article PK: 13698

I need to print and display images in a datawindow report (signatures,
pictures, etc). Many pages, many rows, each row can have different
image.

I dont'think the current version of appeon supports the inkcontrol or
the new 12.5 tableblob that can display images?


Other than downloading all unique pictures on the report rows, saving
them to unique files names, then doing a setitem on all rows to display
them as pictures, is there a way to do this like powerbuilder can?



--


Chris Pollach Posted on 2012-07-23 12:35:58.0Z
From: Chris Pollach <cpollach@travel-net.com>
User-Agent: Mozilla/5.0 (Windows NT 5.1; rv:14.0) Gecko/20120713 Thunderbird/14.0
MIME-Version: 1.0
Newsgroups: sybase.public.appeon
Subject: Re: image display in datawindow - inkcontrol or new 12.5 image tableblob control
References: <500ae45c$1@forums-1-dub>
In-Reply-To: <500ae45c$1@forums-1-dub>
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: <500d452e$1@forums-1-dub>
Date: 23 Jul 2012 05:35:58 -0700
X-Trace: forums-1-dub 1343046958 172.20.134.152 (23 Jul 2012 05:35:58 -0700)
X-Original-Trace: 23 Jul 2012 05:35:58 -0700, vip152.sybase.com
Lines: 42
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:3009
Article PK: 13699

Hi Mike;

Unfortunately, the InkEdit and InkPicture controls are not supported.
I was hoping that they were as well and the documentation does not say
one way or another - but, my official query into engineering was "NO". :-(

FWIW: What I do is use ImageMagicK and/or GraphicsMagicK to convert
the images to a common supported format. Then I use the normal DWO with
the "Display As Picture" property set or the Picture Control to display
the converted images. A bit of the "pain-in-the-rear" but it is workable.

FYI: I have not heard of any plans to support these controls - but
IMHO I think that would be a *great* suggestion. I would encourage you
to add this to the Appeon enhancement requests at
http://my.isug.com/p/cm/ld?fid=187


--
Regards ... Chris
President: OSUG / STD Inc.
Vice President: ISUG
Blog: http://chrispollach.blogspot.com
SourceForge: http://sourceforge.net/projects/stdfndclass
PBDJ: http://chrispollach.sys-con.com

On 7/21/2012 1:18 PM, Mike S wrote:
> I need to print and display images in a datawindow report (signatures,
> pictures, etc). Many pages, many rows, each row can have different
> image.
>
> I dont'think the current version of appeon supports the inkcontrol or
> the new 12.5 tableblob that can display images?
>
>
> Other than downloading all unique pictures on the report rows, saving
> them to unique files names, then doing a setitem on all rows to display
> them as pictures, is there a way to do this like powerbuilder can?
>
>
>


Mike S Posted on 2012-07-23 14:43:36.0Z
From: "Mike S" <M@M.com>
Subject: Re: image display in datawindow - inkcontrol or new 12.5 image tableblobcontrol
Newsgroups: sybase.public.appeon
References: <500ae45c$1@forums-1-dub> <500d452e$1@forums-1-dub>
User-Agent: XanaNews/1.18.1.6
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <500d6318$1@forums-1-dub>
Date: 23 Jul 2012 07:43:36 -0700
X-Trace: forums-1-dub 1343054616 172.20.134.152 (23 Jul 2012 07:43:36 -0700)
X-Original-Trace: 23 Jul 2012 07:43:36 -0700, vip152.sybase.com
Lines: 32
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:3010
Article PK: 21996

are you saying you download the images to temp files, and then set the
dwo filename column to the temp file name on all of the rows?

i think that is what i will have to do, unless they add this to their
next release.

Chris Pollach wrote:

>
> Hi Mike;
>
> Unfortunately, the InkEdit and InkPicture controls are not supported.
> I was hoping that they were as well and the documentation does not
> say one way or another - but, my official query into engineering was
> "NO". :-(
>
> FWIW: What I do is use ImageMagicK and/or GraphicsMagicK to convert
> the images to a common supported format. Then I use the normal DWO
> with the "Display As Picture" property set or the Picture Control to
> display the converted images. A bit of the "pain-in-the-rear" but it
> is workable.
>
> FYI: I have not heard of any plans to support these controls - but
> IMHO I think that would be a great suggestion. I would encourage you
> to add this to the Appeon enhancement requests at
> http://my.isug.com/p/cm/ld?fid=187

--


Chris Pollach Posted on 2012-07-23 15:18:24.0Z
From: Chris Pollach <cpollach@travel-net.com>
User-Agent: Mozilla/5.0 (Windows NT 5.1; rv:14.0) Gecko/20120713 Thunderbird/14.0
MIME-Version: 1.0
Newsgroups: sybase.public.appeon
Subject: Re: image display in datawindow - inkcontrol or new 12.5 image tableblobcontrol
References: <500ae45c$1@forums-1-dub> <500d452e$1@forums-1-dub> <500d6318$1@forums-1-dub>
In-Reply-To: <500d6318$1@forums-1-dub>
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: <500d6b40$1@forums-1-dub>
Date: 23 Jul 2012 08:18:24 -0700
X-Trace: forums-1-dub 1343056704 172.20.134.152 (23 Jul 2012 08:18:24 -0700)
X-Original-Trace: 23 Jul 2012 08:18:24 -0700, vip152.sybase.com
Lines: 44
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:3011
Article PK: 13700

Correct - that is how I do it currently!

We have some TIFF images, so I convert them to JPEG's "on-the-fly" using
ImageMagicK.

On 7/23/2012 10:43 AM, Mike S wrote:
> are you saying you download the images to temp files, and then set the
> dwo filename column to the temp file name on all of the rows?
>
> i think that is what i will have to do, unless they add this to their
> next release.
>
>
> Chris Pollach wrote:
>
>>
>> Hi Mike;
>>
>> Unfortunately, the InkEdit and InkPicture controls are not supported.
>> I was hoping that they were as well and the documentation does not
>> say one way or another - but, my official query into engineering was
>> "NO". :-(
>>
>> FWIW: What I do is use ImageMagicK and/or GraphicsMagicK to convert
>> the images to a common supported format. Then I use the normal DWO
>> with the "Display As Picture" property set or the Picture Control to
>> display the converted images. A bit of the "pain-in-the-rear" but it
>> is workable.
>>
>> FYI: I have not heard of any plans to support these controls - but
>> IMHO I think that would be a great suggestion. I would encourage you
>> to add this to the Appeon enhancement requests at
>> http://my.isug.com/p/cm/ld?fid=187
>
>
>


Mike S Posted on 2012-07-23 20:03:10.0Z
From: "Mike S" <M@M.com>
Subject: Re: image display in datawindow - inkcontrol or new 12.5 image tableblobcontrol
Newsgroups: sybase.public.appeon
References: <500ae45c$1@forums-1-dub> <500d452e$1@forums-1-dub> <500d6318$1@forums-1-dub> <500d6b40$1@forums-1-dub>
User-Agent: XanaNews/1.18.1.6
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <500dadfe$1@forums-1-dub>
Date: 23 Jul 2012 13:03:10 -0700
X-Trace: forums-1-dub 1343073790 172.20.134.152 (23 Jul 2012 13:03:10 -0700)
X-Original-Trace: 23 Jul 2012 13:03:10 -0700, vip152.sybase.com
Lines: 71
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:3012
Article PK: 21998

got it working in pb.

I'm saving the files to a temp directory - that can get pretty big - 50
characters in size.

Do you create a compute db column of that size in the datawindow to
hold the filename? or do you use a smaller size? I noticed that PB
(11.51 anyway) doesn't care about the size of the text (50 chars in
actual size being put into a dw column of 30 chars in the compute db
column) and processes it ok. I *think* appeon doesn't care either.

Its a lot of spaces to retrieve from the DBMS just to use as filler for
the filename, so i would rather just bring back a single space from the
dbms if that seems to work everywhere.


Also, do you run a 'clean-up' routine to delete the files from the temp
directory? I guess that would have to be called when the app is exited.

Chris Pollach wrote:

>
> Correct - that is how I do it currently!
>
> We have some TIFF images, so I convert them to JPEG's "on-the-fly"
> using ImageMagicK.
>
>
>
>
>
>
> On 7/23/2012 10:43 AM, Mike S wrote:
> > are you saying you download the images to temp files, and then set
> > the dwo filename column to the temp file name on all of the rows?
> >
> > i think that is what i will have to do, unless they add this to
> > their next release.
> >
> >
> > Chris Pollach wrote:
> >
> > >
> > > Hi Mike;
> > >
> > > Unfortunately, the InkEdit and InkPicture controls are not
> > > supported. I was hoping that they were as well and the
> > > documentation does not say one way or another - but, my official
> > > query into engineering was "NO". :-(
> > >
> > > FWIW: What I do is use ImageMagicK and/or GraphicsMagicK to
> > > convert the images to a common supported format. Then I use the
> > > normal DWO with the "Display As Picture" property set or the
> > > Picture Control to display the converted images. A bit of the
> > > "pain-in-the-rear" but it is workable.
> > >
> > > FYI: I have not heard of any plans to support these controls - but
> > > IMHO I think that would be a great suggestion. I would encourage
> > > you to add this to the Appeon enhancement requests at
> > > http://my.isug.com/p/cm/ld?fid=187
> >
> >
> >

--


Chris Pollach Posted on 2012-07-24 11:36:25.0Z
From: Chris Pollach <cpollach@travel-net.com>
User-Agent: Mozilla/5.0 (Windows NT 5.1; rv:14.0) Gecko/20120713 Thunderbird/14.0
MIME-Version: 1.0
Newsgroups: sybase.public.appeon
Subject: Re: image display in datawindow - inkcontrol or new 12.5 image tableblobcontrol
References: <500ae45c$1@forums-1-dub> <500d452e$1@forums-1-dub> <500d6318$1@forums-1-dub> <500d6b40$1@forums-1-dub> <500dadfe$1@forums-1-dub>
In-Reply-To: <500dadfe$1@forums-1-dub>
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: <500e88b9$1@forums-1-dub>
Date: 24 Jul 2012 04:36:25 -0700
X-Trace: forums-1-dub 1343129785 172.20.134.152 (24 Jul 2012 04:36:25 -0700)
X-Original-Trace: 24 Jul 2012 04:36:25 -0700, vip152.sybase.com
Lines: 86
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:3013
Article PK: 13702

Excellent news! :-)

That is a great trick for the DWO to set the column width to a small
number. You are correct - the DWO column's size will automatically
adjust to the actual text size on an "as needed" basis.

Yes, you will need an image clean-up routine. You might find it easier
to just RUN () a BAT file with a Delete *.jpg than code the same in PB -
your call.

On 7/23/2012 4:03 PM, Mike S wrote:
> got it working in pb.
>
> I'm saving the files to a temp directory - that can get pretty big - 50
> characters in size.
>
> Do you create a compute db column of that size in the datawindow to
> hold the filename? or do you use a smaller size? I noticed that PB
> (11.51 anyway) doesn't care about the size of the text (50 chars in
> actual size being put into a dw column of 30 chars in the compute db
> column) and processes it ok. I *think* appeon doesn't care either.
>
> Its a lot of spaces to retrieve from the DBMS just to use as filler for
> the filename, so i would rather just bring back a single space from the
> dbms if that seems to work everywhere.
>
>
> Also, do you run a 'clean-up' routine to delete the files from the temp
> directory? I guess that would have to be called when the app is exited.
>
>
>
>
> Chris Pollach wrote:
>
>>
>> Correct - that is how I do it currently!
>>
>> We have some TIFF images, so I convert them to JPEG's "on-the-fly"
>> using ImageMagicK.
>>
>>
>>
>>
>>
>>
>> On 7/23/2012 10:43 AM, Mike S wrote:
>>> are you saying you download the images to temp files, and then set
>>> the dwo filename column to the temp file name on all of the rows?
>>>
>>> i think that is what i will have to do, unless they add this to
>>> their next release.
>>>
>>>
>>> Chris Pollach wrote:
>>>
>>>>
>>>> Hi Mike;
>>>>
>>>> Unfortunately, the InkEdit and InkPicture controls are not
>>>> supported. I was hoping that they were as well and the
>>>> documentation does not say one way or another - but, my official
>>>> query into engineering was "NO". :-(
>>>>
>>>> FWIW: What I do is use ImageMagicK and/or GraphicsMagicK to
>>>> convert the images to a common supported format. Then I use the
>>>> normal DWO with the "Display As Picture" property set or the
>>>> Picture Control to display the converted images. A bit of the
>>>> "pain-in-the-rear" but it is workable.
>>>>
>>>> FYI: I have not heard of any plans to support these controls - but
>>>> IMHO I think that would be a great suggestion. I would encourage
>>>> you to add this to the Appeon enhancement requests at
>>>> http://my.isug.com/p/cm/ld?fid=187
>>>
>>>
>>>
>
>
>