I want to insert a file (selected by "File Input Field") into a database record (data type: "File").
I modeled a flow from "File Input Field/<Value> [File]" to "Database Record/File".
Performing a dummy entry leads to:
CREATE TABLE DATABASE_RECORD(ID BIGINT GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL,FILE_CONTENT LONGVARBINARY,FILE_CONTENT_TYPE VARCHAR,FILE_FILE_NAME VARCHAR,CONSTRAINT DATABASE_RECORD_PK PRIMARY KEY(ID))
CREATE USER SA PASSWORD "" ADMIN
SET WRITE_DELAY 60
INSERT INTO DATABASE_RECORD VALUES(1,NULL,NULL,'{URL}')
Unfortunately only the url of the file is saved in the FILE_FILE_NAME column.
I'm pretty sure it is my fault, but I don't know how to model it properly.
ciao, kkg
To use the full functionality of this web site, JavaScript needs to be turned on.
For best results, use the Firefox browser..
Copyright © 2003-2017 - Tersus Software Ltd., All rights reserved. Terms of Use License Graphic design by EmaraDesign