File Upload does not return error, but it does not perform the task
When I try to upload a file to the server and save its name in a database using an Insert Transaction, all seems to work fine - no errors returned - but either the file is missing from the server, or it isn't saved into the database.
Issue
When I try to upload a file to the server and save its name in a database using an Insert Transaction, all seems to work fine - no errors returned - but either the file is missing from the server, or it isn't saved into the database.
Reason
This happens because the insert transaction also contains the table primary key.
Solution
To solve this issue you must remove the primary key column from the insert transaction:
- From the Server Behaviors tab double-click the Insert transaction.
- In the Files tab select the primary key column and click the Minus(-) button.
