Good afternoon,
Going nuts down here, have a simple executable generated from a single program. Runs fine by itself. Grabs s few records then sends out an email via Outlook automation. Which, btw, does Outlook have to be open to run, or not? In any event if I run it in the task schedule it shows that it is running, but it never stops or returns to the ready status????
Regards, Desmond
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---
Do you have an error handler? It should not present a UI, that causes an error and could hang the executable. You might want to exit with the ExitProcess api when there is an error.
DECLARE ExitProcess IN WIN32API Integer ExitCode
I usually use a negative number when something didn't work right. ExitProcess(-1)
HTH, Tracy
-----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Desmond Lloyd Sent: Monday, June 11, 2018 5:33 PM To: profoxtech@leafe.com Subject: VFP: Task Scheduler
Good afternoon,
Going nuts down here, have a simple executable generated from a single program. Runs fine by itself. Grabs s few records then sends out an email via Outlook automation. Which, btw, does Outlook have to be open to run, or not? In any event if I run it in the task schedule it shows that it is running, but it never stops or returns to the ready status????
Regards, Desmond
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---
[excessive quoting removed by server]
If you're using drive letter mappings, those mappings do not exist for the Task Scheduler. Won't find any data.
You can do the mappings in a batch file,
Fred
On Mon, Jun 11, 2018 at 2:33 PM Desmond Lloyd desmond.lloyd@gmail.com wrote:
Good afternoon,
Going nuts down here, have a simple executable generated from a single program. Runs fine by itself. Grabs s few records then sends out an email via Outlook automation. Which, btw, does Outlook have to be open to run, or not? In any event if I run it in the task schedule it shows that it is running, but it never stops or returns to the ready status????
Regards, Desmond
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html
[excessive quoting removed by server]
On Mon, Jun 11, 2018 at 6:35 PM, Fred Taylor fbtaylor@gmail.com wrote:
If you're using drive letter mappings, those mappings do not exist for the Task Scheduler. Won't find any data.
You can do the mappings in a batch file,
Or you could use UNC drive pathing.
Also, there's an option to set the user context in which to run the job, if you need permissions to access resources.
You should have a config file included in the EXE where you set OFF talk, resource, help, etc. so you don't get console or locate dialogs on startup.
And you need logs, of course. Good possibility there's a USE or file function that's popping up a dialog.
If it's a modal dialog, then you can use SYS(2335) Unattended Server Mode and trap it.
Ricardo.
On 12 June 2018 at 11:44, Ted Roche tedroche@gmail.com wrote:
On Mon, Jun 11, 2018 at 6:35 PM, Fred Taylor fbtaylor@gmail.com wrote:
If you're using drive letter mappings, those mappings do not exist for
the
Task Scheduler. Won't find any data.
You can do the mappings in a batch file,
Or you could use UNC drive pathing.
Also, there's an option to set the user context in which to run the job, if you need permissions to access resources.
You should have a config file included in the EXE where you set OFF talk, resource, help, etc. so you don't get console or locate dialogs on startup.
And you need logs, of course. Good possibility there's a USE or file function that's popping up a dialog.
-- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com
[excessive quoting removed by server]
Thanks everyone! If I run the executable it dos popup a window, it's empty and quickly goes away..... So I can add a config.fpw file to the project to set screen off etc.?
Regards, Desmond
On Tue, 12 Jun 2018 at 09:05, Ricardo Molina diskel.ram@gmail.com wrote:
If it's a modal dialog, then you can use SYS(2335) Unattended Server Mode and trap it.
Ricardo.
On 12 June 2018 at 11:44, Ted Roche tedroche@gmail.com wrote:
On Mon, Jun 11, 2018 at 6:35 PM, Fred Taylor fbtaylor@gmail.com wrote:
If you're using drive letter mappings, those mappings do not exist for
the
Task Scheduler. Won't find any data.
You can do the mappings in a batch file,
Or you could use UNC drive pathing.
Also, there's an option to set the user context in which to run the job, if you need permissions to access resources.
You should have a config file included in the EXE where you set OFF talk, resource, help, etc. so you don't get console or locate dialogs on startup.
And you need logs, of course. Good possibility there's a USE or file function that's popping up a dialog.
-- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com
[excessive quoting removed by server]
Which, btw, does Outlook have to be open to run, or not?
No, the automation will fire it up if it's not running.
In any event if I run it in the task schedule it shows that it is running, but it never stops or returns to the ready status????
And does the comprehensive logging to text file that you've put into your EXE indicate how far it's getting? ;)
Desmond, Beware if using different versions of outlook as Createobject() and Getobject() behave in differing ways to what you would expect.
CreateObject() will attach itself to the running version of Outlook rather than starting a new instance which you would expect. In effect is is just as though you had issued a GetObject().
This can have an effect on your program flow if the user uses the instance of Outlook whilst you are controlling it in code - worst scenario is to close outlook completely of course!
Office 2003 and versions prior did not suffer from this problem and CreateObject() always used to start a new instance.
Dave
--------------------------------------------------------------- This communication and the information it contains is intended for the person or organisation to whom it is addressed. Its contents are confidential and may be protected in law. If you have received this e-mail in error you must not copy, distribute or take any action in reliance on it. Unauthorised use, copying or disclosure of any of it may be unlawful. If you have received this message in error, please notify us immediately by telephone or email.
Flexipol Packaging Ltd. has taken every reasonable precaution to minimise the risk of virus transmission through email and therefore any files sent via e-mail will have been checked for known viruses. However, you are advised to run your own virus check before opening any attachments received as Flexipol Packaging Ltd will not in any event accept any liability whatsoever once an e-mail and/or any attachment is received.
It is the responsibility of the recipient to ensure that they have adequate virus protection.
Flexipol Packaging Ltd. Unit 14 Bentwood Road Carrs Industrial Estate Haslingden Rossendale Lancashire BB4 5HH
Tel:01706-222792 Fax: 01706-224683 www.Flexipol.co.uk ---------------------------------------------------------------
Terms & Conditions:
Notwithstanding delivery and the passing of risk in the goods, the property in the goods shall not pass to the buyer until the seller Flexipol Packaging Ltd. ("The Company") has received in cash or cleared funds payment in full of the price of the goods and all other goods agreed to be sold by the seller to the buyer for which payment is then due. Until such time as the property in the goods passes to the buyer, the buyer shall hold the goods as the seller's fiduciary agent and bailee and keep the goods separate from those of the buyer and third parties and properly stored protected and insured and identified as the seller's property but shall be entitled to resell or use the goods in the ordinary course of its business. Until such time as the property in the goods passes to the buyer the seller shall be entitled at any time
-----Original Message----- From: ProFox profox-bounces@leafe.com On Behalf Of Desmond Lloyd Sent: 11 June 2018 22:33 To: ProFox Email List profox@leafe.com Subject: VFP: Task Scheduler
Good afternoon,
Going nuts down here, have a simple executable generated from a single program. Runs fine by itself. Grabs s few records then sends out an email via Outlook automation. Which, btw, does Outlook have to be open to run, or not? In any event if I run it in the task schedule it shows that it is running, but it never stops or returns to the ready status????
Regards, Desmond
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---
_______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CAAJXvaO0kHRYFCZHNnTi0zoF51WxciALC9b_... ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Is there a work around? Am using O365 Outlook in my testing, actual environment will be Office 2016 using a "real" exchange server?
Thank You! Regards, Desmond
On Tue, 12 Jun 2018 at 03:29, Dave Crozier DaveC@flexipol.co.uk wrote:
Desmond, Beware if using different versions of outlook as Createobject() and Getobject() behave in differing ways to what you would expect.
CreateObject() will attach itself to the running version of Outlook rather than starting a new instance which you would expect. In effect is is just as though you had issued a GetObject().
This can have an effect on your program flow if the user uses the instance of Outlook whilst you are controlling it in code - worst scenario is to close outlook completely of course!
Office 2003 and versions prior did not suffer from this problem and CreateObject() always used to start a new instance.
Dave
This communication and the information it contains is intended for the person or organisation to whom it is addressed. Its contents are confidential and may be protected in law. If you have received this e-mail in error you must not copy, distribute or take any action in reliance on it. Unauthorised use, copying or disclosure of any of it may be unlawful. If you have received this message in error, please notify us immediately by telephone or email.
Flexipol Packaging Ltd. has taken every reasonable precaution to minimise the risk of virus transmission through email and therefore any files sent via e-mail will have been checked for known viruses. However, you are advised to run your own virus check before opening any attachments received as Flexipol Packaging Ltd will not in any event accept any liability whatsoever once an e-mail and/or any attachment is received.
It is the responsibility of the recipient to ensure that they have adequate virus protection.
Flexipol Packaging Ltd. Unit 14 Bentwood Road Carrs Industrial Estate Haslingden Rossendale Lancashire BB4 5HH
Tel:01706-222792 Fax: 01706-224683 www.Flexipol.co.uk
Terms & Conditions:
Notwithstanding delivery and the passing of risk in the goods, the property in the goods shall not pass to the buyer until the seller Flexipol Packaging Ltd. ("The Company") has received in cash or cleared funds payment in full of the price of the goods and all other goods agreed to be sold by the seller to the buyer for which payment is then due. Until such time as the property in the goods passes to the buyer, the buyer shall hold the goods as the seller's fiduciary agent and bailee and keep the goods separate from those of the buyer and third parties and properly stored protected and insured and identified as the seller's property but shall be entitled to resell or use the goods in the ordinary course of its business. Until such time as the property in the goods passes to the buyer the seller shall be entitled at any time
-----Original Message----- From: ProFox profox-bounces@leafe.com On Behalf Of Desmond Lloyd Sent: 11 June 2018 22:33 To: ProFox Email List profox@leafe.com Subject: VFP: Task Scheduler
Good afternoon,
Going nuts down here, have a simple executable generated from a single program. Runs fine by itself. Grabs s few records then sends out an email via Outlook automation. Which, btw, does Outlook have to be open to run, or not? In any event if I run it in the task schedule it shows that it is running, but it never stops or returns to the ready status????
Regards, Desmond
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html
[excessive quoting removed by server]