I.T. Discussion Community!
-Collapse +Expand
Delphi
Search Delphi Group:

Advanced
-Collapse +Expand Delphi To/From
To/FromCODEGuides
-Collapse +Expand Delphi Store
PRESTWOODSTORE

Prestwood eMagazine

October Edition
Subscribe now! It's Free!
Enter your email:

   ► MB LobbyPascal and Delphi Coding BoardDelphi Single User Apps Topic   Print This     

Storing Jpeg Files into Paradox Database

Storing Jpeg Files into Paradox Database in Delphi Single User Apps topic (part of our Pascal and Delphi Coding group).

Quick Search: Storing   Paradox   Database   Storing Jpeg   Storing Jpeg Files   into Paradox  
Owen
Ashburton, New Zealand
Can anyone help me

How can I store Jpeg Camera files into my database

I have a field in my database called image which is set to a graphic Type

How can I store a jpg image into the database and then view it as i select the record from a table

I can make it all work using mbp files but not using jpg files is there a trick to it or do you need to comvert them to bmp and if so how can I do that

Thanks

Owen
 Posted 17 years ago (Thread Starter)
Comment Quote
About Owen -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #5673, 3 replies
Thread Started 3/31/2002 10:03:00 PM
View Counter=3634
Last Reply Posted 9/25/2008 11:12:37 AM)
Location=Ashburton, New Zealand  
Joined=18 years ago   MB Posts=6  
Moderator
Mike Prestwood
Prestwood IT
Prestwood IT office in Citrus Heights, CA

Just adding to this thread...

The bottom line is that you can't. The Paradox graphic field type converts all images to non-compressed BMP images when you paste/import them. Also, the image types supported by the paste/import routines is limited.

Instead, I suggest you keep your images in a single folder and then simply store the name of the image in a Alpha field (a text field). This approach has many advantages including the fact that you can work with the images outside of Paradox.

--
Mike Prestwood
Prestwood IT Solutions

 Posted 11 years ago
Comment Quote
About Mike Prestwood -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.
About Mike Prestwood

Mike Prestwood is a drummer, an author, and creator of the PrestwoodBoards online community. He is the President & CEO of Prestwood IT Solutions. Prestwood IT provides Coding, Website, and Computer Tech services. Mike has authored 6 computer books and over 1,200 articles. As a drummer, he maintains play-drums.com and has authored 3 drum books. If you have a project you wish to discuss with Mike, you can send him a private message through his PrestwoodBoards home page or call him 9AM to 4PM PST at 916-726-5675 x205.

Web Presence
Facebook, Prestwood IT Facebook page -- fan page. (Visit Me)
Twitter, Follow Prestwood IT on Twitter. (Visit Me)
LinkedIn, Prestwood IT company page on LinkedIn. (Visit Me)
YouTube, Prestwood IT YouTube Channel (Visit My Channel)
Website, My drum website where I sell my drum books. (http://www.play-drums.com)

Post ID #13040 (Level 1.1)  Reply to 5673
Thread Started 9/24/2008 12:36:16 PM
Location=Prestwood IT office in Citrus Heights, CA 
Joined=19 years ago   MB Posts=1410   KB Posts=1805   KB Comments=70   BLOG, Topics=4  
Most Recent Post
Moderator
Mike Prestwood
Prestwood IT
Prestwood IT office in Citrus Heights, CA

Hi Owen,

Nice solution. Sure, I'd like to see the code. You can post it here if it's short or how about posting it as an article in our knowledge base? If you want, you can send it to me and I'll post it for you or you can post it.

--
Mike Prestwood
Prestwood IT Solutions

 Posted 11 years ago
Comment Quote
About Mike Prestwood -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.
About Mike Prestwood

Mike Prestwood is a drummer, an author, and creator of the PrestwoodBoards online community. He is the President & CEO of Prestwood IT Solutions. Prestwood IT provides Coding, Website, and Computer Tech services. Mike has authored 6 computer books and over 1,200 articles. As a drummer, he maintains play-drums.com and has authored 3 drum books. If you have a project you wish to discuss with Mike, you can send him a private message through his PrestwoodBoards home page or call him 9AM to 4PM PST at 916-726-5675 x205.

Web Presence
Facebook, Prestwood IT Facebook page -- fan page. (Visit Me)
Twitter, Follow Prestwood IT on Twitter. (Visit Me)
LinkedIn, Prestwood IT company page on LinkedIn. (Visit Me)
YouTube, Prestwood IT YouTube Channel (Visit My Channel)
Website, My drum website where I sell my drum books. (http://www.play-drums.com)

Post ID #13042 (Level 1.2)  Reply to 5673
Reply Posted 9/25/2008 11:12:37 AM
Location=Prestwood IT office in Citrus Heights, CA 
Joined=19 years ago   MB Posts=1410   KB Posts=1805   KB Comments=70   BLOG, Topics=4  
owen.moore
Ashburton, -- NZ

Thanks for the reply

the originall question was asked a long time a go and I have since found a tidy way to do it

Basically I turn the jpeg into a datastream and assign it to a blob field and it works very tidy.

I agree that the best way would be to store the files elsewhere and just save the path but that option is allways open to problems if the jpeg images get accidentally moved etc

If you would like to see my code i will happily send it

Cheers

Owen 

 Posted 11 years ago
Comment Quote
About owen.moore -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #13041 (Level 1.3)  Reply to 5673
Reply Posted 9/24/2008 3:31:42 PM
Location=Ashburton, -- NZ 
Joined=16 years ago   MB Posts=7  

Revive Thread!

Add a comment to revive this old thread and make this archived thread more useful.

Write a Comment...
Full Editor
...
Sign in...

If you are a member, Sign In. Or, you can Create a Free account now.


Anonymous Post (text-only, no HTML):

Enter your name and security key.

Your Name:
Security key = P1186A1
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #5673 Counter
3634
Since 4/2/2008

Follow PrestwoodBoards on: 


©1995-2019 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech