?
Solved

how to save flow chart icon in database

Posted on 2003-03-21
4
Medium Priority
?
296 Views
Last Modified: 2010-04-17
hii

i need to save flowchart icons which are multiple in database. suggest me some way sothat i can get that data back & show those icon in new flowchart with same cordinates.

ur valuable suggestion will be highly appreciated

robin
0
Comment
Question by:robinpkothari
[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
  • 2
4 Comments
 
LVL 2

Accepted Solution

by:
northernchill earned 300 total points
ID: 8181638
In your database, define a table with the following fields:
PosX int, PosY int, IconData blob and any others needed to link the icons to flowcharts.

Store the position of the icon in the PosX and PosY fields, while saving the icon image bytes to the blob.

When you want to retrieve and display the icon again, query the database for the position and data.

If the flow chart to which they will be retrieved and displayed may not be the same size and you want the icons to have the same relative position, change the posX and PosY fields to float and store the position as a percentage of the overall flow chart width and height.
0
 

Expert Comment

by:tejas_pathak
ID: 8185407
Hi,

i would suggest you to not store those images in database, bcoz, it would slow down ur database operation , its performance, and moreover its better to query an image on a filesystem then from a blob. I've seen many performance critical applications use this methodology.Store the path of the image in the database field , instead.

Bye.
Tejas.
0
 

Expert Comment

by:tejas_pathak
ID: 8185412
Hi,

i would suggest you to not store those images in database, bcoz, it would slow down ur database operation , its performance, and moreover its better to query an image on a filesystem then from a blob. I've seen many performance critical applications use this methodology.Store the path of the image in the database field , instead.

Bye.
Tejas.
0
 

Author Comment

by:robinpkothari
ID: 8194699
hii guys...thanx for reply

i think got my answer from "northernchill".....its gr8....

thank u very much

robin
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

Make the most of your online learning experience.
The SignAloud Glove is capable of translating American Sign Language signs into text and audio.
In this fifth video of the Xpdf series, we discuss and demonstrate the PDFdetach utility, which is able to list and, more importantly, extract attachments that are embedded in PDF files. It does this via a command line interface, making it suitable …
Starting up a Project

752 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