Subject | Re: [firebird-tools] How to extract blob content to file, using Fsql? |
---|---|
Author | Jiri Cincura |
Post date | 2009-12-22T09:29:28Z |
On Mon, Dec 21, 2009 at 17:50, RobertoA <amorosik@...> wrote:
ID_DOCUMENTI=100", this will show you the blobid (if you didn't
changed the settings). Write it down and use blobdump to write it to
file.
--
Jiri {x2} Cincura (CTO x2develop.com)
http://blog.cincura.net/ | http://www.ID3renamer.com
> Is not clear what mean BLOBDUMP <blobid> <file> [FILTER <num1> <num2>]Start (w)fsql, run "select CONTENUTO_FILE from DOCUMENTI where
> The table name not appear in instruction
> For example, if i wanna extract blob data to file C:\TEST1.JPG from db C:\PEPPE.FDB with userid SYSDBA and password masterkey, the table name is DOCUMENTI, and field name for blob is CONTENUTO_FILE, the key field name is ID_DOCUMENTI and i wanna take the row where ID_DOCUMENTI=100, what is the right instruction?
> Very thank for your precious help
ID_DOCUMENTI=100", this will show you the blobid (if you didn't
changed the settings). Write it down and use blobdump to write it to
file.
--
Jiri {x2} Cincura (CTO x2develop.com)
http://blog.cincura.net/ | http://www.ID3renamer.com