RE: [NF] Small and Light Replacement for Laptop

2014-06-09 Thread Dave Crozier
Macbook Pro or Macbook air (really good deals at the moment). If you do get a Macbook then just make sure you get one with sufficient memory as they ade non upgradeable. If you don't mind an 18 month old one then you can add additional memory. My new one is 16Gb memory and 512Gb SSD drive Now

RE: [NF] Small and Light Replacement for Laptop

2014-06-09 Thread Dave Crozier
...oh and I forgot to add, my old Macbook (2 years) I just sold on Ebay for £800 (Uk Pounds) and that was a loss on 2 years use of 400 pounds. Try getting that trade back on your average laptop. Dave -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Charles

Re: [NF] Small and Light Replacement for Laptop

2014-06-09 Thread Malcolm Greene
Charles, I would like to 2nd Dave's comments. I've been using an identically configured Mac and couldn't imagine a scenario where I would switch back to a traditional Windows laptop. I thought I would be living in a Windows VM but I rarely touch mine and do 99% of my work on the Mac OSX side.

Re: [NF] Small and Light Replacement for Laptop

2014-06-09 Thread Ted Roche
On 06/09/2014 06:17 AM, Malcolm Greene wrote: When I purchased my unit they offered a 45 day return policy. I used this evaluation period to upgrade from Macbook Air to Macbook Pro. The upgrade process was seamless. What was the reason for that upgrade? Considering a new machine myself, and

RE: [NF] Small and Light Replacement for Laptop

2014-06-09 Thread John Weller
Having used an iPhone for 4 years and recently bought an iPad mini (which I love) I have decided that when my laptop needs replacement I will be looking at a Macbook unless Windows 9 is a massive improvement on Win 8. This raises a few questions: Is there an alternative to M$ Office for the Mac?

Re: [NF] Small and Light Replacement for Laptop

2014-06-09 Thread Alan Bourke
On Mon, Jun 9, 2014, at 11:44 AM, John Weller wrote: Is there an alternative to M$ Office for the Mac? If you have relatively simple needs in the word processing / spreadsheet arena, and don't need to work with MS Office files, LibreOffice might do the trick. Is there a similar product to

Re: SQL select Group by datetime field value puzzle

2014-06-09 Thread Laurie Alvey
Why not have another column (integer) called hour say, and store the hour part of the T column? You could then group by the new column. Laurie On 9 June 2014 00:24, Joe Yoder j...@wheypower.com wrote: Scenario: - Cursor with 2 fields TimeStamp T, and Value N(4.0) - 1 record per

Re: SQL select Group by datetime field value puzzle

2014-06-09 Thread Jean MAURICE
Hi Joe, if you have one record per second, why not grouping on 'RECNO()' instead of the datetime field ? The Foxil ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of

Re: SQL select Group by datetime field value puzzle

2014-06-09 Thread Jean MAURICE
here is what I tried : CREATE TABLE essaisql FREE (recnum I, val N(12,6)) FOR i = 1 TO 1 INSERT INTO essaisql VALUES(i, 1000* RAND()) NEXT i = 1 TO 1 BROWSE x = 500 SELECT INT(recnum/x) AS periode, SUM(val) AS somme, AVG(val) AS moyenne ; FROM essaisql GROUP BY periode ORDER BY

RE: [NF] Small and Light Replacement for Laptop

2014-06-09 Thread Dave Crozier
John, You can either use the one from Apple Pages or Microsoft Office itself if you are that attached to it. And don't forget to look at the Refurbished section on the Apple site, you can get some real hardware bargains with full warranty. Dave -Original Message- From: ProFox

Re: SQL select Group by datetime field value puzzle

2014-06-09 Thread Peter Cushing
Joe Yoder wrote: Scenario: - Cursor with 2 fields TimeStamp T, and Value N(4.0) - 1 record per second - Output needed - BegStamp as the beginning of a time period X seconds long and Avg as the average of the Value field for X seconds With X = 3600 the results should give the

Re: SQL select Group by datetime field value puzzle

2014-06-09 Thread Stephen Russell
On 9 June 2014 00:24, Joe Yoder j...@wheypower.com wrote: Scenario: - Cursor with 2 fields TimeStamp T, and Value N(4.0) - 1 record per second - Output needed - BegStamp as the beginning of a time period X seconds long and Avg as the average of the Value field for X

Re: [NF] Small and Light Replacement for Laptop

2014-06-09 Thread Ed Leafe
On Jun 9, 2014, at 5:44 AM, John Weller j...@johnweller.co.uk wrote: Is there an alternative to M$ Office for the Mac? Is there a similar product to M$ Outlook for the Mac - my life revolves around Outlook? There are native versions of Office and Outlook for the Mac. -- Ed Leafe ---

RE: SQL select Group by datetime field value puzzle

2014-06-09 Thread Tracy Pearson
Joe Yoder wrote on 2014-06-08: Scenario: - Cursor with 2 fields TimeStamp T, and Value N(4.0) - 1 record per second - Output needed - BegStamp as the beginning of a time period X seconds long and Avg as the average of the Value field for X seconds With X = 3600 the

Re: SQL puzzle

2014-06-09 Thread mbsoftwaresolutions
You caught me Gene. I had changed it after copying/pasting. Problem solved though. Thanks anyway. On 2014-06-06 12:26, Gene Wirchenko wrote: At 08:44 2014-06-05, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: [snip] INSERT INTO Test VALUES (7, 6, DATE(2013,1,1), DATE(2013,1,11),

Re: [NF] Small and Light Replacement for Laptop

2014-06-09 Thread Malcolm Greene
On 06/09/2014 06:17 AM, Malcolm Greene wrote: When I purchased my unit they offered a 45 day return policy. I used this evaluation period to upgrade from Macbook Air to Macbook Pro. The upgrade process was seamless. What was the reason for that upgrade? Considering a new machine myself, and

RE: [NF] Small and Light Replacement for Laptop

2014-06-09 Thread Dave Crozier
Malcolm, Glad you made the right choice and as you are now saying, it is worth every penny as long as you get the right spec machine. I have added in the 3 year Applecare as it really does mean peace of mind worldwide coupled with the fact (stated previously) that you get a really saleable

Re: [NF] Small and Light Replacement for Laptop

2014-06-09 Thread Christof Wollenhaupt
Is there an alternative to M$ Office for the Mac? Depends on what features you use... 90% of my office stuff is Google Docs. I do have Mac Office on my main machine for the remaining 10%. Is there a similar product to M$ Outlook for the Mac - my life revolves around Outlook? There's

Re: [NF] Small and Light Replacement for Laptop

2014-06-09 Thread mbsoftwaresolutions
On 2014-06-09 10:46, Malcolm Greene wrote: snipped core, a 13 vs. 15 display and, at the time, the lack of a Retina I've always bought laptops with 15 screens or larger. For my future laptop, I think I'd go compact (13 or 14 screen?) and just use a docking station and have large monitors

Re: SQL select Group by datetime field value puzzle

2014-06-09 Thread Joe Yoder
Thanks folks for the ideas. Between them and some time sawing logs I have a found a solution using a UDF that does math on the DateTime value. Here is demo code: m.TSref = DATETIME() CREATE CURSOR joe (Stamp T, Value n(4)) FOR nn = 1 TO 10 INSERT INTO joe VALUES (m.TSref + nn,

RE: [NF] Small and Light Replacement for Laptop

2014-06-09 Thread Dave Crozier
Yes, I tried a 15 display and actually preferred the 13 as the apple displays are just so high quality/resolution and the smaller size/weight is great when flying or travelling. However, I would never dream of getting a 15 standard laptop never mind a 13 one. In fact my Dell laptop is 17 and is

RE: [NF] Small and Light Replacement for Laptop

2014-06-09 Thread Charles Hart Enzer, M.D.
Dear Dave. Thanks for the details. charles On Jun 9, 2014 4:13 AM, Dave Crozier da...@flexipol.co.uk wrote: ...oh and I forgot to add, my old Macbook (2 years) I just sold on Ebay for £800 (Uk Pounds) and that was a loss on 2 years use of 400 pounds. Try getting that trade back on your

Re: [NF] Small and Light Replacement for Laptop

2014-06-09 Thread Charles Hart Enzer, M.D.
Thank you, Malcolm. Charles On Jun 9, 2014 10:46 AM, Malcolm Greene pro...@bdurham.com wrote: On 06/09/2014 06:17 AM, Malcolm Greene wrote: When I purchased my unit they offered a 45 day return policy. I used this evaluation period to upgrade from Macbook Air to Macbook Pro. The upgrade

RE: [NF] Small and Light Replacement for Laptop

2014-06-09 Thread Charles Hart Enzer, M.D.
Dave. I find that on WIN7,vmware ran 2.68 under XP faster then it ran under plain XP charles On Jun 9, 2014 11:01 AM, Dave Crozier da...@flexipol.co.uk wrote: Malcolm, Glad you made the right choice and as you are now saying, it is worth every penny as long as you get the right spec machine.

Single SQL Select or three

2014-06-09 Thread Joe Yoder
Below is demo code that averages values into time periods from multiple tables and combines them into a single table. The first approach uses three SQL Selects and takes about 3/4 second while the second one does the same job with a single select but takes about 32 seconds. Is there a better way

RE: [NF] Small and Light Replacement for Laptop

2014-06-09 Thread Dave Crozier
Charles, I presume you meant 2.6a FPW/DOS in which case I agree. The memory caching on VMWare is excellent. I run full SQL Server 2012 in its own VM giving lightning performance when accessed from another VM running Win 7 64 bit and VFP apps. Now I've made the SQL server SSD based it is truly

Re: Single SQL Select or three

2014-06-09 Thread Peter Cushing
Joe Yoder wrote: Below is demo code that averages values into time periods from multiple tables and combines them into a single table. The first approach uses three SQL Selects and takes about 3/4 second while the second one does the same job with a single select but takes about 32 seconds. Is

RE: [NF] Small and Light Replacement for Laptop

2014-06-09 Thread Dan Covill
Dave, I didn't know about the Henge dock until you mentioned it. Really impressive! If I'd known about it I might have gotten a MacBook Pro instead of the Mac Mini. For folks that travel, this seems like an elegant and effective solution. Dan Covill From: da...@flexipol.co.uk To:

RE: Single SQL Select or three

2014-06-09 Thread Tracy Pearson
Joe Yoder wrote on 2014-06-09: Below is demo code that averages values into time periods from multiple tables and combines them into a single table. The first approach uses three SQL Selects and takes about 3/4 second while the second one does the same job with a single select but takes

RE: [NF] Small and Light Replacement for Laptop

2014-06-09 Thread John Weller
Thanks Alan and Dave - I just have to wait for my laptop to die, oh, and raise a mortgage :-) John Weller 01380 723235 07976 393631 John, You can either use the one from Apple Pages or Microsoft Office itself if you are that attached to it. And don't forget to look at the Refurbished

RE: [NF] Small and Light Replacement for Laptop

2014-06-09 Thread Charles Hart Enzer, M.D.
Dave: Typo with Voice to text Yes, 2.6A Charles On Jun 9, 2014 12:08 PM, Dave Crozier da...@flexipol.co.uk wrote: Charles, I presume you meant 2.6a FPW/DOS in which case I agree. The memory caching on VMWare is excellent. I run full SQL Server 2012 in its own VM giving lightning

Re: [NF] Small and Light Replacement for Laptop

2014-06-09 Thread Ted Roche
On 06/09/2014 10:46 AM, Malcolm Greene wrote: I ended up choosing a 15 Macbook Pro with 16 Gb and 512 Gb SSD. I spent more money than I expected (about $2500), but when I priced out similar Windows devices, I didn't think the premium was too big and since I'm on my workstation up to 16

Re: [NF] Small and Light Replacement for Laptop

2014-06-09 Thread Paul McNett
On 6/9/14, 4:12 PM, Ted Roche wrote: On 06/09/2014 10:46 AM, Malcolm Greene wrote: I ended up choosing a 15 Macbook Pro with 16 Gb and 512 Gb SSD. I spent more money than I expected (about $2500), but when I priced out similar Windows devices, I didn't think the premium was too big and since