Run a Script in the background

[Terrymorgan]

I worked it out that as i also had a wait dialog open i needed to code as follows:-

sys_focus_put()
ui_modeless_dlg_setfocus(vWAITTITLE)

Thanks for all the help

[Terrymorgan]

sys_focus_put() is the default, that documentation says should be :-

Optional. Default = Alpha Anywhere window. The name of the window to receive focus.

[Ted Giles]

I presume that you have a target, a bit like below, in yourSys_focus_put() command?

From the Help Text;
sys_focus_put("Notepad - README.TXT")

[mumfie]

Unfortunately "sys_focus_put()" is not returning to the Alpha Window, leaving the user on the web browser that has opened the URL. How can i force the return to the alpha Window.
or
Is it possible to use something like HTTP POST to run an A5w page without opening the page or just writing the code into an HTTP POST?

Hi Terry,
I don't use desktop and not sure exactly what SYS_FOCUS_PUT does but assume the Alpha UI needs to be running.
The alpha documentation indicates many system functions are not available in web apps so might be a limitation.
https://documentation.alphasoftware....20Function.xml
You can use HTTPPost or HTTP Get and call the a5w page direct from a scheduler with parameters if required.
You can also debug the running processes to verify if the alpha window is running using tools available from
https://learn.microsoft.com/en-us/sy...ocess-explorer

[madtowng]

Since rebuilding the indexes should be done with nobody using the system, why not do the rebuild just before that automatic safe shutdown?
With that said, we are giving the best answers considering you are withholding much of the information about the problem you’re trying to solve. Kinda like telling your tp
fix your car saying it ain’t working right and refusing to give access to your car.

[Terrymorgan]

Too much focus on the index rebuild, as this is just one of 50 items that are run from my own scheduler which work with all sorts of timing, frequency & scripts.
Some time ago i moved to an automatic (safe) shut down of the app each evening, which the prevented the 3am option to rebuild indexes.

Now i have the some of the scheduled scripts running from A5W pages well i am looking for help with post #19

Thanks

[Ted Giles]

Sorry Terry, looks a bit like a design issue.
@Gregg, I sort of suggested a startup or run down index update.

[madtowng]

why not schedule the index rebuild for say 3am. A better option would be to move the data to sql, then zap and repop the dbf an hour before people start working.

[Terrymorgan]

This particular table is inclined to add records that do not appear in the index, and cannot therefore be found by index until such time the indexes have been fixed.
i have a button to do this but all users, have to come out of the system to do this, which is inconvenient
The example code I gave, as one of many scheduled scripts, as part of my scheduler runs first thing each day for the first user who logs on, so there is no one else in the table at that time.
i have added the in use trap in case something like a back up is running
Thanks

[Ted Giles]

Terry, please can you let us know why you have a need to update indices during user activity?
It is unusual to do that as only really oddball situations necessitate a rebuild, and I tend to put a rebuild button in the app - if only a single user - and as an emergency.
if its a record locking issue in a multi user application, there are ways to handle that.

[Terrymorgan]

I tried a few things but have settled with putting the scripts into "a5W" pages & then opening these, which just run outside of Alpha (Desktop), returning full control to the user whist these run.

Two questions:-
This is an example script, to open the URL:-
vURL = vAPPSERVERPATH+"scheduler/scheduleditem0031.a5w"
save_to_file("Being Run from Web Page "+vURL+crlf(),vSCHEDULERLOGFILE,.t.)
sys_open(vURL)
xbasic_wait_for_idle()
sys_focus_put()

Unfortunately "sys_focus_put()" is not returning to the Alpha Window, leaving the user on the web browser that has opened the URL. How can i force the return to the alpha Window.

or

Is it possible to use something like HTTP POST to run an A5w page without opening the page or just writing the code into an HTTP POST?

Thanks

[Terrymorgan]

That line is commented out & only used when testing

[Ted Giles]

ui_msg_box("Notifications","table in Use",UI_OK)

See post #1

[Terrymorgan]

I am working on the Thread example given, and will update.
As an example i rebuild the indexes daily for certain tables and here is some example code:-

vFILENAME = vDBPATH+"Notifications.dbf"
if table.in_use(vFILENAME,.t.)
' ui_msg_box("Notifications","table in Use",UI_OK)
save_to_file("Unable to ReBuild Indexes for Notifications as file is in use"+crlf(),vSCHEDULERLOGFILE,.t.)
else
t = table.open(vFILENAME,FILE_RW_EXCLUSIVE)
t.index_create_begin("Autonumber","Autonumber","","U")
t.index_add("CreatedDate","CreatedDate")
t.index_add("CreatedTime","CreatedTime")
t.index_add("NotCleared","Recno()","ut(status)<>'CLEARED'")
t.index_add("NotificationNo","NotificationNo","","U")
t.index_add("Operator","Operator")
t.index_add("Reference","Reference")
t.index_add("Status","Status")
t.index_add("Uniquequoteno","Uniquequoteno")
t.index_add("Recno","Recno()","","U")
index_pointer = t.index_create_end()
t.close()
save_to_file("Indexes ReBuilt for Notifications"+crlf(),vSCHEDULERLOGFILE,.t.)
end if

Thanks

[Ted Giles]

Thanks.
That's why an "interference diagram" is useful when developing any software.
Saves all sorts of issues down the line.