Re: X# Bandol GA 2.0 released
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 of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/9a7c0105-fac9-4697-a9d4-52ec503ce...@www.fastmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
SWFOX Early bird extension and X# Post Conf Session
*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 going...* *XBase greetings,* *Johan * *Early-Bird Registration Extension* We are extending the Early-Bird Registration for Southwest Fox 2019 until August 30th. The early bird gets the worm, or in this case, saves $50! *X# Post Conference Session Details* When: Sunday, October 27, 2019, 2:00 following the Closing session Where: Conference Center, rooms E and F Length: 1.5 to 2.0 hours If you've already registered for the conference and want to attend this session, email *regis...@geekgatherings.com* and we'll add you to the post-conference list. XSharp (X#) is a .NET development language based on the xBase syntax. It is open source and is based on Roslyn, aka the C# compiler. Next to the compiler, X# also provides Visual Studio integration to support most .NET-based applications: Console, Windows Forms, WPF etc. It supports several dialects of the xBase family: Core, Visual Objects, Harbour, xBase++, VFP, etc. It comes with a macro compiler to support runtime evaluation, a Runtime Library and RDDs, and provides runtime components to support dialect-specific classes and functions. X# is a "community driven" project. We build what you, our customers, would like to see. The source for X# is available on GitHub, so you can see what we do and also contribute to the development of the project if you like. The development team originates in the Visual Objects community, so that is why the Visual Objects support is the most developed at this moment. But we are working on expanding the product to the VFP community actively. In this 90 minute post-conference session, we will take you through the migration process of a (simple) Visual FoxPro (VFP) application. We will start with a VFP project and extract its forms, custom controls, menus, reports etc. These will be converted to a Visual Studio Solution, project and source files. We will show you how the code with some modifications will compile and run in Visual Studio. After that we will extend the application with some .NET components. Please remember that the VFP support for X# is "work in progress". Some things are still a little rough and need more work. We will use this session to also discuss with you what YOUR wishes are for the direction of X# for VFP. One example, we have two options for the conversions of VFP forms: 1. We can convert them to standard .NET windows forms or WPF forms. The advantage of this is that everything will work just like in C# and VB and that we can use the built-in editors for forms in Visual Studio. The disadvantage is that some pieces of your existing code will need modifications, especially event handlers. 2. We can create a UI library based on standard .NET forms that will emulate the VFP forms completely. As a result event handlers will "just work". However these forms will be somewhat different from what C# and VB developers are using, and we most likely have to create our own Form designers, that of course would look a lot like the VFP form editor. During the session we will show you approach #1. Approach #2 will need more work on our side (UI library and tools) but some of that work has already done by others, such as Christof Wollenhaupt for Guineu, so we might be able to use some of that. Other (similar) discussions are about SQL access, reporting, which tools we should port, etc. We know that the VFP community has always been very strong. We hope that we can contribute to this community and that together we can help VFP developers to move their applications forward into the world of .NET. Come and join us in this session and help to set the course for the X# VFP support. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/73e4f8b4-a9d2-06b4-e86c-6fd930419...@xsinet.co.za ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
So how many classes in a VCX is *too* many ...
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 Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/609bfed9-12cb-495a-bf7c-82d5c989d...@www.fastmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
SQL server connection
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 reporting purposes but may need to write to it at some point. Looking through the archives some people mentioned SPT and others cursor adapters. Just wondering what people recommend to connect, so I can avoid the usual gotchas. Thanks, -- Peter Cushing IT Department WHISPERING SMITH This communication is intended for the person or organisation to whom it is addressed. The contents are confidential and may be protected in law. Unauthorised use, copying or disclosure of any of it may be unlawful. If you have received this message in error, please notify us immediately by telephone or email. www.whisperingsmith.com Whispering Smith Ltd Head Office:61 Great Ducie Street, Manchester M3 1RR. Tel:0161 831 3700 Fax:0161 831 3715 London Office: 101 St. Martin's Lane,London, WC2N 4AZ Tel:0207 299 7960 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/74efd93c-5ffc-1ebb-0945-98a963448...@whisperingsmith.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: So how many classes in a VCX is *too* many ...
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 quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/CAPqLOBwhvA86pYm=zw3gxb+xgwprps-uhpjoaqxsac2nqeq...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: SQL server connection
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 VFP I would probably use CursorAdapters but I have never actually used them for more than playing with to learn about them. I believe they give you enough flexibility while hiding some of the technical details. If you want absolute control, then go with SPT. Frank. Frank Cazabon On 20/08/2019 05:39 AM, Peter Cushing wrote: 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 reporting purposes but may need to write to it at some point. Looking through the archives some people mentioned SPT and others cursor adapters. Just wondering what people recommend to connect, so I can avoid the usual gotchas. Thanks, ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/ad40605d-54b7-7f3a-6cdf-53dfc484f...@gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: SQL server connection
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 whenever they are activated. On Tue, Aug 20, 2019 at 7:24 AM Frank Cazabon wrote: > 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 VFP I would > probably use CursorAdapters but I have never actually used them for more > than playing with to learn about them. I believe they give you enough > flexibility while hiding some of the technical details. If you want > absolute control, then go with SPT. > > Frank. > > Frank Cazabon > > On 20/08/2019 05:39 AM, Peter Cushing wrote: > > 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 reporting > > purposes but may need to write to it at some point. Looking through the > > archives some people mentioned SPT and others cursor adapters. Just > > wondering what people recommend to connect, so I can avoid the usual > > gotchas. > > > > Thanks, > [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/CAJidMY+giDumzW+5miE9WbRJpybmL3non9+167Zykn=och7...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Happy Anniversary!
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 PM To: profoxt...@leafe.com Subject: Re: Happy Anniversary! Paul, > "And pray We don't get fooled again Don't get fooled again No, no! > Yeah! Meet the new boss Same as the old boss" Well played! :) Malcolm [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/000901d5575e$378d5810$a6a80830$@powerchurch.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: So how many classes in a VCX is *too* many ...
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 many classes in a VCX is *too* many ... 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 quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/005b01d5575e$66f2fb00$34d8f100$@tpcqpc.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: SQL server connection
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 never been able to wrap my head around cursor adapters completely. Maybe it’s a control issue! :) I think SPT just made more sense to me upfront. Thankfully, Foxpro gives you plenty of different ways to accomplish the same things and you can pick the one that works the way you do! I use it to query data for reporting purposes and it gives me a lot of control over how I construct the query string since I can use all of the string functions within Foxpro to build exactly the query I want based upon users' selections. Another advantage is I able to dump the query string to my audit files just before the SQLEXEC() command fires, so if something goes wrong, I can just copy the query to my SQL management tool and see if I can manually figure out what is going on. So far, I've used SPT successfully to backend Foxpro with SQL, MySQL, Oracle, Access, PostgreSQL, SQLite, etc. I just tweak queries to customize for the database and the rest of my code remains the same. It works for me, but I'm sure, someone else here will provide you with the benefits of cursor adapters. Paul H. Tarver -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Peter Cushing Sent: Tuesday, August 20, 2019 4:40 AM To: profoxt...@leafe.com Subject: SQL server connection 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 reporting purposes but may need to write to it at some point. Looking through the archives some people mentioned SPT and others cursor adapters. Just wondering what people recommend to connect, so I can avoid the usual gotchas. Thanks, -- Peter Cushing IT Department WHISPERING SMITH This communication is intended for the person or organisation to whom it is addressed. The contents are confidential and may be protected in law. Unauthorised use, copying or disclosure of any of it may be unlawful. If you have received this message in error, please notify us immediately by telephone or email. www.whisperingsmith.com Whispering Smith Ltd Head Office:61 Great Ducie Street, Manchester M3 1RR. Tel:0161 831 3700 Fax:0161 831 3715 London Office: 101 St. Martin's Lane,London, WC2N 4AZ Tel:0207 299 7960 [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/006501d55761$2dfc4790$89f4d6b0$@tpcqpc.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: So how many classes in a VCX is *too* many ...
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 -- 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 quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/by5pr02mb6852ce30be718a494357c760a1...@by5pr02mb6852.namprd02.prod.outlook.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: SQL server connection
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 a écrit : > > 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 never been able to wrap my head around cursor adapters > completely. Maybe it’s a control issue! :) I think SPT just made more sense > to me upfront. Thankfully, Foxpro gives you plenty of different ways to > accomplish the same things and you can pick the one that works the way you > do! I use it to query data for reporting purposes and it gives me a lot of > control over how I construct the query string since I can use all of the > string functions within Foxpro to build exactly the query I want based upon > users' selections. > > Another advantage is I able to dump the query string to my audit files just > before the SQLEXEC() command fires, so if something goes wrong, I can just > copy the query to my SQL management tool and see if I can manually figure out > what is going on. > > So far, I've used SPT successfully to backend Foxpro with SQL, MySQL, Oracle, > Access, PostgreSQL, SQLite, etc. I just tweak queries to customize for the > database and the rest of my code remains the same. > > It works for me, but I'm sure, someone else here will provide you with the > benefits of cursor adapters. > > Paul H. Tarver > > > -Original Message- > From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Peter > Cushing > Sent: Tuesday, August 20, 2019 4:40 AM > To: profoxt...@leafe.com > Subject: SQL server connection > > 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 reporting > purposes but may need to write to it at some point. Looking through the > archives some people mentioned SPT and others cursor adapters. Just > wondering what people recommend to connect, so I can avoid the usual > gotchas. > > Thanks, > -- > Peter Cushing > IT Department > WHISPERING SMITH > > > > This communication is intended for the person or organisation to whom it is > addressed. The contents are confidential and may be protected in law. > Unauthorised use, copying or disclosure of any of it may be unlawful. If you > have received this message in error, please notify us immediately by > telephone or email. > > www.whisperingsmith.com > > Whispering Smith Ltd Head Office:61 Great Ducie Street, Manchester M3 1RR. > Tel:0161 831 3700 > Fax:0161 831 3715 > > London Office: 101 St. Martin's Lane,London, WC2N 4AZ Tel:0207 299 7960 > > [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/2d89c72e-0f84-41a1-885c-c45f1320d...@foxincloud.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: SQL server connection
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 interfaces will use the same sprocs you laid down today whenever they are activated. Or use CursorAdapters and make the app a bit more able for change in case they choose to NOT use SQL Server at some point in the future. --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/b0be81d7-3f85-9d28-de6a-6fe85b1b3...@mbsoftwaresolutions.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: SQL server connection
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 today, but initially, I steered clear of them after initial issues in VFP8 after reading Ed Leafe's and others testing results. I know others who use CAs and they work great for them, making it super easy to change backends (VFP, SQL Server, Firebird, etc.) without much code change at all apparently. On 8/20/2019 10:11 AM, Paul H. Tarver wrote: 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 never been able to wrap my head around cursor adapters completely. Maybe it’s a control issue! :) I think SPT just made more sense to me upfront. Thankfully, Foxpro gives you plenty of different ways to accomplish the same things and you can pick the one that works the way you do! I use it to query data for reporting purposes and it gives me a lot of control over how I construct the query string since I can use all of the string functions within Foxpro to build exactly the query I want based upon users' selections. Another advantage is I able to dump the query string to my audit files just before the SQLEXEC() command fires, so if something goes wrong, I can just copy the query to my SQL management tool and see if I can manually figure out what is going on. So far, I've used SPT successfully to backend Foxpro with SQL, MySQL, Oracle, Access, PostgreSQL, SQLite, etc. I just tweak queries to customize for the database and the rest of my code remains the same. It works for me, but I'm sure, someone else here will provide you with the benefits of cursor adapters. Paul H. Tarver -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Peter Cushing Sent: Tuesday, August 20, 2019 4:40 AM To: profoxt...@leafe.com Subject: SQL server connection 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 reporting purposes but may need to write to it at some point. Looking through the archives some people mentioned SPT and others cursor adapters. Just wondering what people recommend to connect, so I can avoid the usual gotchas. Thanks, --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/0dae4f3d-c30d-cece-0815-1ebb3146c...@mbsoftwaresolutions.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: SQL server connection
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 case. Resistance to the change could lead to termination from the team in all honesty as they make progress. Finding replacement VFP work today is not as easy as it used to be. On Tue, Aug 20, 2019 at 9:55 AM MB Software Solutions, LLC < mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote: > 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 today, but initially, I steered clear of them after > initial issues in VFP8 after reading Ed Leafe's and others testing > results. I know others who use CAs and they work great for them, making > it super easy to change backends (VFP, SQL Server, Firebird, etc.) > without much code change at all apparently. > > > On 8/20/2019 10:11 AM, Paul H. Tarver wrote: > > 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 never been able to wrap my head around cursor > adapters completely. Maybe it’s a control issue! :) I think SPT just made > more sense to me upfront. Thankfully, Foxpro gives you plenty of different > ways to accomplish the same things and you can pick the one that works the > way you do! I use it to query data for reporting purposes and it gives me a > lot of control over how I construct the query string since I can use all of > the string functions within Foxpro to build exactly the query I want based > upon users' selections. > > > > Another advantage is I able to dump the query string to my audit files > just before the SQLEXEC() command fires, so if something goes wrong, I can > just copy the query to my SQL management tool and see if I can manually > figure out what is going on. > > > > So far, I've used SPT successfully to backend Foxpro with SQL, MySQL, > Oracle, Access, PostgreSQL, SQLite, etc. I just tweak queries to customize > for the database and the rest of my code remains the same. > > > > It works for me, but I'm sure, someone else here will provide you with > the benefits of cursor adapters. > > > > Paul H. Tarver > > > > > > -Original Message- > > From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of > Peter Cushing > > Sent: Tuesday, August 20, 2019 4:40 AM > > To: profoxt...@leafe.com > > Subject: SQL server connection > > > > 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 reporting > > purposes but may need to write to it at some point. Looking through the > > archives some people mentioned SPT and others cursor adapters. Just > > wondering what people recommend to connect, so I can avoid the usual > > gotchas. > > > > Thanks, > > --- > This email has been checked for viruses by Avast antivirus software. > https://www.avast.com/antivirus > > [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/CAJidMYLs=rm+qmyvmnsxdgajzocbzmvpopfehdnft5b_doc...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: SQL server connection
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 promoting future ways of doing things in this case. Resistance to the change could lead to termination from the team in all honesty as they make progress. Finding replacement VFP work today is not as easy as it used to be. Well certainly do whatever to not get fired, of course! But my point was that the CAs appear to be much more flexible if you're going to be doing any VFP work with an eye on the future with respect to using non-VFP databases in the future. That's all. --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/28765766-fe04-1218-04da-d3c1818c8...@mbsoftwaresolutions.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: So how many classes in a VCX is *too* many ...
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 Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/20a4cb58-941f-4d8c-a51a-8bf1b3c63...@www.fastmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: So how many classes in a VCX is *too* many ...
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 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 Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/bn6pr10mb1458768bbfd6ec38d2c32500d2...@bn6pr10mb1458.namprd10.prod.outlook.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: SQL server connection
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 wondering what version of the ODBC driver are you using. Mine is: Microsoft SQL Server ODBC Driver Version 06.01.7601 Did a few quick searches and can't seem to establish if this is a 32 or 64 bit driver. When I click test data source it comes back with Tests completed successfully but if I try ?sqlconnect('x2live') && returns -1 I have tried putting in the username/password and didn't make any difference. What actual commands do you use to connect? TIA Peter Cushing IT Department WHISPERING SMITH On 20/08/2019 15:11, Paul H. Tarver wrote: > 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 never been able to wrap my head around cursor adapters > completely. Maybe it’s a control issue! :) I think SPT just made more sense > to me upfront. Thankfully, Foxpro gives you plenty of different ways to > accomplish the same things and you can pick the one that works the way you > do! I use it to query data for reporting purposes and it gives me a lot of > control over how I construct the query string since I can use all of the > string functions within Foxpro to build exactly the query I want based upon > users' selections. > > Another advantage is I able to dump the query string to my audit files just > before the SQLEXEC() command fires, so if something goes wrong, I can just > copy the query to my SQL management tool and see if I can manually figure out > what is going on. > > So far, I've used SPT successfully to backend Foxpro with SQL, MySQL, Oracle, > Access, PostgreSQL, SQLite, etc. I just tweak queries to customize for the > database and the rest of my code remains the same. > > It works for me, but I'm sure, someone else here will provide you with the > benefits of cursor adapters. > > Paul H. Tarver > > > -Original Message- > From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Peter > Cushing > Sent: Tuesday, August 20, 2019 4:40 AM > To: profoxt...@leafe.com > Subject: SQL server connection > > 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 reporting > purposes but may need to write to it at some point. Looking through the > archives some people mentioned SPT and others cursor adapters. Just > wondering what people recommend to connect, so I can avoid the usual > gotchas. > > Thanks, This communication is intended for the person or organisation to whom it is addressed. The contents are confidential and may be protected in law. Unauthorised use, copying or disclosure of any of it may be unlawful. If you have received this message in error, please notify us immediately by telephone or email. www.whisperingsmith.com Whispering Smith Ltd Head Office:61 Great Ducie Street, Manchester M3 1RR. Tel:0161 831 3700 Fax:0161 831 3715 London Office: 101 St. Martin's Lane,London, WC2N 4AZ Tel:0207 299 7960 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/cd181cca-1b06-48f3-23b6-cb9466b18...@whisperingsmith.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: So how many classes in a VCX is *too* many ...
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* many ... 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 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 [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/001101d5577b$11c2ca30$35485e90$@powerchurch.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: SQL server connection
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 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 whenever they are activated. On Tue, Aug 20, 2019 at 7:24 AM Frank Cazabon wrote: 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 VFP I would probably use CursorAdapters but I have never actually used them for more than playing with to learn about them. I believe they give you enough flexibility while hiding some of the technical details. If you want absolute control, then go with SPT. Frank. Frank Cazabon On 20/08/2019 05:39 AM, Peter Cushing wrote: 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 reporting purposes but may need to write to it at some point. Looking through the archives some people mentioned SPT and others cursor adapters. Just wondering what people recommend to connect, so I can avoid the usual gotchas. Thanks, [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/cf6bd2c1-06c7-35e6-354e-472f0d257...@gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: SQL server connection
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 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 wondering what version of the ODBC driver are you using. Mine is: Microsoft SQL Server ODBC Driver Version 06.01.7601 Did a few quick searches and can't seem to establish if this is a 32 or 64 bit driver. When I click test data source it comes back with Tests completed successfully but if I try ?sqlconnect('x2live') && returns -1 I have tried putting in the username/password and didn't make any difference. What actual commands do you use to connect? TIA Peter Cushing IT Department WHISPERING SMITH On 20/08/2019 15:11, Paul H. Tarver wrote: 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 never been able to wrap my head around cursor adapters completely. Maybe it’s a control issue! :) I think SPT just made more sense to me upfront. Thankfully, Foxpro gives you plenty of different ways to accomplish the same things and you can pick the one that works the way you do! I use it to query data for reporting purposes and it gives me a lot of control over how I construct the query string since I can use all of the string functions within Foxpro to build exactly the query I want based upon users' selections. Another advantage is I able to dump the query string to my audit files just before the SQLEXEC() command fires, so if something goes wrong, I can just copy the query to my SQL management tool and see if I can manually figure out what is going on. So far, I've used SPT successfully to backend Foxpro with SQL, MySQL, Oracle, Access, PostgreSQL, SQLite, etc. I just tweak queries to customize for the database and the rest of my code remains the same. It works for me, but I'm sure, someone else here will provide you with the benefits of cursor adapters. Paul H. Tarver -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Peter Cushing Sent: Tuesday, August 20, 2019 4:40 AM To: profoxt...@leafe.com Subject: SQL server connection 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 reporting purposes but may need to write to it at some point. Looking through the archives some people mentioned SPT and others cursor adapters. Just wondering what people recommend to connect, so I can avoid the usual gotchas. Thanks, This communication is intended for the person or organisation to whom it is addressed. The contents are confidential and may be protected in law. Unauthorised use, copying or disclosure of any of it may be unlawful. If you have received this message in error, please notify us immediately by telephone or email. www.whisperingsmith.com Whispering Smith Ltd Head Office:61 Great Ducie Street, Manchester M3 1RR. Tel:0161 831 3700 Fax:0161 831 3715 London Office: 101 St. Martin's Lane,London, WC2N 4AZ Tel:0207 299 7960 [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/25ca7b5a-ff9e-6bd6-e9ba-cc113a950...@mbsoftwaresolutions.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Happy Anniversary!
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! Including all the Dry humor - of which many times I had to hold myself back from laughing out loud - and making a fool of myself at work! -K- On 8/19/2019 9:02 AM, Malcolm Greene wrote: I came for the language and stayed for the community. To paraphrase the Who: FoxPro is dead, long live Profox! Thank you Ed! Malcolm [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/a5a17c98-35b8-d335-4c01-d4e4eef92...@optonline.net ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
[NF] Microsoft Teams
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 antivirus software. https://www.avast.com/antivirus ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/83f80650-8c50-c1af-9542-d691fe46c...@mbsoftwaresolutions.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: [NF] Microsoft Teams
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 Solutions, LLC Sent: Wednesday, 21 August 2019 12:36 PM To: profox@leafe.com Subject: [NF] Microsoft Teams 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 antivirus software. https://www.avast.com/antivirus [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/000d01d557d1$5e56dcf0$1b0496d0$@adam.com.au ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Easiest/best way to create an email using local MS Outlook with file attachments?
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 Outlook via CREATEOBJECT and set properties and attachments accordingly? Typically in the past I've used MAILTO and ShellExec but this time the extra requirement is to have files attached from the application too, which makes MAILTO not an option, if I understand correctly. tia, --Mike --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/97df0ecb-3a02-ecac-cd8a-77c01fff6...@mbsoftwaresolutions.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Easiest/best way to create an email using local MS Outlook with file attachments?
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 needed to do attachments as well. Book w/all answers is by Hentzenwerks (probably misspelled that!). But, there you have it... -K- On 8/20/2019 9:22 PM, MB Software Solutions, LLC wrote: 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 Outlook via CREATEOBJECT and set properties and attachments accordingly? Typically in the past I've used MAILTO and ShellExec but this time the extra requirement is to have files attached from the application too, which makes MAILTO not an option, if I understand correctly. tia, --Mike --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/f9d0f93d-a5d4-bf83-9bb9-1f8020a07...@gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: [NF] Microsoft Teams
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 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 Solutions, LLC Sent: Wednesday, 21 August 2019 12:36 PM To: profox@leafe.com Subject: [NF] Microsoft Teams 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 antivirus software. https://www.avast.com/antivirus [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/000d01d557d1$5e56dcf0$1b0496d0$@adam.com.au ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious. Report [OT] Abuse: http://leafe.com/reportAbuse/000d01d557d1$5e56dcf0$1b0496d0$@adam.com.au ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/cwlp265mb1668208a37dc22d0805a9a5c8f...@cwlp265mb1668.gbrp265.prod.outlook.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Easiest/best way to create an email using local MS Outlook with file attachments?
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 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 Outlook > via CREATEOBJECT and set properties and attachments accordingly? Typically > in the past I've used MAILTO and ShellExec but this time the extra > requirement is to have files attached from the application too, which makes > MAILTO not an option, if I understand correctly. > > tia, > --Mike > > > > --- > This email has been checked for viruses by Avast antivirus software. > https://www.avast.com/antivirus > > [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/9d2c6ca9-27b9-4156-9ca5-8e3cdabb5...@johnweller.co.uk ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.