[Gambas-user] Tobis "Blob" datatype (was "Hot to load and savbe ...")

[Randall Morgan]

I guess what I was trying to say is that the BLOB type comes from the
database component not the core language. As it is database specific.


On Tue, Jul 16, 2013 at 2:50 AM, Bruce <bbruen at ...2308...> wrote:

> 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 <bbruen at ...2308...>
> 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
> Gambas-user at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/gambas-user
>



-- 
If you ask me if it can be done. The answer is YES, it can always be done.
The correct questions however are... What will it cost, and how long will
it take?