/* TestSQLs to FAUfile functions */ /* uses test-files FreeAdhocUDF.png and firebird-logo-400.png and table BLOBTEST */ /* all */ SELECT F_FILEVERSION() FROM RDB$DATABASE SELECT F_BLOBLOAD(NULL) FROM RDB$DATABASE; /* Windows */ /* please adapt your path and IDs */ SELECT F_BLOBLOAD('C:\boot.ini') FROM RDB$DATABASE; INSERT INTO BLOBTEST (BINAERBLOB) SELECT F_BLOBLOAD('C:\copy\binaerblob.jpg') FROM RDB$DATABASE; UPDATE BLOBTEST SET TEXTBLOB = 'PNG-picture' || F_CRLF() || 'firebird-logo-400.png', BINAERBLOB = F_BLOBLOAD('c:\copy\firebird-logo-400.png') WHERE BLOBTESTID = 14 SELECT F_BLOBSAVE('c:\copy\textblob.txt', TEXTBLOB), F_BLOBSAVE('c:\copy\picture.png', BINAERBLOB) FROM BLOBTEST WHERE BLOBTESTID = 14 /* Linux */ /* please adapt your path and IDs */ SELECT F_BLOBLOAD('/etc/passwd') FROM RDB$DATABASE; SELECT F_BLOBLOAD('/daten/copy/FreeAdhocUDF.png') FROM RDB$DATABASE; INSERT INTO BLOBTEST (TEXTBLOB, BINAERBLOB) SELECT 'PNG-picture' || F_CRLF() || 'FreeAdhocUDF.png', F_BLOBLOAD('/daten/copy/FreeAdhocUDF.png') FROM RDB$DATABASE; UPDATE BLOBTEST SET TEXTBLOB = 'PNG-picture' || F_CRLF() || 'firebird-logo-400.png', BINAERBLOB = F_BLOBLOAD('/daten/copy/firebird-logo-400.png') WHERE BLOBTESTID = 14 SELECT F_BLOBSAVE('/daten/copy/textblob.txt', TEXTBLOB), F_BLOBSAVE('/daten/copy/picture.png', BINAERBLOB) FROM BLOBTEST WHERE BLOBTESTID = 14 /* adhoc 2009-09-25 */