I am using Dynamic Update in my application and it works fine. But my requirement is something like this.
1. I am using Insert in my Dynamic Update. Before I insert the records in the respective tables I want to perform logic operations on it. Say I am entering ZipCode and City name in my input fields. I want to calculate if Long and Lat exists for that pincode and then if they exists I want to add them to my tables.
2. Also I wish to append my source file(csv) with the new data loaded