Binary Blobs

Thread View: borland.public.interbase.sql

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by Niall R Scott Fri, 13 Dec 2002 10:08

#11117

Author: Niall R Scott
Date: Fri, 13 Dec 2002 10:08

22 lines
1700 bytes

Hi

Although I have been using Interbase for approx 18 months I have never
needed to store anything other than text in a blob, Now I need to store
files in blobs.
Can anyone point me in the direction of how to take a filename and store the
contents of that file in a blob using IBQuery.

TIA
--
Niall R Scott
IS Support
Cameron Controls
Aberdeen
scottn@camerondiv.com
****************************************************
This e-mail is confidential, may contain proprietary information of the
Cooper Cameron Corporation and its operating Divisions and may be legally
privileged. This e-mail should be read, copied and/or used only by the
addressee. If you have received this message in error please delete it,
together with any attachment(s), from your system.
****************************************************

Re: Binary Blobs

#11118

Author: Martijn Tonies
Date: Fri, 13 Dec 2002 10:15

30 lines
1614 bytes

Hi,

Use Param.LoadFromFile(...) in a prepare query.

> Although I have been using Interbase for approx 18 months I have never
> needed to store anything other than text in a blob, Now I need to store
> files in blobs.
> Can anyone point me in the direction of how to take a filename and store the
> contents of that file in a blob using IBQuery.
>
> TIA
> --
> Niall R Scott
> IS Support
> Cameron Controls
> Aberdeen


--

With regards,

Martijn Tonies
InterBase Workbench - the developer tool for InterBase & Firebird
Firebird Workbench - the developer tool for Firebird
Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads