Subject Re: [firebird-support] Is it possible to insert Image via sql stament?
Author
Great, Thanks!
 


Sent from Yahoo Mail. Get the app


On Tuesday, September 27, 2016 10:10 AM, "Scott Morgan blumf@... [firebird-support]" <firebird-support@yahoogroups.com> wrote:


 
On 27/09/16 04:22, trskopo@... [firebird-support] wrote:
> Is it possible to insert image into FB database directly via sql stament
> using isql or flamerobin?

There's a utility, FSQL, that behaves like ISQL and extends some of the
SQL syntax, including directly referencing files in an INSERT command:

INSERT INTO tab(id, blobfield) VALUES (1, @'c:\f.txt');

Sadly it's getting a bit old now, and it's Windows only.

http://mujweb.cz/iprenosil/interbase/fsql.htm

Scott