Re: VFP9 and Windows 10 PDF printer

You can make a donation to Cesar Chalom if you like it that much. Thierry Nivelet http://foxincloud.com/ Give your VFP app a second life in the cloud > Le 26 avr. 2017 à 23:53, Paul H. Tarver a écrit : > > I've been using FoxyPreviewer for a couple of years now and I love it.

Re: VFP9 and Windows 10 PDF printer

I use XFRX and it works well. Probably the biggest difference is that XFRX is not free. Mike Copeland Paul H. Tarver wrote: I've been using FoxyPreviewer for a couple of years now and I love it. Haven't tried XFRX yet. Are there any advantages to one or the other? Paul H. Tarver Tarver

RE: VFP9 and Windows 10 PDF printer

I've been using FoxyPreviewer for a couple of years now and I love it. Haven't tried XFRX yet. Are there any advantages to one or the other? Paul H. Tarver Tarver Program Consultants, Inc. -Original Message- From: Rick Schummer [mailto:pro...@whitelightcomputing.com] Sent: Tuesday,

Re: Reading from SQLite

.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; On Wed, Apr 26, 2017 at 4:23 PM, José Olavo Cerávolo wrote: > Hi

Re: Reading from SQLite

You may have the difficulty of a VFP date is not a SQL date. getdate() is the system datetime. -- convert a date to String SELECT convert(varchar(25), getdate(), 120) -- date part only SELECT CONVERT(date, getdate()) On Wed, Apr 26, 2017 at 3:33 PM, Richard Kaye

RE: Reading from SQLite

Whil Hentzen wrote an eBook on working with SQLLite. http://www.hentzenwerke.com/catalog/sqlite2gb.htm -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of José Olavo Cerávolo Sent: Wednesday, April 26, 2017 4:24 PM To: profoxt...@leafe.com

Reading from SQLite

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

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

|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-requ...@leafe.com wrote: RE: Getting count of rows in a text file -- best approach? --- StripMime Report

RE: Excel automation to get the SUM("R:R")

Looks to me like your current solution is storing a formula in a remote cell which you said you wanted to avoid. -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of mbsoftwaresoluti...@mbsoftwaresolutions.com Sent: Wednesday, April 26, 2017

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

Sure looks like you can load larger than 16MB. Though the help file does say a 16MB limit on memory variables. Fred On Wed, Apr 26, 2017 at 11:44 AM, < mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote: > On 2017-04-26 12:31, Brant E. Layton wrote: > >> Just a reminder - STRTOFILE and

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

I haven't seen any commentary from Jim Nelson, Thor Master, as to his plans to adapt Thor to the Git world. He has indicated elsewhere that he is heading towards retirement. Whenever anyone asks a question about changes to Thor, his more recent replies have indicated that he feels it's a pretty

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

Yes, I mean the auto-update feature of the projects. 2017-04-26 20:39 GMT+02:00 : > You mean so that it's still self-updating? > > > On 2017-04-26 12:01, Fernando D. Bozzo wrote: > >> I suppose that it will need some rework to work with Github >>

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

On 2017-04-26 12:31, Brant E. Layton wrote: Just a reminder - STRTOFILE and FILETOSTR are limited by the size of a memory variable - 16,384K bytes (16,777.184 bytes). Had to fix some software that was truncating PDF files at 16 MB... || Looked up the Visual Foxpro System Capabilities:

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

You mean so that it's still self-updating? On 2017-04-26 12:01, Fernando D. Bozzo wrote: I suppose that it will need some rework to work with Github El 26/4/2017 5:59 p. m., escribió: On 2017-03-31 20:51, Fernando D. Bozzo wrote: No shit...

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

Just a reminder - STRTOFILE and FILETOSTR are limited by the size of a memory variable - 16,384K bytes (16,777.184 bytes). Had to fix some software that was truncating PDF files at 16 MB... || |Brant Layton| |480.964.1316| On 4/25/2017 6:00 PM, profoxtech-requ...@leafe.com wrote: RE: Getting

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

I suppose that it will need some rework to work with Github El 26/4/2017 5:59 p. m., escribió: On 2017-03-31 20:51, Fernando D. Bozzo wrote: > No shit... moving all the projects will be a hard. Binaries, version > history, documentation, bye bye

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

On 2017-03-31 20:51, Fernando D. Bozzo wrote: No shit... moving all the projects will be a hard. Binaries, version history, documentation, bye bye Thor :_( Why would you say "bye bye Thor" ?? ___ Post Messages to: ProFox@leafe.com Subscription

RE: Excel automation to get the SUM("R:R")

Ignore that last lineI fixed it with COUNTA. Just forgot to delete that part before pressing "Send" On 2017-04-26 11:55, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: My DetailClaims logic is wrong though; it's counting ALL rows in the column, and I just wanted to the populated

RE: Excel automation to get the SUM("R:R")

Thanks, Richard. I may try that. Here's what I had for now: WITH oExcel.ActiveSheet as EXCEL.Worksheet .Range("AA96").Formula = "=COUNTA(R:R)" DetailClaims = .Range("AA96").Value - 1

RE: Excel automation to get the SUM("R:R")

Here's what I dummied up at the command line. You just need to get the proper cells in the range object. lox=CREATEOBJECT([excel.application]) lox.Visible=.t. lox.Workbooks.Add() los=lox.ActiveSheet lor=los.Range([a1],[a10]) ?lox.WorksheetFunction.Sum(lor) -- rk -Original Message-

Excel automation to get the SUM("R:R")

Excel 2013, VFP9SP2 Range Object model: https://msdn.microsoft.com/en-us/library/office/ff838238.aspx I've got my handy "Microsoft Office Automation With Visual Foxpro" book out from HWP, trying to see where I can get the value of a range. In this case, when I just select the entire

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

On 2017-04-25 17:48, Rick Schummer wrote: And it will be forwarded to the new home of VFPX just as soon as we get it firmly established. The migration is underway already. Rick White Light Computing, Inc. www.whitelightcomputing.com Thanks