Display message during processing records

[agillbb]

Re: Display message during processing records

It doesn't work this way. You send your js response at the end of the callback.
I think you should read through my earlier post carefully....and read up on callbacks. A5 actually gives you tips within the callback function protocol when you create a callback. Good luck...

[-Jinx-]

Re: Display message during processing records

It doesn't work this way. You send your js response at the end of the callback.
I think you should read through my earlier post carefully....and read up on callbacks. A5 actually gives you tips within the callback function protocol when you create a callback. Good luck...

I did read and understand your earlier post. You have always been quite helpful, so I pay attention. ..haha.
I also haven't been clear with exactly what I'm doing since I'm not near my computer it's hard to remember and then type my code with my cell phone.

Anyway, your last post confirms what I've been experiencing. I was just hoping there WAS a way to pass data back through every loop in the xbasic. I tried breaking up xbasic code in separate a5 tags on an a5w page and that didn't work either.

[DaveF]

Re: Display message during processing records

Jinx,

What is the purpose of this long operation? Is it more of a standalone job or an intermediate synchronous operation which must be performed to bring up a web page/component or report?

[-Jinx-]

Re: Display message during processing records

Hi Dave,
The OP was the one doing this long operation. I'm just trying to figure out a progress tracker of some sort as an exercise. I don't particularly need one myself at the moment but it would be nice to get something to work in case I did later.

I figured this would be a good thread to do it in as if someone came up with a solution it would help the OP.

[-Jinx-]

Re: Display message during processing records

OK, to be more clear with what I'm playing with currently:

I have a dialog (just because it makes an easy platform to test with)
In that dialog I have an HTML container with this code:

<div id = "progress" style = "BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid"><div id = "bar" style="BACKGROUND-COLOR: green; WIDTH: 50%">&nbsp</div></div>

Currently I have a textbox field named pcent as well that has this code in it's onChange event:

var p = {dialog.object}.getValue('PCENT');

function setPercentage(id, percent)
{
var div = document.getElementById(id);
div.style.width = percent + "%";
}

setPercentage("bar",p);

So, if I type something into the value or set it my little green bar moves across the screen via changing the inner div's width.

I have an Xbasic function that I'm trying to drive this with. As Andy told me above though, it's probably impossible since there doesn't seem to be a way to throw code back to the javascript side WHILE the loop is running in Xbasic. It only throws the code out at the end.

That looks something like this for testing purposes:

function testProgressBar as c (e as p)
	dim vjscmd as c
	dim percent as n = 1
	dim progress as c
	dim result as C
	dim con as SQL::Connection
	dim args as SQL::Arguments
	if con.open("::Name::MVWKS")	then
			dim sqlCommand as c = "SELECT * FROM [tooling card info]"
				if con.Execute(sqlCommand,args) then
					dim rs as SQL::ResultSet
					rs = con.ResultSet
					'result = con.CallResult
						if rs.NextRow() then
							while rs.NextRow()
								percent = percent + 1
								progress = "{dialog.object}.setValue('PCENT',"+percent+");"
								updateProgress(e, progress)
								'?"<script>" + progress + "</script>"
								'debug(1)
							end while					
						else
						vjscmd = "alert('No record found');"
						end if	
				else
			   vjscmd = "alert('Execute Error: Error returned was: " + js_escape(con.CallResult.text) + "');"
	         end if			
							
	else
			vjscmd = "alert('Connection Error: Error returned was: " + js_escape(con.CallResult.text) + "');"
	end if
	
end function

function updateProgress as c (e as p, progress as c)
'debug(1)
?"<script>" + progress + "</script>"
	'UpdateProgress = progress	

end function

You can see that my latest attempt was to try to use nested functions which didn't work either...haha.


Andy's idea would work and I might play with it a little later. I'd have to somehow come up with a function that takes care of it though because it would suck to have to program that every single time you wanted to use a progress bar. It would probably need to be some javascript function that makes use of it's own loop to fire the multiple callbacks. I'll see.

[agillbb]

Re: Display message during processing records

Jinx, you're making this painful...hang on, let me just code it for you and whoever may wish it....

[-Jinx-]

Re: Display message during processing records

Jinx, you're making this painful...

It wouldn't be the first time!

hang on, let me just code it for you and whoever may wish it....

That would be greatly appreciated. Maybe I'm not seeing it clearly.

[agillbb]

Re: Display message during processing records

Ok, here's the progress bar that would be useful for large callback processes. Darn, took 3/4 of my lunch hour.
CallbackProgress.a5wcmp

[-Jinx-]

Re: Display message during processing records

Thanks Andy,
I've got to play a bit to understand everything BUT..... I did learn one thing by messing with your dialog: On my system and alpha build, it's pretty much impossible to pass a variable with the ajax callback action javascript. I just doesn't get transfered in. No wonder I was having issues getting stuff to work and ended up relying on a5w pages all the time instead of xbasic functions.

Your dialog pointed to me in the right direction since your button was using text mode. If I convert the action javascript for an ajax callback to text it works with no issues. The variable is transfered into the xbasic function.

[alfatrading]

Re: Display message during processing records

First: please have mercy of me, because I'm not accustomed with javascript, Ajax, and asynchronous code.

But this was my think: can't be that the xbasic loop writes to a session variable (or more than one) and a piece of software (client side js, or whatever) go and check asynchronously that session variable(s) and use the data for the progress indicator?

[agillbb]

Re: Display message during processing records

Hi, I guess it could work, and you could perform a simple test case to confirm. There are always many ways to skin a cat.

[wykoff]

Re: Display message during processing records

you can have the xbasic function writing out to an xml file and have the javascript function periodically reading that xml file.

The javascript function would be called using the setInterval() method just before the AJAX call to the xbasic function.

http://www.w3schools.com/js/js_timing.asp
http://www.w3schools.com/xml/xml_http.asp

[alfatrading]

Re: Display message during processing records

Found this article at: http://www.learn alpha.com/WAS_Progr..._Progress.html

It is dated 2005 and uses thread_create() and thread_variables() but it may be still working.

Three version: a simpler % of completion, a graphical bar, and also a "terminate" button

[wykoff]

Re: Display message during processing records

You could have the xbasic function write out records processed to an xml file that a javascript function is reading from.

The javascript function would be launched with a setinterval() or simply launched before firing the xbasic function.

http://www.w3schools.com/js/js_timing.asp

[Jeff Benson]

Re: Display message during processing records

I have a solution. Anyone who wants to help me beta test it please email me at [email protected]. Thanks.

Addendum: I see this post is in V11 thread. My solution has been developed and tested in AA (V12), but it should run in V11 if you want to try it.