multiple file upload - plus extra table insert

Scriptcase 8 Discussion
#1

hey guys

am wondering if it is possible to insert into a second table during multiple file insert.
So on my form I have the multiple file insert which adds files to a file table, then I want to take each file that has been inserted and insert or associate them to another table.

Say for instance I add all files to a project (project table + file table) but then want to create from each file a new task (tasks table).

Any ideas how I would achieve this?

thanks in advance

#2

The easiest way if you ask me… create a trigger in your database. to be honest trying to customize scriptcase code in this particular case would take a ton of time, while a simple database trigger might solve your problem in a fancy and easy manner

1 Like