RE: Excel errors

2016-10-21 Thread Richard Kaye 
That's become a standard part of my exception handling with COM stuff. If I 
catch any kind of error, I check to see if the Word or Excel object is in scope 
and make it visible.

--

rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of rafael 
copquin
Sent: Friday, October 21, 2016 5:36 PM
To: profoxt...@leafe.com
Subject: Re: Excel errors

I solved it!

What I did was make the oExcel object _visible_ just after instantiation 
and before trying to open the file.

if upper(vartype(thisform.oExcel)) <> "O"
 thisform.oExcel=createobject("Excel.Application")
else
 thisform.oExcel=getobject(,"Excel.Application")
endif

thisform.oExcel.visible = .T.

Try

  lOK = .t.

  With thisform.oExcel
 .workbooks.open("")
  endwith

etc

Thank you all anyways

Rafael



On 21/10/2016 18:09, Richard Kaye wrote:
> You've probably got some hidden dialog waiting for an answer asking you if 
> you want to save your changes. Try adding something like this to your 
> exception handling before you call Quit.
>
> m.oExcel.ActiveWorkbook.Saved= .T.&& this prevents Excel prompt when we 
> destroy the Excel object
>
> --
>
> rk
> -Original Message-
> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of rafael 
> copquin
> Sent: Friday, October 21, 2016 4:59 PM
> To: profoxt...@leafe.com
> Subject: Excel errors
>
> I have been using Excel automation for years. However, I could not find
> a way to kill the Excel application when an error occurs.
>
> Here is an example:
>
> I have this cursor with an inventory list that contains 9000 rows and 10
> columns, named curStock.
>
> I save the cursor with:
>
> local cExcel
>
> cExcel = 'c:\temp\stock.xls'
>
> select curStock
>
> copy to (cExcel) type xl5
>
> if upper(vartype(thisform.oExcel)) = "O"
>  thisform.oExcel.quit
>  thisform.oExcel = .f.
> Else
>  thisform.AddProperty('oExcel')
> EndIf
>
> if upper(vartype(thisform.oExcel)) <> "O"
>  thisform.oExcel=createobject("Excel.Application")
> else
>  thisform.oExcel=getobject(,"Excel.Application")
> endif
>
>
> Try
>
>   lOK = .t.
>
>   With thisform.oExcel
>  .workbooks.open("")
>   endwith
>
> Catch to oError
>
>  lOK = .f.
>
>   MessageBox(oError.message,16,'Excel caused an error',2000)
>
> thisform.oExcel.quit
>
> EndTry
>
> if not lOK
>
>   quit
>
> else
>
>   *** show the spreadsheet
>
> endif
>
> The property thisform.oExcel is trying to open the big Excel sheet
> (stock.xls) but fails
>
> Supposedly thisform.Excel.quit should kill the Excel instance.
>
> However it still remains in memory. The task manager shows it is still
> dangling in memory but is invisible.
>
> How can I kill it?
>
> BTW I use this approach instead of filling and formatting the sheet line
> by line, because it takes about half an hour to show, due to the large
> amount of records the cursor contains.
>
> Rafael Copquin
>
>
>
[excessive quoting removed by server]

___
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/bn4pr10mb09130c7b92962bee828684fed2...@bn4pr10mb0913.namprd10.prod.outlook.com
** 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.

Re: Excel errors

2016-10-21 Thread rafael copquin 

I solved it!

What I did was make the oExcel object _visible_ just after instantiation 
and before trying to open the file.


if upper(vartype(thisform.oExcel)) <> "O"
thisform.oExcel=createobject("Excel.Application")
else
thisform.oExcel=getobject(,"Excel.Application")
endif

thisform.oExcel.visible = .T.

Try

 lOK = .t.

 With thisform.oExcel
.workbooks.open("")
 endwith

etc

Thank you all anyways

Rafael



On 21/10/2016 18:09, Richard Kaye wrote:

You've probably got some hidden dialog waiting for an answer asking you if you 
want to save your changes. Try adding something like this to your exception 
handling before you call Quit.

m.oExcel.ActiveWorkbook.Saved= .T.  && this prevents Excel prompt when we 
destroy the Excel object

--

rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of rafael 
copquin
Sent: Friday, October 21, 2016 4:59 PM
To: profoxt...@leafe.com
Subject: Excel errors

I have been using Excel automation for years. However, I could not find
a way to kill the Excel application when an error occurs.

Here is an example:

I have this cursor with an inventory list that contains 9000 rows and 10
columns, named curStock.

I save the cursor with:

local cExcel

cExcel = 'c:\temp\stock.xls'

select curStock

copy to (cExcel) type xl5

if upper(vartype(thisform.oExcel)) = "O"
 thisform.oExcel.quit
 thisform.oExcel = .f.
Else
 thisform.AddProperty('oExcel')
EndIf

if upper(vartype(thisform.oExcel)) <> "O"
 thisform.oExcel=createobject("Excel.Application")
else
 thisform.oExcel=getobject(,"Excel.Application")
endif


Try

  lOK = .t.

  With thisform.oExcel
 .workbooks.open("")
  endwith

Catch to oError

 lOK = .f.

  MessageBox(oError.message,16,'Excel caused an error',2000)

thisform.oExcel.quit

EndTry

if not lOK

  quit

else

  *** show the spreadsheet

endif

The property thisform.oExcel is trying to open the big Excel sheet
(stock.xls) but fails

Supposedly thisform.Excel.quit should kill the Excel instance.

However it still remains in memory. The task manager shows it is still
dangling in memory but is invisible.

How can I kill it?

BTW I use this approach instead of filling and formatting the sheet line
by line, because it takes about half an hour to show, due to the large
amount of records the cursor contains.

Rafael Copquin




[excessive quoting removed by server]

___
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/dd19fc77-3321-c578-6346-164e73724...@gmail.com
** 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.

Re: Excel errors

2016-10-21 Thread mbsoftwaresolutions 
Instead of trying to open your XLS file via Excel Automation, just try 
opening it via a ShellExecute call.


hth,
--Mike


On 2016-10-21 16:59, rafael copquin wrote:

I have been using Excel automation for years. However, I could not
find a way to kill the Excel application when an error occurs.

Here is an example:

I have this cursor with an inventory list that contains 9000 rows and
10 columns, named curStock.

I save the cursor with:

local cExcel

cExcel = 'c:\temp\stock.xls'

select curStock

copy to (cExcel) type xl5

if upper(vartype(thisform.oExcel)) = "O"
   thisform.oExcel.quit
   thisform.oExcel = .f.
Else
   thisform.AddProperty('oExcel')
EndIf

if upper(vartype(thisform.oExcel)) <> "O"
   thisform.oExcel=createobject("Excel.Application")
else
   thisform.oExcel=getobject(,"Excel.Application")
endif


Try

lOK = .t.

With thisform.oExcel
   .workbooks.open("")
endwith

Catch to oError

   lOK = .f.

MessageBox(oError.message,16,'Excel caused an error',2000)

  thisform.oExcel.quit

EndTry

if not lOK

quit

else

*** show the spreadsheet

endif

The property thisform.oExcel is trying to open the big Excel sheet
(stock.xls) but fails

Supposedly thisform.Excel.quit should kill the Excel instance.

However it still remains in memory. The task manager shows it is still
dangling in memory but is invisible.

How can I kill it?

BTW I use this approach instead of filling and formatting the sheet
line by line, because it takes about half an hour to show, due to the
large amount of records the cursor contains.

Rafael Copquin




[excessive quoting removed by server]

___
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/275eadf213c346487e007247739c3...@mbsoftwaresolutions.com
** 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.

RE: Problem with VFP IDE (VFP9SP2, fully patched)

2016-10-21 Thread mbsoftwaresolutions 

On 2016-10-21 09:43, Tracy Pearson wrote:

Are you copying objects from a class on a form?



They're from my mjbbase.vcx, which is merely a copy of the baseclasses 
with little bits of MBSS magic, yes.


___
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/c85bad5ca772ebfa97424531ab876...@mbsoftwaresolutions.com
** 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.

RE: Problem with VFP IDE (VFP9SP2, fully patched)

2016-10-21 Thread mbsoftwaresolutions 

On 2016-10-21 09:29, Dave Crozier wrote:

Mike, try running VFP with admin rights just to see if it is a
permissions issue.

Dave



That fixed the Paste issue.  Bizarre.  Why all of the sudden would this 
be an issue?!?!??


___
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/69d520c0a48fddcd51bcb8c749f51...@mbsoftwaresolutions.com
** 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.

Re: Excel errors

2016-10-21 Thread Sytze de Boer 
I use the following

PARAMETERS whatprg, justchecking

lcProcess=whatprg+".EXE"
lcComputer = "."
loWMIService = GETOBJECT("winmgmts:" +
"{impersonationLevel=impersonate}!\\" + lcComputer + "\root\cimv2")
colProcessList = loWMIService.ExecQuery ("Select * from Win32_Process")

IF TYPE('colProcessList') = "O"
  FOR EACH loProcess IN colProcessList
 IF ALLTRIM(UPPER(loProcess.NAME)) == ALLTRIM(UPPER(lcProcess))
IF justchecking
   iamopen=.t.
   EXIT
endif
trt=MESSAGEBOX("Is it ok to close "+lcProcess+" ?",4+32,'')
IF trt=6
   loProcess.TERMINATE()
   exit
ENDIF
  NEXT
ENDIF  && IF TYPE('colProcessList') = "O"

RELEASE colProcessList, loWMIService


On Sat, Oct 22, 2016 at 9:59 AM, rafael copquin 
wrote:

> I have been using Excel automation for years. However, I could not find a
> way to kill the Excel application when an error occurs.
>
> Here is an example:
>
> I have this cursor with an inventory list that contains 9000 rows and 10
> columns, named curStock.
>
> I save the cursor with:
>
> local cExcel
>
> cExcel = 'c:\temp\stock.xls'
>
> select curStock
>
> copy to (cExcel) type xl5
>
> if upper(vartype(thisform.oExcel)) = "O"
>thisform.oExcel.quit
>thisform.oExcel = .f.
> Else
>thisform.AddProperty('oExcel')
> EndIf
>
> if upper(vartype(thisform.oExcel)) <> "O"
>thisform.oExcel=createobject("Excel.Application")
> else
>thisform.oExcel=getobject(,"Excel.Application")
> endif
>
>
> Try
>
> lOK = .t.
>
> With thisform.oExcel
>.workbooks.open("")
> endwith
>
> Catch to oError
>
>lOK = .f.
>
> MessageBox(oError.message,16,'Excel caused an error',2000)
>
>   thisform.oExcel.quit
>
> EndTry
>
> if not lOK
>
> quit
>
> else
>
> *** show the spreadsheet
>
> endif
>
> The property thisform.oExcel is trying to open the big Excel sheet
> (stock.xls) but fails
>
> Supposedly thisform.Excel.quit should kill the Excel instance.
>
> However it still remains in memory. The task manager shows it is still
> dangling in memory but is invisible.
>
> How can I kill it?
>
> BTW I use this approach instead of filling and formatting the sheet line
> by line, because it takes about half an hour to show, due to the large
> amount of records the cursor contains.
>
> Rafael Copquin
>
>
>
[excessive quoting removed by server]

___
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/cag1nny95erbknuu+r6hj93knjnmigecytxnef1bvp+z0uyq...@mail.gmail.com
** 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.

RE: Excel errors

2016-10-21 Thread Richard Kaye 
You've probably got some hidden dialog waiting for an answer asking you if you 
want to save your changes. Try adding something like this to your exception 
handling before you call Quit.

m.oExcel.ActiveWorkbook.Saved= .T.  && this prevents Excel prompt when we 
destroy the Excel object

--

rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of rafael 
copquin
Sent: Friday, October 21, 2016 4:59 PM
To: profoxt...@leafe.com
Subject: Excel errors

I have been using Excel automation for years. However, I could not find 
a way to kill the Excel application when an error occurs.

Here is an example:

I have this cursor with an inventory list that contains 9000 rows and 10 
columns, named curStock.

I save the cursor with:

local cExcel

cExcel = 'c:\temp\stock.xls'

select curStock

copy to (cExcel) type xl5

if upper(vartype(thisform.oExcel)) = "O"
thisform.oExcel.quit
thisform.oExcel = .f.
Else
thisform.AddProperty('oExcel')
EndIf

if upper(vartype(thisform.oExcel)) <> "O"
thisform.oExcel=createobject("Excel.Application")
else
thisform.oExcel=getobject(,"Excel.Application")
endif


Try

 lOK = .t.

 With thisform.oExcel
.workbooks.open("")
 endwith

Catch to oError

lOK = .f.

 MessageBox(oError.message,16,'Excel caused an error',2000)

   thisform.oExcel.quit

EndTry

if not lOK

 quit

else

 *** show the spreadsheet

endif

The property thisform.oExcel is trying to open the big Excel sheet 
(stock.xls) but fails

Supposedly thisform.Excel.quit should kill the Excel instance.

However it still remains in memory. The task manager shows it is still 
dangling in memory but is invisible.

How can I kill it?

BTW I use this approach instead of filling and formatting the sheet line 
by line, because it takes about half an hour to show, due to the large 
amount of records the cursor contains.

Rafael Copquin



[excessive quoting removed by server]

___
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/bn4pr10mb091323d1948c57e929eecb62d2...@bn4pr10mb0913.namprd10.prod.outlook.com
** 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.

RE: Speeding up a Powershell script

2016-10-21 Thread Richard Kaye 
+1 to RegexBuddy. 

--

rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Darren
Sent: Friday, October 21, 2016 4:43 PM
To: profoxt...@leafe.com
Subject: RE: Speeding up a Powershell script

My view ... RegExp syntax is fairly limited in scope and relatively easy to
learn. Powershell is a whole other beast.

I have used a fantastic tool to work with and develop RegExp for a few years
now and the small investment has paid over time and again ..

https://www.regexbuddy.com/  recommend it highly !!


___
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/bn4pr10mb0913e82add84ee592ae2bffbd2...@bn4pr10mb0913.namprd10.prod.outlook.com
** 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.

Excel errors

2016-10-21 Thread rafael copquin 
I have been using Excel automation for years. However, I could not find 
a way to kill the Excel application when an error occurs.


Here is an example:

I have this cursor with an inventory list that contains 9000 rows and 10 
columns, named curStock.


I save the cursor with:

local cExcel

cExcel = 'c:\temp\stock.xls'

select curStock

copy to (cExcel) type xl5

if upper(vartype(thisform.oExcel)) = "O"
   thisform.oExcel.quit
   thisform.oExcel = .f.
Else
   thisform.AddProperty('oExcel')
EndIf

if upper(vartype(thisform.oExcel)) <> "O"
   thisform.oExcel=createobject("Excel.Application")
else
   thisform.oExcel=getobject(,"Excel.Application")
endif


Try

lOK = .t.

With thisform.oExcel
   .workbooks.open("")
endwith

Catch to oError

   lOK = .f.

MessageBox(oError.message,16,'Excel caused an error',2000)

  thisform.oExcel.quit

EndTry

if not lOK

quit

else

*** show the spreadsheet

endif

The property thisform.oExcel is trying to open the big Excel sheet 
(stock.xls) but fails


Supposedly thisform.Excel.quit should kill the Excel instance.

However it still remains in memory. The task manager shows it is still 
dangling in memory but is invisible.


How can I kill it?

BTW I use this approach instead of filling and formatting the sheet line 
by line, because it takes about half an hour to show, due to the large 
amount of records the cursor contains.


Rafael Copquin



___
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/7b206292-d9f3-10ce-bfa6-a73eb5a15...@fibertel.com.ar
** 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.

RE: Speeding up a Powershell script

2016-10-21 Thread Darren 
My view ... RegExp syntax is fairly limited in scope and relatively easy to
learn. Powershell is a whole other beast.

I have used a fantastic tool to work with and develop RegExp for a few years
now and the small investment has paid over time and again ..

https://www.regexbuddy.com/  recommend it highly !!




-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Edward
Leafe
Sent: Saturday, 22 October 2016 7:36 AM
To: profoxt...@leafe.com
Subject: Re: Speeding up a Powershell script

On Oct 21, 2016, at 1:53 PM, Gene Wirchenko  wrote:
> 
>> +1.  It's like the UberNerds who want to obfuscate just for the "fun" of
it to be UberNerds.  I felt similar about RegExp.
> 
> Regexes can be great, but I resist the temptation to make long
regexes.  That gets in write-only code all too fast.  Instead, I might use a
couple of shorter ones with a bit of glue code.

Complex? Just add comments!

http://www.diveintopython.net/regular_expressions/verbose.html


-- Ed Leafe






[excessive quoting removed by server]

___
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/006401d22bdb$b7e005f0$27a011d0$@ozemail.com.au
** 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.

Re: Speeding up a Powershell script

2016-10-21 Thread Edward Leafe 
On Oct 21, 2016, at 1:53 PM, Gene Wirchenko  wrote:
> 
>> +1.  It's like the UberNerds who want to obfuscate just for the "fun" of it 
>> to be UberNerds.  I felt similar about RegExp.
> 
> Regexes can be great, but I resist the temptation to make long regexes.  
> That gets in write-only code all too fast.  Instead, I might use a couple of 
> shorter ones with a bit of glue code.

Complex? Just add comments!

http://www.diveintopython.net/regular_expressions/verbose.html


-- Ed Leafe






___
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/ff755d67-397c-40cd-9cb9-bbc7d0942...@leafe.com
** 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.

Re: Speeding up a Powershell script

2016-10-21 Thread Gene Wirchenko 

At 05:01 2016-10-21, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote:

On 2016-10-19 09:43, Malcolm Greene wrote:

A great use case for getting your feet wet with Python.
BTW: Powershell syntax wants me to gouge my eyes out. Anyone else feel
the same way?


 I guess I just do not have your enthusiasm.   I just look 
away.  Yes, I think it is ugly.


+1.  It's like the UberNerds who want to obfuscate just for the 
"fun" of it to be UberNerds.  I felt similar about RegExp.


 Regexes can be great, but I resist the temptation to make long 
regexes.  That gets in write-only code all too fast.  Instead, I 
might use a couple of shorter ones with a bit of glue code.


Sincerely,

Gene Wirchenko


___
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/97ed57a7b6a6b1e0dd1517ec38929ae7@mtlp87
** 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.

RE: Problem with VFP IDE (VFP9SP2, fully patched)

2016-10-21 Thread Tracy Pearson 
Are you copying objects from a class on a form?

On October 21, 2016 9:29:28 AM EDT, Dave Crozier  wrote:
>Mike, try running VFP with admin rights just to see if it is a
>permissions issue.
>
>Dave
>
>-Original Message-
>From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of
>mbsoftwaresoluti...@mbsoftwaresolutions.com
>Sent: 21 October 2016 12:59
>To: profox@leafe.com
>Subject: Problem with VFP IDE (VFP9SP2, fully patched)
>
>This just started yesterday.  I can Copy objects on a form, but it
>won't let me paste them.  In fact, the paste option is disabled when I
>right-click to do so.  So bizarre.  Copy/paste works outside VFP.
>
>I've applied Windows Updates recently.  That's the only change in the
>system, afaik.
>
>Anybody ever seen this before?
>
>
-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.

___
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/f1be2094-a147-4966-8af3-1cade09ce...@powerchurch.com
** 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.

Re: Speeding up a Powershell script

2016-10-21 Thread Stephen Russell 
Powershell is "obectized" batch files.  Your nerd status is reduced when
you diss objects like that.

https://gallery.technet.microsoft.com/scriptcenter/Remove-Windows-Store-Apps-a00ef4a4

because powershell is very cool.  I have 25-30 scripts that I run monthly
for a variety of odd reasons.  Sharepoint information, reporting and
possibly control as well as similar things in SQL Server.

On Fri, Oct 21, 2016 at 7:01 AM, <
mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote:

> On 2016-10-19 09:43, Malcolm Greene wrote:
>
>> A great use case for getting your feet wet with Python.
>>
>> BTW: Powershell syntax wants me to gouge my eyes out. Anyone else feel
>> the same way?
>>
>> Malcolm
>>
>
>
> +1.  It's like the UberNerds who want to obfuscate just for the "fun" of
> it to be UberNerds.  I felt similar about RegExp.
>
[excessive quoting removed by server]

___
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/cajidmyjtg_n1lsq1hdrumvutz0tlarwvuowkvindjy3mfq+...@mail.gmail.com
** 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.

RE: Problem with VFP IDE (VFP9SP2, fully patched)

2016-10-21 Thread Dave Crozier 
Mike, try running VFP with admin rights just to see if it is a permissions 
issue.

Dave

-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of 
mbsoftwaresoluti...@mbsoftwaresolutions.com
Sent: 21 October 2016 12:59
To: profox@leafe.com
Subject: Problem with VFP IDE (VFP9SP2, fully patched)

This just started yesterday.  I can Copy objects on a form, but it won't let me 
paste them.  In fact, the paste option is disabled when I right-click to do so. 
 So bizarre.  Copy/paste works outside VFP.

I've applied Windows Updates recently.  That's the only change in the system, 
afaik.

Anybody ever seen this before?

[excessive quoting removed by server]

___
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/18725b8cd2d5d247873a2baf401d4ab2a434c...@ex2010-a-fpl.fpl.LOCAL
** 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.

Re: Problem with VFP IDE (VFP9SP2, fully patched)

2016-10-21 Thread mbsoftwaresolutions 

On 2016-10-21 08:15, Tracy Pearson wrote:

Is the scx or sct file read only?
Are you attempting to paste on an item that is not a container?



No, this is a new CREATE FORM form.  No classes either--straight VFP 
base controls.


___
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/196b99e933f91be92f27cb6a28d41...@mbsoftwaresolutions.com
** 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.

Re: Command button to take a photo

2016-10-21 Thread Wollenhaupt, Christof 
>
> Do you think the process is the same for an in-built camera as it is for a
> usb camera?
>

Yes, the process causes the same kind of headache for a built-in camera vs
an external USB camera. Here is the summary of taking pictures in VFP from
my sensor session last year:

CameraCaptureUi
- Only available in Windows Store Apps

MediaCapture
- Crashes, probably due to driver issue

TWAIN
- Complicated, hard to get drivers

Windows Image Aqcuisition
- Kind of works, but low resolution and camera keeps disappearing

HTML 5 getUserMedia
- Works in Edge and Chrome, but can‘t easily embed those


TWAIN is covered in the article from Mile Lewis, Windows Image Acquisition
is the news2news solution that is also on the FoxPro wiki. Using the camera
application gives much better pictures, but zero control over the image
taking process and picture location.

-- 
Christof


--- 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/CAL4QJhgn_CXnELeL=N7zTDiJBsdXz5zagFFzMJZ=mSX6POWV=a...@mail.gmail.com
** 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.

Re: Command button to take a photo

2016-10-21 Thread Tracy Pearson 
My experience with the API is hit and miss depending on the hardware.

I occasionally look for another solution.

On October 21, 2016 1:04:04 AM EDT, Andrew Stirling  
wrote:
>Heres another article
>http://www.ml-consult.co.uk/foxst-29.htm
>
>
>
>Andrew Stirling
>
>On 20/10/2016 22:44, Chris Davis wrote:
>> http://fox.wikis.com/wc.dll?Wiki~VideoCaptureApi
>>
>> On 20 Oct 2016, at 22:37, Sytze de Boer
>> wrote:
>>
>> In my application, which will be installed on a tablet or laptop, I
>need a
>> command button which will take a photograph.
>>
>> As I understand it, these photos will always automatically be stored
>in a
>> specific folder.
>> Is this possible?
>> Is there someone who has done this and willing to share the source?
>>
>>
>>
>> --
>> Kind regards,
>> Sytze de Boer
>>
>
>---

-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.

___
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/5da2d449-f736-45d3-98a3-975de6dbd...@powerchurch.com
** 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.

Re: Problem with VFP IDE (VFP9SP2, fully patched)

2016-10-21 Thread Tracy Pearson 
Is the scx or sct file read only?
Are you attempting to paste on an item that is not a container?

On October 21, 2016 7:59:15 AM EDT, mbsoftwaresoluti...@mbsoftwaresolutions.com 
wrote:
>This just started yesterday.  I can Copy objects on a form, but it
>won't 
>let me paste them.  In fact, the paste option is disabled when I 
>right-click to do so.  So bizarre.  Copy/paste works outside VFP.
>
>I've applied Windows Updates recently.  That's the only change in the 
>system, afaik.
>
>Anybody ever seen this before?
>

-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.

___
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/e9d5b140-80b9-4cf8-8b20-f1fb1006b...@powerchurch.com
** 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.

Re: Speeding up a Powershell script

2016-10-21 Thread mbsoftwaresolutions 

On 2016-10-19 09:43, Malcolm Greene wrote:

A great use case for getting your feet wet with Python.

BTW: Powershell syntax wants me to gouge my eyes out. Anyone else feel
the same way?

Malcolm



+1.  It's like the UberNerds who want to obfuscate just for the "fun" of 
it to be UberNerds.  I felt similar about RegExp.


___
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/68a2202b9b72c4b2430ebeb4c6362...@mbsoftwaresolutions.com
** 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.

Problem with VFP IDE (VFP9SP2, fully patched)

2016-10-21 Thread mbsoftwaresolutions 
This just started yesterday.  I can Copy objects on a form, but it won't 
let me paste them.  In fact, the paste option is disabled when I 
right-click to do so.  So bizarre.  Copy/paste works outside VFP.


I've applied Windows Updates recently.  That's the only change in the 
system, afaik.


Anybody ever seen this before?

___
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/fdb708513f1cae5ce204f66f8e9bd...@mbsoftwaresolutions.com
** 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.

RE: [NF] Need SyncBackSE alternative

2016-10-21 Thread Dave Crozier 
Ken,
Used Syncpack Pro for years and currently on 4TB usb drive backing up from 
network with no problems using mirror copy on Windows 10 host.

I must admit the pre copy scan takes some time for large folders but it always 
works with no problems.

Have you had a look at Teracopy (Freeware) or Microsoft's own Richcopy (Free).

Dave

-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Ken McGinnis
Sent: 21 October 2016 00:39
To: ProFox Email List 
Subject: [NF] Need SyncBackSE alternative

I learned about SyncBackSE on this list years ago and have been using it 
successfully.

However, I have been moving my backups to 5TB drives and SyncBack cannot handle 
it. Yes, it does work with large drives; the problem is that stupid (my opinion 
of course) need to 'scan' the drives before even starting the copy/mirror. I 
often get an error that stops the program related to 'out of memory' during the 
scan. My main backup system is a ASUS Win10 computer with 16GB memory and 52 TB 
of storage internally and on external drives. It seems to me that should be 
enough memory for a computer that is used primarily for backing up drives on 
other computers on the network. The other issue is the failure to be able to 
email a log and access a FTP server if I am using the Win10 built in 
administrator (I won't tell you my opinion about M$ decision to have 2 levels of
Admin) Note that Filezilla client can access the FTP server with no problem 
regardless of the login so I know there is no problem with the credentials or 
FTP server or internet access.

I found mention about WinSCP in my notes and I see that I tried it in
2014 and decided not to use it (I don't remember why not?)

Anyone have any suggestions?


Xcopy, of course, handles any drive any size but does not have some options 
that are important to me.

[excessive quoting removed by server]

___
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/18725b8cd2d5d247873a2baf401d4ab2a434c...@ex2010-a-fpl.fpl.LOCAL
** 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.

Re: [NF] Need SyncBackSE alternative

2016-10-21 Thread Man-wai Chang 
If you are on Linux, most Google results point to the use of rsync
with SSH tunnel 

On Fri, Oct 21, 2016 at 7:38 AM, Ken McGinnis  wrote:
> I learned about SyncBackSE on this list years ago and have been using it
> successfully.
>
> However, I have been moving my backups to 5TB drives and SyncBack cannot
> handle it. Yes, it does work with large drives; the problem is that stupid

-- 
 .~. Might, Courage, Vision. SINCERITY!
/ v \ 64-bit Ubuntu 9.10 (Linux kernel 2.6.39.3)
/( _ )\ http://sites.google.com/site/changmw
^ ^ May the Force and farces be with you!

___
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/CAGv=mjbwrxr1k_-dj1wypb9zm_hdi8swonq657pbv28jjgm...@mail.gmail.com
** 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.

Re: [NF] Need SyncBackSE alternative

2016-10-21 Thread Alan Bourke 
Are you using the backup over FTP functionality of SyncBack Ken? It's
not clear from your post.

Maybe you could use Macrium Reflect Free on each computer to run a
scheduled image job to a shared location on the storage PC?  Are they
all on the same LAN?


-- 
  Alan Bourke
  alanpbourke (at) fastmail (dot) fm

___
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/1477039087.499617.762897353.7e420...@webmail.messagingengine.com
** 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.

Re: Speeding up a Powershell script

2016-10-21 Thread Man-wai Chang 
On Thu, Oct 20, 2016 at 10:50 PM, Dave Crozier  wrote:
> I hope you didn't take the comment as disrespectful as It wasn't meant to be 
> in any way at all ;-)

Of course not. It's easier to do it in Visual Foxpro!

> I must admit that Powershell is a little like Regular Expressions in that 
> once you use it on a regular basis it seems simple but if you only visit it 
> once in a blue moon then the learning or re-learning curve is huge!
> Hope you found a solution anyway.

Iterating the $AllFiles is the fastest way out I believe. Well, let
see whether I could copy some codes from others... :)

-- 
 .~. Might, Courage, Vision. SINCERITY!
/ v \ 64-bit Ubuntu 9.10 (Linux kernel 2.6.39.3)
/( _ )\ http://sites.google.com/site/changmw
^ ^ May the Force and farces be with you!

___
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/CAGv=MJCmrPvH8UJQUsGdvyfribjJiP91qOc5=ahtjvttzhc...@mail.gmail.com
** 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.