Inline Edit Question

I may be out to lunch as I'm still relatively new at runner. But I had a similar circumstance so what I did was:

1. Create a Customer View in runner. Give the appropriate users List access to this view and/or
   
2. Modify your tables to use advanced seucrity, specifically User group permissions. See the help file.
   They can be used mutually or inclusively - at least I've got it working this way.
   Option 1 is nice and realtively easy. Also, you should set up User Level access on your tables based on something like Customer_ID or User_ID or setup a new field (I called mine User_LVL) and use it as a trigger mechanism for security.
   Option 2, is really cool. I've just started playing with it. But keep in mind that the other security options are also valid. In other words, they can work in conjuction with method #2. So you can really mix and match and get some fairly sohpisticated security schemas.
   I've found that when you use User Level permissios, make sure that you click on the User Id Number to select it THEN click on "Admin can...". This allows users the ability to access the tables based on your permission set(s), whilst someone with the Admin Level can do all kinds of things. It you miss the "Admin can.." nothing secure occurs.
   Finally (I tend to bable when I find neat things), I would consider implimenting multi-level security. For example, Users = 1, Editors = 5, Admins = 9. Then apply the permissions based on the User Level ID.
   I hope this helps, and please remember that I am new and still playing, but I'm having excellent success using the above.

McCree Lake,
you can use BeforeEdit event to construct UPDATE query manually and update another table.
Do not forget to add BeforeEdit = false as the last line in BeforeEdit event.

Thanks for your help Sergey.
I have tried your instructions and running into a bit of a problem. When I try to edit the record via inline it is telling that it is read-only which means it is still trying to edit the read only query rather than the one specified in my SQL code.
Here is the code I am using (BeforeEdit) event. EventClientGAID is the primary key.

Print your query on the web page and run it manually against your database to see what's wrong with it.

Thank you. Can you tell me how to print it on the web page? I am not sure how to do that. When you say test it manually against my database, do you mean from the ASPRunner application or in the database itself?
Thank you!

To print query use Response.Write statement:

strSQLUpdate = "UPDATE GrpMng_Attnd_Evn_GrpAffAttn_Edit "

Then execute resulted query in the database directly.

Okay. I was able to figure it out. Thanks for your help! Now, my question is how to get users back to the master table once they have used inline edit to change the information. Since I am using BeforeEdit = False it updates that record, but it appears to the end user that nothing has happened. Is there a way, once record is save or the SAVE ALL button is pressed that the users can be directed back to the master table list and that I could refresh that page to show the changes?
Thanks! you guys are awesome.

Hi,
unfortunately there is no easy way to redirect after Inline Edit.

Theoretically you can add custom JavaScript code (redirect and refresh page). However we don't have a ready to go solution for this.

Is there anyway to use the script with events that you use when the user clicks the cancel button on the table view page?

Hi,
you need to use JavaScript code to redirect after Inline Edit.