Subject | Re: [firebird-support] Is it possible to insert Image via sql stament? |
---|---|
Author | Scott Morgan |
Post date | 2016-09-27T08:10:30Z |
On 27/09/16 04:22, trskopo@... [firebird-support] wrote:
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
> Is it possible to insert image into FB database directly via sql stamentThere's a utility, FSQL, that behaves like ISQL and extends some of the
> using isql or flamerobin?
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