Re: [firebird-support] Is it possible to insert Image via sql stament?

 

On 27/09/2016 04:22, trskopo@yahoo.com [firebird-support] wrote:

 

Is it possible to insert image into FB database directly via sql stament using isql or flamerobin?

Hi, yes it is possible with FlameRobin.

1. Insert a new record in the normal way (for example, right click on the table, select "Browse data" and Grid->Insert row).
2. Now in the "Data" area of the window you will have a "[null]" in the column containing your blob field.
3. Right click on this [null] and there will be an option "Import BLOB from file".
4. Pick the image file you want to insert and the "[null]" will change to "[BINARY]".
5. Commit the insert and the image should be in your database.

Note: If you want to view the image, right click on the "[BINARY]" text and choose "Save BLOB to file..."

Hope this helps.

__._,_.___

---

Posted by: Mike Ro <miker169@gmail.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (2)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit Your Group

• New Members 4

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___