Mike & Doris Manning
mikedorism at adelphia.net
Thu Jun 17 13:07:50 CDT 2004
Those streaming objects come in very handy. I've got a couple of Crystal 10 Reports that dynamically pull images files from a network location, stick them in an empty Image field in a SQL dataset (fields exists only in the dataset and not in the SQL table itself), and manipulate the boundaries of the image so that it is centered and not distorted -- all things sadly lacking in the recent release of Crystal 10. Doris Manning Database Administrator Hargrove Inc. www.hargroveinc.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence (AccessD) Sent: Thursday, June 17, 2004 12:42 PM To: Access Developers discussion and problem solving Subject: RE: [AccessD] Getting pictures into a blob in SQL Server Hi Drew: This piece of code is an older technique for handling blobs. It now has been superceded by various streaming functions. Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of DWUTKA at marlow.com Sent: Thursday, June 17, 2004 8:39 AM To: accessd at databaseadvisors.com Subject: RE: [AccessD] Getting pictures into a blob in SQL Server MSKB Article #103257 covers how to do this in Access. I'm pretty sure this same code will work with SQL, since it is just using a recordset as an argument: http://support.microsoft.com:80/support/kb/articles/Q103/2/57.asp&NoWebConte nt=1 Drew -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of jwcolby Sent: Thursday, June 17, 2004 7:56 AM To: SQLServer; 'Access Developers discussion and problem solving' Subject: [AccessD] Getting pictures into a blob in SQL Server I got a call from someone yesterday needing to get 25000 pictures into a blob field in SQL Server. The program he is attempting to use apparently stores the pictures it uses in such a field. These pictures are currently stored as GIFs (I believe) on the hard drive. I can write a program to cycle through a dir on the disk, but would I just read the text into a string and dump it into the field, save and move on? Has anyone ever done this? I included AccessD in this request as I am guessing I'll just do it through VBA in AccessD. John W. Colby www.ColbyConsulting.com -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com