ProFox April 2017

profox@leafe.com

44 participants
50 discussions

Re: Reading from SQLite
by José Olavo Cerávolo 27 Apr '17

27 Apr '17

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: 4 default cache size: 0 autovacuum top root: 39 incremental vacuum: 1 text encoding: 1 (utf8) user version: 0 application id: 0 software version: 3014000 number of tables: 23 number of indexes: 14 number of triggers: 0 number of views: 0 schema size: 8265 Subject: Re: Reading from SQLite Message-ID: <CACW6n4sokfifY57-mWO4ZGW1wv=o_J0MnkK5dXMmJwEkRyhhpg(a)mail.gmail.com> Content-Type: text/plain; charset="utf-8" On Thu, Apr 27, 2017 at 12:17 PM, Jos? Olavo Cer?volo <joceravolo(a)yahoo.com> 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 date is not the actual date on the other application. The date should be in 2017.The actual value stored on the actual SQLite table is 459316800. Well, that's weird. THE SQLite function datetime() is expecting a number of 10 digits, so that's not the encoding scheme. Can you use a tool like SQLite3 to look at the actual data in the SQLite table and confirm this isn't a problem with ODBC or Fox's intepretation of the data? José Olavo Cerávolohttp://www.ceravoloconsulting.com/ --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

2 1

Re: Reading from SQLite
by José Olavo Cerávolo 27 Apr '17

27 Apr '17

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 actual value stored on the actual SQLite table is 459316800. There's a disconnect from what the other application is saving to what I am able to read. I am not able to talk to the other application programmer. I've read a lot of documentation about SQLite, but nothing that could actually help me. Thanks, Jose. Message: 7 Date: Wed, 26 Apr 2017 16:58:56 -0400 From: Ted Roche <tedroche(a)gmail.com> To: profoxtech(a)leafe.com Subject: Re: Reading from SQLite Message-ID: <CACW6n4tEd4w_W0iK59ND+c30YH+TnqHN6GfDQ+ZgesXuymtCCw(a)mail.gmail.com> Content-Type: text/plain; charset="utf-8" .NULL. is a perfectly valid date. If you're getting numbers, you're likely getting dates stored as days since some arbitrary date. Try: select datetime(yourfield,'unixepoch','localtime') from yourtable; José Olavo Cerávolo http://www.ceravoloconsulting.com/ --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

3 2

[NF] Python now coming into SQL Server 2017
by Stephen Russell 27 Apr '17

27 Apr '17

For the Analytics part of your IT team. http://searchsqlserver.techtarget.com/news/450417318/SQL-Server-2017-makes-… -- 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

[NF] Fix for dead chromebooks
by Michael Madigan 27 Apr '17

27 Apr '17

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 plugging in a camera into the USB port. --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

3 2

Reading from SQLite
by José Olavo Cerávolo 27 Apr '17

27 Apr '17

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 get the Dates, it comes out as .NULL or with weird numbers.I've looked at the documentation, but nothing is working.I am using the SQLite ODBC for SQLite version 3. Thanks in advance, Jose. José Olavo Cerávolohttp://www.ceravoloconsulting.com/ --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

4 4

RE: Getting count of rows in a text file -- best approach?
by Brant E. Layton 26 Apr '17

26 Apr '17

|My experience was moving PDF files in and out of SQLServer tables - found an abrupt truncation at the 16,777,184 mark... Brant Layton| |480.964.1316| On 4/26/2017 12:57 PM, profoxtech-request(a)leafe.com wrote: > RE: Getting count of rows in a text file -- best approach? --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

1 0

Codeplex is shutting down, VFPX.org is spinning up
by Ted Roche 26 Apr '17

26 Apr '17

You can always count on Microsoft... ... to let you down. Codeplex is shutting down: https://blogs.msdn.microsoft.com/bharry/2017/03/31/shutting-down-codeplex/ The wise Rick Schummer and company registered vfpx.org, so stay tuned for migration news. -- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com

6 10

[NF] FREE javascript training.
by Stephen Russell 25 Apr '17

25 Apr '17

https://medium.freecodecamp.com/my-giant-javascript-basics-course-is-now-li… -- 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

Gotcha: Odd Error
by Gene Wirchenko 21 Apr '17

21 Apr '17

Hello: A line of code was throwing an error at run-time: if !doseek(str(&alraw..trnnbr),6)) Note the extra right parenthesis before the comma. Because of the &, the error was not reported during compilation. After all, alraw could contain a left parenthesis. Sincerely, Gene Wirchenko

2 1

Re: Referring to a Column
by Gene Wirchenko 21 Apr '17

21 Apr '17

At 17:35 2017-04-20, Ted Roche <tedroche(a)gmail.com> wrote: >On Thu, Apr 20, 2017 at 8:20 PM, Gene Wirchenko <genew(a)telus.net> wrote: > > It sure would be nice if > > (aliasasstr+".colname") > > >Well, then: > >&aliasstr..colname I oversimplified, and what I wrote as aliasasstr was actually an expression. I decided to assign it all to a variable and will be using &. Sincerely, Gene Wirchenko

1 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox April 2017