ProFox

profox@leafe.com

2704 discussions

SQLite & Thunderbird - (Was - RE: Friday Poll (while dl'ing MS Flash Patch))
by Kurt Wendt 29 Oct '16

29 Oct '16

Hate to pull this TOO Far off topic. But, since SQLite was brought up. Wasn't it mentioned here that it was used as the data for Mozilla Thunderbird - the e-mail reader? I'm still having a problem in Thunderbird - but only on my laptop - where NO Emails show up in the Sent folder. I even did some research on Google - but, could not seem to find a real answer to my problem. Regards, Kurt Wendt Senior Systems Analyst Tel. +1-212-747-9100 www.GlobeTax.com -----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Vince Teachout Sent: Friday, October 28, 2016 12:50 PM To: profoxtech(a)leafe.com Subject: Re: Friday Poll (while dl'ing MS Flash Patch) On 10/28/2016 9:54 AM, Dave Crozier wrote: > M$SQL 2012 > VFP Databases > SQLite How do you like SQLite, Dave? I've downloaded it and planning to start playing with it so I can start Android programming. [excessive quoting removed by server]

3 3

Taking a screenshot of "yourself"
by Man-wai Chang 29 Oct '16

29 Oct '16

Is there a VFP function that does it? Win32API needed? -- .~. 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!

5 6

[NF] Why consider Node.js
by Stephen Russell 26 Oct '16

26 Oct '16

If you are not aware of it it is a great platform if you can say platform because it is js. We are talking about it for some stuff here. https://www.youtube.com/watch?v=9JOfetqIXd0 -- Stephen Russell Sr. Analyst Ring Container Technology Oakland TN 901.246-0159 cell --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

2 1

[NF] Save Video from cable TV
by Ken Kixmoeller (ProFox) 26 Oct '16

26 Oct '16

Hey - -- Because of my famous dog (https://www.instagram.com/caninehappyhour/) I need to be able to: -- record live (cable) TV, and -- gain access to the files in order to edit them. We aren't big TV folks, and we have never had a DVR. I'd be willing to buy an inexpensive one, but shopping and Googling confuses the heck out of me. For example i see these: -- https://www.amazon.com/AVerMedia-EzRecorder-Definition-Recording-ER130/dp/B… I see I have to add my own USB hard disk (which I have). Would that do it? Slingbox: -- https://www.amazon.com/Sling-Media-SB375-100-Slingbox-M2/dp/B011QHAOWO Would that do it? Also: https://www.amazon.com/Hauppauge-1212-Definition-Personal-Recorder/dp/B0018… PVR? Personal Video Recorder? Comcast is our provider. Is there a way to do this without additional hardware? I need to record stuff Thursday & Friday. Anybody willing to give me a kick me in the right direction? Ken --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

13 29

Weird object parameter passing problem...
by Dave Crozier 24 Oct '16

24 Oct '16

Gentlemen, I have a weird problem that I have solved but not using the way I wanted it to work: 1. Container which has textboxes, comboboxes in it the whole container being a class. No controlsources bound to the class at designtime. Container has a property added to it called oData with an assign method. 2. Form holding the class has a private datasession with a grid on the form containing the data record by record which needs to be displayed in the container. 3. In the grid rowcolchange method the data from the current record is scattered directly to a form property object oData which is immediately assigned to the oData Property in the container - so there is one form data object that the container can see through the oData property of its own. 4. In the container, the assign method of oData binds the various field "controlSource" in the object to the properties of the container oData. Example: This.txtId.controlsource = "This.odata.id" 5. When run ... and debugged line by line into the assign method of oData in the container, VFP complains that oData (the container oData not the form oData) cannot be found despite the fact that if you specify it in the watch list it can be seen perfectly and the program continues without problem or further errors if the error is ignored. The same error occurs regardless of debug being used. I have found a way around the problem by not doing the double assign i.e. the scatter into the form property oData and then simply binding the controls in the container in the assign statement to <<control>>.Controlsource="Thisform.oData.<<property>>". Although it works I really want to make the assignments non specific so I can pass an object reference from anywhere but at least it solves the problem short term. Anyone any ideas? If you want an example of this then I can post up a link. Dave --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

3 2

Problem with VFP IDE (VFP9SP2, fully patched)
by mbsoftwaresolutions＠mbsoftwaresolutions.com 24 Oct '16

24 Oct '16

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?

5 10

Excel errors
by rafael copquin 24 Oct '16

24 Oct '16

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("&cExcel") 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

6 8

Re: Speeding up a Powershell script
by Gene Wirchenko 24 Oct '16

24 Oct '16

At 05:01 2016-10-21, mbsoftwaresolutions(a)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. <BEG> 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

5 4

[NF] Command Line programming
by Stephen Russell 22 Oct '16

22 Oct '16

Simple intro on making apps from the command line. https://docs.microsoft.com/en-us/dotnet/articles/core/tools/ If the .NET IDE gets in the way you can do simple stuff this way. -- Stephen Russell Sr. Analyst Ring Container Technology Oakland TN 901.246-0159 cell --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

1 0

Speeding up a Powershell script
by Man-wai Chang 21 Oct '16

21 Oct '16

The following Powershell script aims to count and calculate file sizes of each unique file extension in the current folder recursively. How would you speed up this script for a folder with over 170000 entries? The problem is the following two statements being repeated for each unique file extension, causing a re-parse of $AllFiles which contains over 170000 entries. $Files = $AllFiles | Where { $_.Extension -eq $Ext.Extension } $FilesSum = ($Files | Measure-Object Length -Sum).Sum *** BEGIN *** Write-Host "Reading directory ... $Path" $AllFiles = Get-ChildItem $Path -Include * -Recurse -OutBuffer 2048| Where { $_.PSisContainer -eq $false } Write-Host "Number of Files = $((a)($AllFiles).Count)" $AllSum = ($AllFiles | Measure-Object Length -Sum).Sum If ($AllFiles.Length) { Write-Host "Counting unique file extensions = " -NoNewLine $Extensions = $AllFiles | Select Extension -Unique | Sort Extension Write-Host ($Extensions).Count foreach ($x in $Extensions){ Write-Host $x.Extension } exit ForEach ($Ext in $Extensions) { Write-Host "Counting ... $Ext = " -NoNewline $Files = $AllFiles | Where { $_.Extension -eq $Ext.Extension } $FilesSum = ($Files | Measure-Object Length -Sum).Sum Write-Host $FilesSum $Percent = "{0:N0}" -f (($FilesSum / $AllSum) * 100) $Body += " <tr><td>$($Ext.Extension)</td><td>$((a)($Files).Count)</td><td><div class=""green"" style=""width:$Percent%"">$('{0:N2}MB' -f ($FilesSum / 1mb))</div></td></tr>" } $HTML = $HeaderHTML + $Body + $FooterHTML Write-Host "Writing file $OutputPath\FilesByExtension.html" $HTML | Out-File $OutputPath\FilesByExtension.html Write-Host "Done!" } Else { Write-Host "`nNo files found in $Path" } *** END *** -- .~. 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!

8 21

Jump to page:

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox