2. ASPRunnerPro General questions
  3. inline Edit Error Occurred
This topic is locked

inline Edit Error Occurred

 		11/22/2007 12:27:53 PM
ASPRunnerPro General questions
J
 Justy author

Using ASPRUNNER 5.1 Build 327.
Connected to an Access db.
I am accessing a query with a where clause. One of the fields within the where clause is a field I want to be changed using inline edit.
When I attempt to make a change an Error occurred is returned.
I think because I am editing a field within the where clause, I am encountering this issue.
I have tried to use the After Event to redirect but with no success.
Regards,

Justy
M
 		Michael7 11/22/2007

I have had the same problem here and not found a solution.
In my example my where clause says to display the record if field a = 1 but if field a = 0 do not show.

when i use inline edit to change field a to 0 the record is update but the error occured is displayed.
Is there a way to invoke an event that will allow a redirect to self or a page refresh after update where sql will run itself again and remove the record from the list properly.
Thanks

Michael
J
 		Justy author 11/27/2007

The solution greatly received from the support team :
Modify generated include\inlineedit.js file.

Find this snippet there:

---------------------------------------------------------

if( txt.substr(0,5) == "error" )

{

$("span[@id^=edit"+id+"]:eq(0)").children("div.error").remove();

---------------------------------------------------------
and replace it with:
---------------------------------------------------------

if( txt.substr(0,5) == "error" )

{

window.location.reload(true);

return;

$("span[@id^=edit"+id+"]:eq(0)").children("div.error").remove();