Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: David Jo
  Where is David Jo?
 Buffalo Grove
 Illinois - United States
 David Jo
 To: Borislav Borissov
  Where is Borislav Borissov?
 Sofia
 Bulgaria
 Borislav Borissov
 Tags
Subject: RE: PDF stored as binary
Thread ID: 112459 Message ID: 112473 # Views: 2 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Wednesday, November 08, 2006 9:42:49 PM         
   


> > Has anybody stored PDF or JPG files in binary format on a SQL Server? I've got a need where I'd much rather have a PDF or JPG converted to binary format and then saved in a SQL record. I'm not sure if this is possible, or even advisable. I'm thinking maybe a hundred pages worth of docs or images in a particular day. Disk space is not an issue, but performance would be.
> >
> > Any insights would be appreciated.
> >
> > Thanks,
> > David
> >
> > Clarification: I'd also like the capability of storing a scanned image directly from the scanner into the table record and not have file created during the process. I've read a few articles on how to control a scanner and output a file, but I'd like to direct that output to the binary field.

>
> David, When you dealing with SQL server you may have NO access to disk where SQL Server is installed. Local stations may have no common shared folder where you can keep all these files. Only option available is to store these files IN image field of the tables. I don't know how you manage data from SQL Server but with CAs and VFP9 you could use BLOB field.
>
> Borislav Borissov
>
>



Borislav, so BLOB in VPF equates to Image in SQL?

Thanks,
David

ENTIRE THREAD

PDF stored as binary Posted by David Jo @ 11/8/2006 8:48:38 PM
RE: PDF stored as binary Posted by Ken Murphy @ 11/8/2006 9:04:55 PM
RE: PDF stored as binary Posted by David Jo @ 11/8/2006 9:08:47 PM
RE: PDF stored as binary Posted by Ken Murphy @ 11/8/2006 9:31:51 PM
RE: PDF stored as binary Posted by David Jo @ 11/8/2006 9:39:48 PM
RE: PDF stored as binary Posted by Ken Murphy @ 11/8/2006 9:44:46 PM
RE: PDF stored as binary Posted by Borislav Borissov @ 11/8/2006 9:50:37 PM
RE: PDF stored as binary Posted by Ken Murphy @ 11/9/2006 12:20:11 AM
RE: PDF stored as binary Posted by David Jo @ 11/8/2006 9:56:03 PM
RE: PDF stored as binary Posted by Ken Murphy @ 11/9/2006 12:18:19 AM
RE: PDF stored as binary Posted by Borislav Borissov @ 11/8/2006 9:34:43 PM
RE: PDF stored as binary Posted by Ilya Rabyy @ 11/9/2006 12:09:54 AM
RE: PDF stored as binary Posted by Ken Murphy @ 11/9/2006 12:28:00 AM
RE: PDF stored as binary Posted by Ilya Rabyy @ 11/9/2006 12:35:40 AM
RE: PDF stored as binary Posted by Borislav Borissov @ 11/8/2006 9:37:32 PM
RE: PDF stored as binary Posted by David Jo @ 11/8/2006 9:42:49 PM
RE: PDF stored as binary Posted by Borislav Borissov @ 11/8/2006 9:47:42 PM