New topic: storing pdf files in MS SQL SERVER
<http://forums.realsoftware.com/viewtopic.php?t=47630> Page 1 of 1 [ 3 posts ] Previous topic | Next topic Author Message rlunn Post subject: storing pdf files in MS SQL SERVERPosted: Thu Apr 18, 2013 10:05 am Joined: Fri Feb 27, 2009 12:18 am Posts: 53 HI, does anyone have any examples of code for storing pdf files in a Microsoft Sql Server? and of course getting them back out again! Regards, Russ Top Paul Lefebvre Post subject: Re: storing pdf files in MS SQL SERVERPosted: Thu Apr 18, 2013 9:41 pm Site Admin Joined: Fri Sep 30, 2005 9:35 am Posts: 957 Location: South Portland, Maine I don't have a specific example, but in general you ought to be able to use a BLOB column for this in conjunction with DatabaseRecord.BlobColumn, DatabaseField.NativeValue. Use a BinaryStream to read the PDF into a string and then write the string to the DB using the BLOB functions. _________________ Paul Lefebvre Developer Evangelist Real Software, Inc. The Real Studio Developer Conference is back: April 23rd-26th, 2013 in Orlando, FL. Top rlunn Post subject: Re: storing pdf files in MS SQL SERVERPosted: Fri Apr 19, 2013 5:35 am Joined: Fri Feb 27, 2009 12:18 am Posts: 53 thanks paul. im actually doing this using sqlexecute though rather than databaserecord. Top Display posts from previous: All posts1 day7 days2 weeks1 month3 months6 months1 year Sort by AuthorPost timeSubject AscendingDescending Page 1 of 1 [ 3 posts ] -- Over 1500 classes with 29000 functions in one REALbasic plug-in collection. The Monkeybread Software Realbasic Plugin v9.3. http://www.monkeybreadsoftware.de/realbasic/plugins.shtml [email protected]
