ProFox

profox@leafe.com

2704 discussions

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

SQL sum
by Tom Dawson 21 Apr '17

21 Apr '17

Hi All I have a stock table which records the locations and quantities of various items. The layout of the table is like so: |stock id| |location| |quantity| I want to be able to add a total field into the table which is a total of each unique stock id. To do this I tried to use a sum(quantity) followed by a group by. The problem is grouping by id ignores the distinct location info. For example stock id location quantity 1 A 10 1 B 20 2 C 50 2 D 50 Becomes: stock id location quantity Total 1 A 10 30 2 C 20 100 Although the totals are right the group by has cause me to lose my distinct location info, what I really want is stock id location quantity Total 1 A 10 30 1 B 20 30 2 C 50 100 2 D 50 100 I'm sure it's relatively but I'm obvious missing something. Thanks in advance Tom --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

7 8

Jump to page:

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox