2. ASPRunnerPro General questions
  3. Snapshot data on upload
This topic is locked

Snapshot data on upload

 		12/12/2009 04:23:11
ASPRunnerPro General questions
L
 Levski author

Hello All
I will give a simplified example of my issue
I have an Employees table with fields Name and HourlyRate
I use the upload screen to enter data into a Jobs table (Name, HoursWorked, Cost)
Cost is blank in the upload file, as it goes into the Acces table I want: Cost = Employees.HourlyRate * Jobs.HoursWorked
I need to snapshot to protect historical data in case the HourlyRate changes.
Thanking you in advance.
J
 		Jane 12/14/2009

Hi,
to calculate and save value use Before record added/Before record updated events on the Events tab.

Here is just a sample:

values("Cost") = values("HourlyRate") * values("HoursWorked")
L
 		Levski author 12/14/2009



Hi,
to calculate and save value use Before record added/Before record updated events on the Events tab.

Here is just a sample:

values("Cost") = values("HourlyRate") * values("HoursWorked")



Thank you for responding.
Unfortunately I cannot see any options for capturing the Import event on the Events tab.
Sergey Kornilov admin 12/14/2009

This is correct, import page doesn't provide any events at this moment.
The only way is to modify generated tablename_import.asp file manually. Check InsertData() function that generates and executes SQL query.