Upload File, cache as a parameter and then commit to SQL Server

[Olli_Burr]

Hello,

I am faced with the problem of temporarily saving a file in a popup while filling out a order form and then only writing it away when the save button is pressed using an SQL query along with the entered order data. The process is as follows:

The "add_Order" popup serves the following purposes:

1. All text fields in the popup must be filled in.
2. A PDF that belongs to the order has been successfully uploaded.
3. The desired date has been selected.
4. If everything is OK, the order data is saved on the SQL server by pressing the save button.

My current procedure is:

1. Check whether all fields have been filled in
2. When the document is uploaded, the PDF is converted into a string using "onFileReceived" and "event.file.getString()" and passed to the "UploadByteCodeDrawingNumberFile" parameter of the "add_Order" popup.
3. If the desired date is selected, the save button becomes active.
4. If the save button is pressed, the named query is called, the string is converted into a byte array with "byte_data = UploadByteCodeDrawingNumberFile.encode("utf-8")" and then the SQL query is executed with the aim of making the uploaded file later available for download from the SQL server.

Unfortunately, this approach does not work...

Do you have any idea how I can temporarily save the file as a string, array or whatever in the form of a parameter after uploading it and then save the file as a byte array or varbinary when the SQL query is actually executed?

Many thanks in advance!

[victordcq]

store the file in a temp file, and save the filepath, instead of trying to store the file in the memory

Save temporary upload files byte stream in memory

You should be able to handle this by using a temporary file. Create a file with something like this on the File Upload component fileBytes = event.file.getBytes() extension = event.file.name.split('.')[-1] tempFilePath = system.file.getTempFile(extension) system.file.writeFile(tempFilePath, fileBytes) # Store the temporary file path in a custom property self.view.custom.tempFilePath = tempFilePath When you want to send the email, you can read the file back like this: tempFilePath = self.vi…

[pturmel]

Another similar topic:

Update query for file upload component

I'm creating a view similar to a form where the user can fill in text fields, select buttons, and upload files. I want to store all this into a database with a 'submit' button click. However I can't figure out how to store the bytes of the file that the user uploaded to database on the submit button click. I've been able to store the file bytes to the database by itself with the file upload component's onFileReceieved script by using event.file.getBytes(), so I know it's possible. But I want to…