FreeAdhocUDF for InterBase and FireBird in deutschin englishen français
homeprevious pageÜbersicht • overview • aperçunext pagelast page mailing-listwas ich vermisse • what I missed •eMail Kommentar • eMail commentprint
 

Functions enclosed in FAUfile.dll/.so/.dylib :
File functions 3 functions

with BLObs
2 functions

diverse file functions
1 function


Output RETURN mechanism if nothing other is published: FREE_IT
TestSQLs with NULL run only in FireBird 2.0
Attention! Importend!
For security reasons we had swaped out the file functions in an own library, because you can access to filesystem with the database-client without right-system.
If you didn't wont this security-whole, dispence on the file functions and implicitly of the file FAUfile.dll/.so/.dylib in folder ../UDF.
        
File functions: with BLObs
F_BLOBLOAD function from adhoc
Entrypoint blob_load compatible with UTF-8
Input CSTRING(8191) complete path with filename
Output BLOB load (binary)File in a BLOB
TestSQL
Windows: (please adapt your path and IDs)
SELECT F_BLOBLOAD('C:\boot.ini') FROM RDB$DATABASE;
INSERT INTO BLOBTEST (TEXTBLOB, BINAERBLOB) SELECT 'PNG-picture' || F_CRLF() || 'FreeAdhocUDF.png', F_BLOBLOAD('C:\copy\FreeAdhocUDF.png') 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
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
nach oben • go top •
F_BLOBSAVE function from adhoc
Entrypoint blob_save compatible with UTF-8
Input CSTRING(8191)
BLOB
complete path with filename
BLOb to save
Output INTEGER size of saved file in bytes
Output file system saves (binary)file from a BLOB into filesystem
TestSQL
Windows: (please adapt your path and IDs)
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_BLOBSAVE('/daten/copy/textblob.txt', TEXTBLOB), F_BLOBSAVE('/daten/copy/picture.png', BINAERBLOB) FROM BLOBTEST WHERE BLOBTESTID = 14
nach oben • go top •

File functions: diverse file functions
F_FILEVERSION function from adhoc
Entrypoint fileversion compatible with UTF-8
Input without
Output CSTRING(255) version of FAUfile
TestSQL
SELECT F_FILEVERSION() FROM RDB$DATABASE;
vorige Seite • previous page • passée sitenach oben • go top • vers le hautnächste Seite • next page • prochain site