Hello,
I'm very new to EW, but need to create a webpage quickly to select/update a table in a SQL database. I urgently need help with updating the databse records, please.
The select portion works fine: I have two parameter fields that are passed to the select statement to retrieve the data. Both paramenters have a default value setup. I've generated Insert, Update and Delete statements and set the control to Enable Editing.
When I load the page, the grid first displays rows based on the default values of my parameters. AFter that, I provide the new values and click Submit button - the new result set is returned showing the data based on the new paramenters.
Now, I need to update one record, so I click on the Edit link. Instead of giving me an option to edit that particular record, the page returns a new result set using the DEFAULT parameter values and gives me an option to edit some other row that I didn't select.
I looked at the Code tab to see where the Edit link takes the parameters from, but could not find any references to it.
Any help would be greatly appreciated as I need to have it up and running ASAP!
Thank you in advance.