On Tue, 2013-07-16 at 18:34 +0930, Bruce wrote: > On Tue, 2013-07-16 at 10:20 +0200, Tobias Boege wrote: > > On Tue, 16 Jul 2013, Bruce wrote: > > > On Mon, 2013-07-15 at 23:15 -0700, Randall Morgan wrote: > > > Bruce, > > > > > > > > The blob data type is a binary object and is a MySQL data type. Not a > > > > Gambas data type. It is used in a few other databases as well. > > > > > > > > > > > > On Mon, Jul 15, 2013 at 10:05 PM, Bruce <[email protected]> wrote: > > > > > > > > > On Mon, 2013-07-15 at 22:11 +0200, Tobias Boege wrote: > > > > > 8< > > > > > > Picture files _are_ binary files. But anyways, to get this thread > > > > > > done, I > > > > > > have attached a sample project which lets you import and export > > > > > > binary > > > > > > files of any kind to a local SQLite3 database. > > > > > > > > > > > > You should look carefully at the export functionality in > > > > > btnExport_Click() > > > > > > which selects a record in the database table and saves the > > > > > > corresponding > > > > > > blob field to a file. > > > > > > > > > > > > Everything else in the project is just there for you to play around > > > > > > with > > > > > it. > > > > > > > > > > > > Regards, > > > > > > Tobi > > > > > > > > > > Hi Tobi, > > > > > > > > > > At lines 72 and 106 in your example project you declare hBlob as > > > > > Blob. I > > > > > have never heard of this datatype and can find no help on it? If it > > > > > exists I sure would like to know it. > > > > > > > > > > regards > > > > > Bruce > > > > > > Hi Randall, > > > > > > Yep, I know what a rdbms blob is, I was just hoping there was a "Blob" > > > class somewhere > > > in a gambas component that I didn't know about that would allow access to > > > the raw data > > > from the gb.db translation of the blob into a string or whatever. > > > > > > IIRC, recently there was a thread on a problem with postgresql v 9.2?? > > > blobs that were being > > > returned from the database as escaped strings. One of my colleagues > > > fixed that on our > > > production database but woefully failed to document what the fix was. I > > > was just hoping to > > > be able to reproduce the problem on a test db and see if I could figure > > > out from the raw data > > > exactly what the problem was and how to fix it forever, in case we need > > > to do a db rebuild or > > > whatever. > > > > > > regards > > > Bruce > > > > > > > Randall, Blob is a Gambas class that represents a DB's blob field. > > > > Bruce, there's no special concealment about the Blob class :-) See the class > > listing of gb.db[0]. > > > > Regards, > > Tobi > > > > [0] http://gambasdoc.org/help/comp/gb.db/?v3 > > Well I'll be hornswaggled! > > tx Tobi > and 30min later my problem is solved! tx again
Bruce ------------------------------------------------------------------------------ See everything from the browser to the database with AppDynamics Get end-to-end visibility with application monitoring from AppDynamics Isolate bottlenecks and diagnose root cause in seconds. Start your free trial of AppDynamics Pro today! http://pubads.g.doubleclick.net/gampad/clk?id=48808831&iu=/4140/ostg.clktrk _______________________________________________ Gambas-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/gambas-user
