Re: VB: Patches for reading binary columns and suppressing newlines

Thank you for those patches.  I patched the CVS source code and recompiled.

echo select binary from testtable | mdb-sql -HF -p test.mdb

Where the binary column on the testtable is an OLE and I inserted a picture 
into the field (via access's insert).  The MDB is Access 2000 format.
And I just get a few characters from the beginning of the file and that is 
it, I was already getting a few characters in the mdb-export.
Any suggestions?

Kind Regards
Simon


At 12:25 22/12/2005, Hans-Emil Skogh wrote:

> Hi Simon!
>
> Here's a copy of the original list-mail with the patches as attachments.
>
> It would be nice to hear if the patches work for you.
>
> Hans-Emil
>
> ________________________________________
> Från: Hans-Emil Skogh
> Skickat: den 26 oktober 2005 17:05
> Till: mdbtools-dev@xxxxxxxxxxxxxxxxxxxxx
> Ämne: Patches for reading binary columns and supressing newlines
>
> Hi!
>
> I have created two patches for MDBTools. Both are reliant on that Pedro A. 
> Aranda's patch 
> (http://sourceforge.net/mailarchive/forum.php?thread_id=8498445&forum_id=5183) 
> is applied to make the mdb-sql tool work again. (Apply it with the -R switch.)
> sql-read-binary.patch
> Enables mdb-sql to read and output Access binary fields. This is vital to 
> access for example Adobe Photoshop Elements 3-databases. The binary data 
> is outputted as hex values. In pretty print the length is truncated.
> sql-strip-newlines.patch
> Adds a parameter -s to mdb-sql that replaces all newline characters with 
> spaces when not in pretty-print mode. This is very valuable when using the 
> output from mdb-sql in a script.
> The sql-read-binary patch has parts from Philip Gladstone's binary patch 
> (http://sourceforge.net/tracker/index.php?func=detail&aid=876414&group_id=2294&atid=302294)
> It would be nice if both patches (and Pedros!) could be added to the CVS 
> source tree.
> Hans-Emil
>
>
>
>
>
> No virus found in this incoming message.
> Checked by AVG Anti-Virus.
> Version: 7.1.371 / Virus Database: 267.14.3/209 - Release Date: 21/12/2005
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.1.371 / Virus Database: 267.14.3/209 - Release Date: 21/12/2005




-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems?  Stop!  Download the new AJAX search engine that makes
searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
http://ads.osdn.com/?ad_idv37&alloc_id865&op=click