Solved

Save & Retrieve Tiff image from blob object to sqlserver using powerbuilder 8.0

Posted on 2003-11-08
4
10,560 Views
Last Modified: 2013-12-26
Hi,

I have Tiff image files i want to store it as blob object to sql server 2000 using power builder 8.0. The Tiff image should be displayed on the screen.
Can anyone help me how to do this?
Please provide me some code and method to do this.

Thanking you in advance,

Imtiyaz
0
Comment
Question by:wellwisher888
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 8

Accepted Solution

by:
Vikas_Dixit earned 20 total points
ID: 9710882
Hi imtiaz,

u can create the OLE presentation stype datawindow to achieve the same. On the Inser Control screen ( while creating new datawindow, you will need to give the name of the OCX, that you want to display the tiff file with.

Regards,
Vikas
0
 
LVL 8

Assisted Solution

by:gajender_99
gajender_99 earned 20 total points
ID: 9714467
Hi Imtiyaz
I believe here is the solution for you problem.

1.Create a a Column in your table that have a data type of (BLOB/OLE OBJECT/Binary/TextLargeObject)

After the table has been created specify a SQL or quick select and select a presentation style for your new data window object.
In you select list specify the key columns for the table, but don’t select the BLOB column as a part of data source.

To add the BLOB column to your datawindow object click the “OLE Database Blob” from Insert  Controls. Click the datawindow where you want to place the blob object. This opens the database binary/text large object dialog box.

You can change the Client Name to  what ever you want.

Scroll through the list of tables  containing the Blob Column and click the table name.
The Large Binary/Text Columns List box displays all the columns from the selected table, now select the Blob column.

In the key clause type the id column for the table i.e id or emp_id.

You can leave the file template blank.

Now select the ole class by which you want to view the File

You can type a client name or use a computed text to give a name in client name expression.

. when your are running the window (I mean to say retrieved the data) you can double click on the blob column this bring the object which is associated with the blob object you can select a file  and close it .

this works fine in Powerbuilder 7 and it should work fine in 8 also if you get any error message just let me know I can provide a working example for this blob thing

thanks

Gajender
0

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Programmer's Notepad is, one of the best free text editing tools available, simply because the developers appear to have second-guessed every weird problem or issue a programmer is likely to run into. One of these problems is selecting and deleti…
How to install Selenium IDE and loops for quick automated testing. Get Selenium IDE from http://seleniumhq.org Go to that link and select download selenium in the right hand columnThat will then direct you to their download page.From that page s…
This tutorial covers a step-by-step guide to install VisualVM launcher in eclipse.
THe viewer will learn how to use NetBeans IDE 8.0 for Windows to perform CRUD operations on a MySql database.

710 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question