Re: SWFox 2019 recap

2019-10-30 Thread Johan Nel
Yes, and from report back from Tore Bleken, who attended the post-conference X# training, 33 attendees (36 started, but had to leave early), which is 50% of registrations (67).  Makes for quite a buzz in the way forward for VFP developers.  The DevTeam also listens and I am sure what was discus

Re: lists

2019-10-30 Thread Ted Roche
https://mail.leafe.com/mailman/listinfo/profoxOT-free On Wed, Oct 30, 2019 at 3:00 PM Matt Slay wrote: > > [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/p

RE: SWFox 2019 recap

2019-10-30 Thread Tracy Pearson
I liked that Doug brought up the Windows 10 Pro/Enterprise has a built in Windows Sandbox. If you don't have a VM, this is an instant VM. It allows you to do install testing quickly on a clean machine. I checked. Windows 10 Home does not have the ability to add the feature. Here's a link explain

RE: SWFox 2019 recap

2019-10-30 Thread John Weller
The comments on SWFox make me wish I was 20 years younger and still working professionally with the Fox - oh, and could afford to get to visit the meeting 😊 John John Weller 01380 723235 07976 393631 ___ Post Messages to: ProFox@leafe.com Subscripti

RE: SWFox 2019 recap

2019-10-30 Thread Richard Kaye
Thanks, Eric. It was great to meet you in person. I think we have to get some ProFox t-shirts for next year so we can fly the list's true colors... One other thing I wanted to mention. Rick Schummer has built a replacement for the menu designer and will be releasing that as open source as well.

lists

2019-10-30 Thread Matt Slay
___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This messag

Re: SWFox 2019 recap

2019-10-30 Thread Matt Slay
Another interesting thing to follow at SWFox 2019 was the X#.Net open source language, and how they are making good progress with supporting the FoxPro language in X#.Net Eric Selje presented a session on it, and two people from the X# Developer Team flew over (from the Netherlands, and France

Re: SWFox 2019 recap

2019-10-30 Thread Eric Selje
Great recap of VFP Advanced, Richard. And yes you did great Tracy! Great to see you there, and would love to see more next year. Eric On Wed, Oct 30, 2019 at 10:43 AM Richard Kaye wrote: > And further to that, a big, big shout-out to Doug, Rick & Tamar, and all > the speakers for making this

Re: Exporting Tables

2019-10-30 Thread Kurt at VR-FX
True. Yeah - LLIO can be more convoluted to code - I'm just more used to doing it that way that the TEXT command, thus why I suggested it. Will surely have to seriously consider the TEXT command more so in the future. -K- On 10/30/2019 9:46 AM, Richard Kaye wrote: You don't need LLIO. TEXT...

RE: SWFox 2019 recap

2019-10-30 Thread Richard Kaye
And further to that, a big, big shout-out to Doug, Rick & Tamar, and all the speakers for making this happen. The amount of work that goes into pulling off something like this is a labor of love, and Geek Gatherings deserves all the love they get in return. Here are a few of my highlights: In

RE: Exporting Tables

2019-10-30 Thread Richard Kaye
You don't need LLIO. TEXT...ENDTEXT will do the trick just fine as well as allow you to pre-process any of the data like swapping out CRLF with spaces. -- rk -Original Message- From: ProfoxTech On Behalf Of Kurt at VR-FX Sent: Wednesday, October 30, 2019 12:43 PM To: profoxt...@leafe.c

RE: SWFox 2019 recap

2019-10-30 Thread Richard Kaye
I was not a presenter, like Tracy , but I also had a great time at SWFox. It's a joy to spend time with one's peers learning new (and sometimes old) things, as well as meeting in person with both old and new friends. I would also encourage anyone on this list who still works with the Fox to cons

Re: Exporting Tables

2019-10-30 Thread Kurt at VR-FX
Hey RK - I was thinking the same thing. Essentially - Gene - you could do the direct export of data - but, to a CSV file. Then, use lo-level file handling to add the memo field onto each line, and, as RK said - make sure to add in the CRLF. -K- On 10/30/2019 7:42 AM, Richard Kaye wrote: I be

SWFox 2019 recap

2019-10-30 Thread Tracy Pearson
I am back to calm after the first day back to work. I had a great time at the conference and hope to stay connected with those I met. I answered an email this morning and thought about the conversation I had with Richard Kaye. Good conversations, good information, and a fun time. I hear I did w

Re: Exporting Tables

2019-10-30 Thread Ted Roche
On Wed, Oct 30, 2019 at 9:58 AM Gene Wirchenko wrote: >1) I am wondering if there is a difference between > where the type is XLS or XL5. > Nope, according to: https://www.tedroche.com/hackfox7/s4g059.html "Both COPY TO and EXPORT copy selected data to another file. We can't see much reason

Re: Exporting Tables

2019-10-30 Thread António Tavares Lopes
Gene If CSV is acceptable to you, you may try the CSVProcessor class at VFPX. m.CSV = CREATEOBJECT("CSVProcessor") m.CSV.Export("output.csv") Whatever memo fields are on your table, they will be exported, as well. You may also consider using one of the XLSX classes available at VFPX. On Wed,

RE: Exporting Tables

2019-10-30 Thread Richard Kaye
I believe this goes back to dBase compatibility and these commands do the same thing. It's not too hard to roll your own CSV/Tab delimited file in which case you can keep your memo fields mostly intact. You will need to convert embedded CRLF in order to keep one record per line. -- rk -O

Re: Exporting Tables

2019-10-30 Thread Stephen Russell
Why not Import from SQL Server or Access? You can then make a backup file from SQL or just copy the access one to give to others who cannot use Fox tables. On Wed, Oct 30, 2019 at 8:58 AM Gene Wirchenko wrote: > Hello: > > I am having to do a bunch of data export so have had a closer > lo

RE: Exporting Tables

2019-10-30 Thread Tracy Pearson
Gene, I have not seen a difference in the output of the two commands. You might want to consider looking at Craig Boyd's post about exporting and importing from Excel. It doesn't mention Memo fields that I could see. https://www.sweetpotatosoftware.com/blog/index.php/2008/09/30/using-excel-20 07-

Exporting Tables

2019-10-30 Thread Gene Wirchenko
Hello: I am having to do a bunch of data export so have had a closer look at the commands. 1) I am wondering if there is a difference between COPY TO ... TYPE ... and EXPORT TO ... TYPE ... where the type is XLS or XL5. 2) I know that memo columns are not expo