Firebird Interbase Blob Insert Sql Function

I got a Firebird 2.1 database SQL files that need to be imported into a new Firebird 2.1 database. All of my SQL tables with no BLOBs work just fine. The SQL files with BLOBs come out with an error. Here is an example SQL INSERT of a table with BLOBs.

/*OneQuery*/
INSERT INTO TBLCLIENTLOG (CDDESCRIPTION, CGDATE, TAID, CCNID, CLID, EMID, CGID, FK_NGT_ID, CGSHOWONWEB, CGWITHDETAIL, CGSPECTYPE, CDAUTONOTE) VALUES (DATAFILE2BLOB(‘C:\IN\Recovered RRL.FDB 1-Dec-11 14.20.05\Blob\TBLCLIENTLOG\blob_d…

Leave a Reply

Your email address will not be published. Required fields are marked *