Find Jobs
Hire Freelancers

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.
IČ projektu: 2284291

O projektu

Vzdálený projekt
Aktivní před 12 roky

Chcete si vydělat nějaké peníze?

Výhody podávání nabídek na Freelancer

Stanovte si rozpočet a časový rámec
Získejte za svou práci zaplaceno
Načrtněte svůj návrh
Registrace a podávání nabídek je zdarma

O klientovi

Pochází z
5,0
1
Členem od zář 11, 2006

Ověření klienta

Díky! Poslali jsme vám e-mailem odkaz pro získání kreditu zdarma.
Při odesílání e-mailu se něco pokazilo. Zkuste to prosím znovu.
Registrovaných uživatelů Zveřejněných projektů
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Načítání náhledu
Bylo uděleno povolení ke geolokaci.
Vaše doba přihlášení vypršela a byli jste odhlášeni. Přihlaste se znovu.