RE: Codeplex is shutting down, VFPX.org is spinning up

Hey Rick, Long time, no see. Thanks for chiming in. I wasn't suggesting that Jim needs to enhance or update. I was attempting to fill a vacuum here. Good news about the Thor update process. There were times in the past where it seemed like that required care and feeding by Jim to pick up

RE: Codeplex is shutting down, VFPX.org is spinning up

Richard, Isn’t this the number one thing developers love about open source software, no one individual will be able to kill a product because others can step up and take it over or fork it to their own liking? Thor is solid as a rock, and it was designed for extreme extensibility, which is

RE: Codeplex is shutting down, VFPX.org is spinning up

Fernando, The update process is handled through VFPXRepository.com already so moving to Github has zero impact to the Thor Update process. No worries, be happy. Rick White Light Computing, Inc. www.whitelightcomputing.com -Original Message- From: ProfoxTech

Re: Reading from SQLite

So, what's your theory? You have the data, you'll need to make the hypotheses and test them out. Perhaps they are storing the dates as a offset in seconds since June of 2003, or perhaps there's something else going on. If you know the correct date for a couple of records, you should be able to

Re: Reading from SQLite

Try this page as well: http://www.sqlite.org/lang_datefunc.html Time Strings A time string can be in any of the following formats: 1. *-MM-DD* 2. *-MM-DD HH:MM* 3. *-MM-DD HH:MM:SS* 4. *-MM-DD HH:MM:SS.SSS* 5. *-MM-DD**T**HH:MM* 6.

Re: Reading from SQLite

Ok, here's the information I get with SQLite3, the Dates are stored with 9 characters. database page size:  4096 write format:    2 read format: 2 reserved bytes:  0 file change counter: 347 database page count: 532 freelist page count: 0 schema cookie:   45 schema format:

Re: Reading from SQLite

On Thu, Apr 27, 2017 at 12:17 PM, José Olavo Cerávolo wrote: > Hi Ted, > The dates on the existing table are not .NULL..When I get the date using what > you suggested, datetime(yourfield,'unixepoch','localtime'), I get this date > on an MEMO field 1984-10-05 23:00:00. This

[NF] Python now coming into SQL Server 2017

For the Analytics part of your IT team. http://searchsqlserver.techtarget.com/news/450417318/SQL-Server-2017-makes-Python-a-first-class-citizen-for-analytics -- Stephen Russell Sr. Analyst Ring Container Technology Oakland TN 901.246-0159 cell --- StripMime Report -- processed MIME parts

Re: Reading from SQLite

Hi Ted, The dates on the existing table are not .NULL..When I get the date using what you suggested, datetime(yourfield,'unixepoch','localtime'), I get this date on an MEMO field 1984-10-05 23:00:00. This date is not the actual date on the other application. The date should be in 2017.The

Re: Getting count of rows in a text file -- best approach?

Hi Mike: A very fast method is using the FileSystemObject: loFSO = CREATEOBJECT("Scripting.FileSystemObject") loFile1 = loFSO.OpenTextFile(lcArchivo1, 1) Look at the syntax on Microsoft web site for the read method. It does not have the limitation of VFP's fread/fgets Regards El 21/4/2017

Re: [NF] Fix for dead chromebooks

Also, the Chromebook comes with a Recovery Utility you can burn to a 4Gb USB tab. Also, you can install Chromebook Recovery Utility on any machine with Google Chrome installed and create the USB Recovery using the app. You just need to know the specific model of the machine, like the Acer

Re: Getting count of rows in a text file -- best approach?

On Thu, 27 Apr 2017 19:02:39 +0800, Man-wai Chang wrote: >Sorry, memlines() not mline() The returned count can be wrong due to the 8192 characters max line lenght limit. Only the method that counts the carriage return characters give the correct result. -- Gianni

Re: Getting count of rows in a text file -- best approach?

Sorry, memlines() not mline() On Fri, Apr 21, 2017 at 10:44 PM, wrote: > VF9SP2 > > Currently, I'm simply doing this for now: > > RowCount = OCCURS(CHR(13),FILETOSTR(m.Filename)) > > Is there a better (read: FASTER) way? These are tab delimited text

Re: Getting count of rows in a text file -- best approach?

How about an old functions like MLINE()? On Fri, Apr 21, 2017 at 10:44 PM, wrote: > VF9SP2 > > Currently, I'm simply doing this for now: > > RowCount = OCCURS(CHR(13),FILETOSTR(m.Filename)) -- .~. Might, Courage, Vision. SINCERITY! / v \ 64-bit

Re: Reading from SQLite

On Wed, Apr 26, 2017 at 4:23 PM, José Olavo Cerávolo wrote: > Hi Guys, > I sent a message but it guess it was misplaced.I am trying to read a SQLite > database, but I have problems with the data.I can connect to it, read the > tables, but the values are messed up.I can't

Re: [NF] Fix for dead chromebooks

Lucky escape. -- Alan Bourke alanpbourke (at) fastmail (dot) fm On Thu, 27 Apr 2017, at 08:12 AM, Michael Madigan wrote: > I had a completely dead Chromebook.  Googling dead Chromebooks I came > across a fix.   Hold down the refresh button(4th button from the left on > the top) and then

[NF] Fix for dead chromebooks

I had a completely dead Chromebook.  Googling dead Chromebooks I came across a fix.   Hold down the refresh button(4th button from the left on the top) and then press the power button.   This does a hard reset of the computer without deleting any files.    I think I glitched the computer by