Strange error while inserting data to mysql from form application

Scriptcase 8 Discussion
#1

I have a project which uses a form application to insert data to a mysql table. The whole process worked ok, until i decided to change an image field from ImageFilename to ImageDatabase.

After this time (and this continues even to a previous restored application) when i am inserting a row, there is no error but i can’t see the data into mysql table.

More strange is that is seems that the data is inserted (I get return of the new primary key of the table). This is very bizzare. It looks like there i a big Begin Transaction and a rollback of all inserts.

Any ideas?

#2

The data gets put into the table at the moment you save the data in your form. Before that there is just a temporary file in your tmp dir that sits there waiting to be updated/inserted into the table…
An uploaded file is not immediately inserted into the table (afaik) but only when the save is done.
I wonder if you saved your data…