Ajax Callback error

[RankFirstPro]

I use a pretty basic ajax callback and every few times I call this function I get this error error

Fatal error running a5_ajax_grid(): Result set row requested not found while getting result set data column 'progress_bar'. on line 14 in 1000793:pl

Now, I have completely removed the progress_bar field from my grid and it will just replace that with something else.

It's really frustrating that it happens in the first place but what I truly don't understand is that it happens inconsistently, I have found no pattern and am ready to loose my mind.

If anyone at all can help with this I have spent the past 2 months trying to figure out why this is happening and can't get an answer.

Here is my ajax callback:

function Rejected as c (e as p)
	
dim cn as sql::Connection
dim args as sql::arguments
dim sql as c = ""

sql = <<%a%
update client_list
set status = 1, status_by = :By, status_when= :Date
where Client_List_ID = :ID
%a%

cn.open("::name::CompanyProfile")
cn.PortableSQLEnabled = .t.
args.add("ID", e._currentRowKeys[1])
args.add("By", session.current_first_name + " " + session.current_last_name)
args.add("Date", date())

cn.Execute(sql, args)
cn.FreeResult()
cn.close()

Here is the only error I can find in firebug when it happens:

Screen Shot 2013-01-18 at 9.21.16 PM.png

Thanks so much for any help!! I really really need it!

[-Jinx-]

Re: Ajax Callback error

Would it help to clear the args? I don't know how long or through which operations arg data is kept but it would seem like a good idea to clear them if the callback is used multiple times.

[Jeff Benson]

Re: Ajax Callback error

Lily - You're using session variables in your args. Is it possible the session is expiring and that leads to the error occuring?

[agillbb]

Re: Ajax Callback error

Lily, try doing this.

1) Place debug(1) in the callback to make sure it works every time.

2) If you can't figure it out, then simplify your callback:

function Rejected as c (e as p)
  'your lines will go in here

  'always the last line of callback
  Rejected = "alert('Callback has completed');"
end function

3) Gradually add back in chunks of your function until it breaks.

[RankFirstPro]

Re: Ajax Callback error

Hey everyone, thank you soooo much for giving me advice!! :-)

Jinx - that sounds link a good idea, do you know how to clear args?

Jeff - the session variables are related to the user who is logged in, so the update is happening for the client but I don't require any session variables from that client to produce the results.

Andy - The callback works every time despite the error. I will try now to start from scratch with the callback.

:-)

[-Jinx-]

Re: Ajax Callback error

http://wiki.alphasoftware.com/SQL+Arguments+Object

[RankFirstPro]

Re: Ajax Callback error

Jinx, thank you. I did try implementing your suggestion and was pretty hopefully that it would work but no luck.

Soooo I started stripping everything out and have found out it is related to my detail view... I don't know why or how or how to fix it but for some reason my detail view is not happy with the callback.

Any suggestions? I really wanted to use this layout.

Thanks! :-)

[agillbb]

Re: Ajax Callback error

Are you sure that you have placed a debug(1) at the end of the callback and confirmed that the SQL statement has executed correctly every time?
Why don't you return an alert('completed'); statement as a confirmation that the callback executed correctly.
Note that you currently do not return a js string, and there is no error checking in your xBasic.

[RankFirstPro]

Re: Ajax Callback error

Hi Andy,

I made a video here in hopes to clarify: http://screencast.com/t/t8kX2dKxxs

Thanks soooo so much for your help!

function Rejected as c (e as p)
dim cn as sql::Connection
dim args as sql::arguments
dim sql as c = ""

sql = <<%a%
update client_list
set status = 1
where Client_List_ID = :ID
%a%

cn.open("::name::CompanyProfile")
cn.PortableSQLEnabled = .t.
args.add("ID", 16)

cn.Execute(sql, args)
debug(1)
args.clear()
cn.FreeResult()
cn.close()

Rejected = "alert('completed');"
end function

[agillbb]

Re: Ajax Callback error

Check on how to debug...
video 66: http://news.alphasoftware.com/v11preview/videos_v11.htm
http://www.youtube.com/watch?v=6nSnmjUdU4M

You will want to test the result of your query to see if it was successful:
dim result as L
result = cn.Execute(sql, args)

You will want to step through the lines in the debugger, and check the value of "result".


EDIT...of course, none of this matters if it is the act of making the callback itself causing the problem. Could you confirm whether an empty callback as I had originally posted gives problems?

[omagarc]

Re: Ajax Callback error

This doesn't appear to be related to the callback but rather the grid itself. Are there any filters defined in the sql or any conditions in the grid that are somehow related the the table being updated?

[RankFirstPro]

Re: Ajax Callback error

Hi Omar,

Yes, I agree it with you, the ajax callback is working properly. The grid itself does have to filters Admin_ID = :admin_id AND status = 2

That should be it... I will remove them and see if that makes any difference.

Do you have any other suggestions?

Thanks so much!

[RankFirstPro]

Re: Ajax Callback error

Omar!!! You're a genius! How is this the problem? I don't understand? Is it because of 2 filters?

What do you think?

I need both filters so I don't know how I can do it without them.

THANK YOU THANK YOU THANK YOU!

[RankFirstPro]

Re: Ajax Callback error

I PROMISE YOU... This has helped me so much and my stress so much! I put the filter down to 1 instead of 2 and used a base filter when opening the grid and so far so good.

I'm beyond excited and completely grateful for your suggestion!!!!!!!!!!!!!!!!!! Thank you!!!!!!!!!!!!!!!!!!!!!!

[omagarc]

Re: Ajax Callback error

When you update the record, the grid is still looking for the record. You may want to return: Rejected = "{grid.Object}.refresh();alert('completed');"