538350 Firebird Interbase BLOB Insert SQL Function
N/A
Probíhající
Zveřejněno před více než 12 roky
N/A
Zaplaceno při doručení
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 [login to view URL] 1-Dec-11 14.20.05\Blob\TBLCLIENTLOG\[login to view URL]', '2247'), '1/25/2011 13:13:28', NULL, NULL, 17484, 1201, 524677, 1, 0, NULL, NULL, 0);
/*OneQuery*/
INSERT INTO TBLCLIENTLOG (CDDESCRIPTION, CGDATE, TAID, CCNID, CLID, EMID, CGID, FK_NGT_ID, CGSHOWONWEB, CGWITHDETAIL, CGSPECTYPE, CDAUTONOTE) VALUES (DATAFILE2BLOB('C:\IN\Recovered [login to view URL] 1-Dec-11 14.20.05\Blob\TBLCLIENTLOG\[login to view URL]', '2404'), '1/25/2011 13:14:31', NULL, NULL, 17200, 1203, 524678, NULL, NULL, NULL, NULL, 1);
So I have the BLOB data file int he right location. I have a BLOB file for each table, the database is trying to draw a certain section of this file into the BLOB.
Here is an example BLOB data file of this table.
\fs22 \b1[16247Letter of Representation Creditor 12-28-10 V1.2 [login to view URL]]\b0 was printed for creditor: DISCOVER# Account#: 6011008095218704\par™ \fs22 \b1[16247Letter of Representation Creditor 12-28-10 V1.2 [login to view URL]]\b0 was printed for creditor: HSBC CARD SERVICES Account#: 4663090012807260\par \fs22 \b1[16247Letter of Representation Creditor 12-28-10 V1.2 [login to view URL]]\b0 was printed for creditor: GOODYEAR CREDIT CARD PLAN Account#: 7753010067201023\par“ \fs22 \b1[16247Letter of Representation Creditor 12-28-10 V1.2 [login to view URL]]\b0 was printed for creditor: JUNIPER BANK Account#: 5140218016669242\paræ
to wait at least 3-4 months to settle told her if we were to try and negotiate on one \par
of her accts when she first started the program they will most likely not settle and ask \par
for a payment she understood i gave her my info told her to email me or contact me via \par
\f1 phone anytime she has questions or concerns she thanked me for my help\f0\parM
So basically I got multiple BLOBs in this file.
The error that I get from ISQL is:
SQL Error
function DATAFILE2BLOB not found.
I have tried to import this table in Firebird 2.1, 2.5, Interbase 2009 with the same error. This function simply does not exist in the database. I would like someone to write a SQL function that can draw these BLOBs into the INSERT statement, or a script that imports the BLOB data file correctly into the SQL INSERT file.