Re: X# Bandol GA 2.0 released

2019-08-20 Thread Alan Bourke
Thanks Johan Looking forward to having a look at the public release. -- Alan Bourke alanpbourke (at) fastmail (dot) fm ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version o

SWFOX Early bird extension and X# Post Conf Session

2019-08-20 Thread Johan Nel
*Hi again VFPers,* *Not sure who receive the geekgatherings emails, but here goes, sorry if it is a nuisance, but thought since X# is really pushing to have a very workable VFP syntax support ready for SWFOX, it need to be brought to the attention of as much VFPers that still ponders about goi

So how many classes in a VCX is *too* many ...

2019-08-20 Thread Alan Bourke
https://ibb.co/QPfg68f -- Alan Bourke alanpbourke (at) fastmail (dot) fm --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ Post Messages to: ProFox@leafe.com Subscription M

SQL server connection

2019-08-20 Thread Peter Cushing
Hi, After running my app (VFP 9) on our local network (with a DBC) for many years, we are upgrading it (in stages) to a visual studio app with SQL server back end. I have read many people here talking about using SQL as a back end.  At the beginning I will just be accessing the SQL data for report

Re: So how many classes in a VCX is *too* many ...

2019-08-20 Thread Jean Laeremans
LOL On Tue, Aug 20, 2019 at 11:35 AM Alan Bourke wrote: > https://ibb.co/QPfg68f > > > -- > Alan Bourke > alanpbourke (at) fastmail (dot) fm > > > > --- StripMime Report -- processed MIME parts --- > multipart/alternative > text/plain (text body -- kept) > text/html > --- > [excessive quot

Re: SQL server connection

2019-08-20 Thread Frank Cazabon
I use Visual MaxFrame Professional so the details are hidden from me and I don't really care what technology is used behind the scenes. < smile > I actually think that Drew coded it so that it works through remote views in the background. If I were to start doing my own code/framework now in

Re: SQL server connection

2019-08-20 Thread Stephen Russell
Considering they are flipping over SQL Server I would learn to USE SQL SERVER correctly on the front end from VFP. You create the sprocs that do all of your CRUD operations. Populate them from the fox world and as VFP is replaced, the newer interfaces will use the same sprocs you laid down today

RE: Happy Anniversary!

2019-08-20 Thread Tracy Pearson
Happy Anniversary! May there be many more happy community moment! I just got back to the office after a long weekend. So much to catch up on. Tracy -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Malcolm Greene Sent: Monday, August 19, 2019 3:39 P

RE: So how many classes in a VCX is *too* many ...

2019-08-20 Thread Paul H. Tarver
Holy cow! That makes mine look positively paltry by comparison! I gotta get to work! LOL! Paul H. Tarver -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Alan Bourke Sent: Tuesday, August 20, 2019 4:35 AM To: profoxt...@leafe.com Subject: So how man

RE: SQL server connection

2019-08-20 Thread Paul H. Tarver
Peter, Personally, I like SPT because I can build valid and safe pass-through commands in my code based on user selections, generate the string, hand it off to the server with an ASYNCH connection and easily provide users with progress feedback while data is returned. For some reason, I've n

RE: So how many classes in a VCX is *too* many ...

2019-08-20 Thread Paul Newton
Hi Alan I suspect that was deliberately contrived - what do you think? Paul Newton -Original Message- From: ProfoxTech On Behalf Of Alan Bourke Sent: 20 August 2019 10:35 To: profoxt...@leafe.com Subject: So how many classes in a VCX is *too* many ... Sent by an external sender ---

Re: SQL server connection

2019-08-20 Thread Thierry Nivelet
Cursoradapter eases the transition from DBC to SQL: you can tailor the SQL command according to the backend, recycle your code, test against either backend seamlessly. Thierry Nivelet http://foxincloud.com/ Give your VFP app a second life in your cloud > Le 20 août 2019 à 16:11, Paul H. Tarver

Re: SQL server connection

2019-08-20 Thread MB Software Solutions, LLC
On 8/20/2019 9:42 AM, Stephen Russell wrote: Considering they are flipping over SQL Server I would learn to USE SQL SERVER correctly on the front end from VFP. You create the sprocs that do all of your CRUD operations. Populate them from the fox world and as VFP is replaced, the newer interface

Re: SQL server connection

2019-08-20 Thread MB Software Solutions, LLC
I'm with you mostly it would seem, Paul.  I wrote my own SPT framework years ago after watching Bob Lee demonstrate his VFP app in Wisconsin accessing a MySQL database over the internet in New York back at WhilFest in 2002 or 2003.  CursorAdapters sounded great and I'm told they work great toda

Re: SQL server connection

2019-08-20 Thread Stephen Russell
The initial request said that there was a plan already defined. > After running my app (VFP 9) on our local network (with a DBC) for many > years, we are upgrading it (in stages) to a visual studio app with SQL > server back end. I would only work in promoting future ways of doing things in this c

Re: SQL server connection

2019-08-20 Thread MB Software Solutions, LLC
On 8/20/2019 11:15 AM, Stephen Russell wrote: The initial request said that there was a plan already defined. After running my app (VFP 9) on our local network (with a DBC) for many years, we are upgrading it (in stages) to a visual studio app with SQL server back end. I would only work in prom

Re: So how many classes in a VCX is *too* many ...

2019-08-20 Thread Alan Bourke
On Tue, 20 Aug 2019, at 3:24 PM, Paul Newton wrote: > I suspect that was deliberately contrived - what do you think? I suspect the VCX may have been built programmatically Paul :) -- Alan Bourke alanpbourke (at) fastmail (dot) fm ___ Post Mess

RE: So how many classes in a VCX is *too* many ...

2019-08-20 Thread Richard Kaye
I've been trying to figure out what that is. That doesn't look like the class browser UI. -- rk -Original Message- From: ProfoxTech On Behalf Of Alan Bourke Sent: Tuesday, August 20, 2019 11:34 AM To: profoxt...@leafe.com Subject: Re: So how many classes in a VCX is *too* many ... On

Re: SQL server connection

2019-08-20 Thread Peter Cushing
Hi, Thanks to everyone that replied.  I don't have to worry about getting fired, so all good there. SPT seems the easiest to begin with, but not got it working yet. I have created an ODBC link called X2live.  I set it up as a system DSN as I tried a user DSN first and that didn't work. Just wonder

RE: So how many classes in a VCX is *too* many ...

2019-08-20 Thread Tracy Pearson
It is the toolbar for adding controls to a form or container class. Tracy -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard Kaye Sent: Tuesday, August 20, 2019 11:51 AM To: profoxt...@leafe.com Subject: RE: So how many classes in a VCX is *too*

Re: SQL server connection

2019-08-20 Thread Frank Cazabon
Yes, agreed using stored procedures is a good way, however I believe you still need SPT or CursorAdapters to access those stored procedures, so they are not necessarily mutually exclusive. Frank. Frank Cazabon On 20/08/2019 09:42 AM, Stephen Russell wrote: Considering they are flipping over

Re: SQL server connection

2019-08-20 Thread MB Software Solutions, LLC
I use SQLSTRINGCONNECT usually because those apps build the connection string manually, but I do have another app that uses SQLCONNECT using a defined DSN. On 8/20/2019 12:26 PM, Peter Cushing wrote: Hi, Thanks to everyone that replied.  I don't have to worry about getting fired, so all good

Re: Happy Anniversary!

2019-08-20 Thread Kurt at VR-FX
Nice one Malcolm! I whole-heartedly agree with you. I have enjoyed the company of the folks here - and in the times where I am working alone - or surrounded by those that speak another language (at work - and they don't bother to chat with me) - getting to chat on here can be quite comforting!

[NF] Microsoft Teams

2019-08-20 Thread MB Software Solutions, LLC
Well that's interesting.  On reboot after the latest update, I now have an icon on my desktop that says Microsoft Teams.  That seems sneaky on M$'s part.  I don't recall ever expressly installing any software from them called that. --- This email has been checked for viruses by Avast antiviru

RE: [NF] Microsoft Teams

2019-08-20 Thread datades
Me either. But it also STARTS when I reboot. I don’t even know what it is. I don’t do software development anymore. I write/edit/proofread/publish books now. Less stressing and less profitable☹ Still love to read this list. -Original Message- From: ProFox On Behalf Of MB Software Solu

Easiest/best way to create an email using local MS Outlook with file attachments?

2019-08-20 Thread MB Software Solutions, LLC
VFP9SP2 app Customer uses Outlook and wants the app to generate an email to a given email address from the app AND attach certain documents to it.  Customer will preview it and then manually hit "Send" on their own. What's the BEST (and hopefully easiest) way to implement this? Invoke Outloo

Re: Easiest/best way to create an email using local MS Outlook with file attachments?

2019-08-20 Thread Kurt @ Gmail
Wow - Deja vu! I joined this forum Circa 2008 - and, previously I was at a job and had to do Exactly this! It was maybe circa 2005-06. YEs, I did indeed do this via Office Automation. There was a great book out there - all about doing OA - and that's how I ended up doing the project. I too nee

RE: [NF] Microsoft Teams

2019-08-20 Thread Chris Davis
If you have Office365 and had Skype for Business installed then Microsoft Teams is it's replacement. -Original Message- From: ProfoxTech On Behalf Of data...@adam.com.au Sent: Wednesday, 21 August 2019 04:35 To: profoxt...@leafe.com Subject: RE: [NF] Microsoft Teams Me either. But it al

Re: Easiest/best way to create an email using local MS Outlook with file attachments?

2019-08-20 Thread John Weller
I use CDO to do just that. I’m not in the office until later today but when I get in I’ll send you some sample code if you wish? John John Weller 01380 723235 079763 93631 Sent from my iPad > On 21 Aug 2019, at 05:22, MB Software Solutions, LLC > wrote: > > VFP9SP2 app > > Customer uses Out