Re: PDF Scraping

[Stephen Russell]

Keeping mouth shut.



On Tue, Jan 16, 2024 at 10:24 AM Richard Kaye  wrote:

> As Stephen would say, Bad Ed! 😉
>
> From: ProfoxTech  On Behalf Of Ed Leafe
> Sent: Monday, January 15, 2024 8:18 PM
> To: profoxt...@leafe.com
> Subject: Re: PDF Scraping
>
> On Jan 12, 2024, at 21:51, Brian Erickson 
> wrote:
> >
> > It is really easy to do with python.
>
> Heh, I think those exact words with most posts on this list! ;-P
>
>
> -- Ed Leafe
>
[excessive quoting removed by server]

___
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 message: 
https://leafe.com/archives/byMID/cajidmyj26d7ddfjijo2eavw_1v2d4-n7trfl+vne+yxxezk...@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: FW: SQL Upsize

[Stephen Russell]

It may be an issue with a date column in FP that is not the same thing in
newer versions of SQL Server.

It may be a lot of other things as well, this is first guess.

How many gigs of data?

What version of SQL are you targeting?   Are you using SSMS to work with
SQL?  With that you could PULL the data from FoxPro into a new db that you
create.  I think the oledb driver will still be seen and useable in SSMS?


On Thu, Oct 5, 2023 at 12:18 PM Richard Kaye  wrote:

> Are you using the Upsizing Wizard? If so, have you gotten the latest and
> greatest from Github/VFPX? It’s been updated a few times over the years and
> one of the changes IIRC was to better handle newer versions of SQL. Well,
> newer than what was around at the time. 😊 Highly recommended. Using SQL
> 2008? Not so much... 😉
>
> 
>
> --
>
> rk
>
> From: ProfoxTech  On Behalf Of Graham Brown
> Sent: Thursday, October 5, 2023 12:35 PM
> To: profoxt...@leafe.com
> Subject: RE: FW: SQL Upsize
>
> Hi
> Thanks
>
> Yes, the database and tables all get created via the upsizing wizard so
> definitely something to do with the data itself
> The upsizing wizard has worked in the past probably 2000 to 2005 but won't
> work in 2008r2. Havent done one of these in a long time.
>
> In the upsizing wizard I uncheck indices, integrity etc etc but made no
> difference
>
> I have created a simple prg to create a cursor adapter on the local data
> and another on the server data. This does scatter and gather between the
> two but on a table with 500k records it takes two days to run so too slow.
>
> The next thing I am going to try is manually creating the insert sql
> commands and run these in EM, just a pita if I am missing something obvious.
>
> Interesting one.
>
> Graham
>
[excessive quoting removed by server]

___
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 message: 
https://leafe.com/archives/byMID/cajidmyjlp0arvx4-8qgdeyrqgk-zhbrmz0m7q6kubenp-ge...@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: Just call me Master, for short

[Stephen Russell]

I got a chuckle.  I clicked on the link and.

Mimecast requires you to enroll this device to access message links

Your IT department has enabled Targeted Threat Protection for all users.
This is a service that protects you from email attacks and provides live
security training.

Enter your email address and we'll send you an authentication code to
verify your identity.

On Fri, Sep 1, 2023 at 2:28 PM Richard Kaye  wrote:

> Congrats, Vince!
>
> --
>
> rk
>
>
>
> From: ProfoxTech  On Behalf Of Vincent
> Teachout
> Sent: Friday, September 1, 2023 1:18 PM
> To: profoxt...@leafe.com
> Subject: Just call me Master, for short
>
>
> And... Done!
>
> Master of Science in Information Security.
>
> https://protect-us.mimecast.com/s/Bhq1CR6M0Phj8zgioDwqf?domain=parchment.com
>
>
> If you have any Science or Information Security that needs mastering, just
> let me know.
>
>
>
[excessive quoting removed by server]

___
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 message: 
https://leafe.com/archives/byMID/cajidmyjmls_vbuftzjewj2d0t1df5rzcskdcezexhd1z8eh...@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: Fun with .Net DLLs

[Stephen Russell]

NP.  I don't know if you can do that from VFP because I have no
experience in it.

There is a free tool from M$ called VS Code that works on everything and
works everywhere.  I found this and you can add in the ability to work with
VFP code they say.
https://github.com/mattslay/Visual-FoxPro-language-template-for-Visual-Studio-Code

Not sure if this helps or only muddies the waters.

>From a web development perspective, VS Code allows you to work with so many
different things that it is becoming an editor for almost everyone.  Htmt,
CSS, javascript frameworks of the day, python, oh yeah .net as well.




On Wed, Apr 5, 2023 at 11:43 AM Richard Kaye  wrote:

> I want to debug anywhere I can solve my problem. 😊
>
> Because I’m a VFP guy I’m trying to attach the VS debugger to the VFP
> process so I can debug wherever I want. But I’m such a n00b with VS that my
> progress is glacial…
>
> --
>
> rk
>
> From: ProfoxTech  On Behalf Of Stephen
> Russell
> Sent: Wednesday, April 5, 2023 10:21 AM
> To: profoxt...@leafe.com
> Subject: Re: Fun with .Net DLLs
>
> What are you expecting in the debug/test? In my mind, I'd make a console
> app and reference this picture dll you made. That console will act like
> VFP in the pass something to the DLL and receive the output in some way or
> another.
>
> I have been too busy to read the code you presented. Are you expecting to
> pass a path\file and get the modified path\Newfile back, or was this
> streaming the file in memory to you that you catch the stream and do with
> it as you pleased?
>
> On Wed, Apr 5, 2023 at 7:15 AM Richard Kaye  rk...@invaluable.com>> wrote:
>
> > Thanks, Darren! Much appreciated.
> >
> > I've got the DLL building OK in VS but figuring out how to debug is a
> > challenge. Apparently because the solution is a "Helper" class library,
> > direct debugging is not possible. In VFP I'm using wwDotNetBridge to load
> > the assembly which appears to succeed but when I attempt to invoke the
> > static method it returns a null. Until I can figure out the debugging
> > process it's an arduous process. Rick Strahl has a pretty extensive white
> > paper on how to do this sort of stuff but the learning curve is steep for
> > an old VFP guy...
> >
> > --
> >
> > rk
> >
> > From: ProfoxTech  profoxtech-boun...@leafe.com>> On Behalf Of Darren
> > Sent: Tuesday, April 4, 2023 10:53 PM
> > To: profoxt...@leafe.com<mailto:profoxt...@leafe.com>
> > Subject: RE: Fun with .Net DLLs
> >
> > Richard it is relatively simple.
> >
> > Done it many times but not for a while - I'll hunt down my notes and get
> > something to you. Essentially it is making the .Net assembly com visible
> > and
> > then it is easy to use in VFP.
> >
> > I'll do that this evening.
> >
> > Cheers
> >
> >
> > -Original Message-
> > From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
> > Richard
> > Kaye
> > Sent: Wednesday, 5 April 2023 1:37 AM
> > To: profoxt...@leafe.com<mailto:profoxt...@leafe.com profoxt...@leafe.com%3cmailto:profoxt...@leafe.com>>
> > Subject: RE: Fun with .Net DLLs
> >
> > Thanks, Alan, much appreciated.
> >
> > I was just going through the various build options. The 32 bit thing will
> > be
> > a the top of the checklist.
> >
> > I thought there was a magic way to connect the debugger to an external
> > process (e.g. VFP). There's some stuff in Doug's white paper on how to do
> > that but I'm just at the beginning of this journey.
> >
> > --
> >
> > rk
> >
> > From: ProfoxTech  <mailto:profoxtech-boun...@leafe.com%3cmailto:%0b>>
> profoxtech-boun...@leafe.com<mailto:profoxtech-boun...@leafe.com>>> On
> Behalf Of Alan Bourke
> > Sent: Tuesday, April 4, 2023 10:36 AM
> > To: profoxt...@leafe.com<mailto:profoxt...@leafe.com profoxt...@leafe.com%3cmailto:profoxt...@leafe.com>>
> > Subject: Re: Fun with .Net DLLs
> >
> > Richard
> > I assume you created a project of type 'Class Library'. No you can't
> debug
> > those, you need to host it in some other sort of exectuable project. To
> > debug that you either need to add another project of a type that is
> > executable to your solution (like a Windows Forms, WPF or Console
> > application) and reference the output from the first project in that, so
> > you
> > can test it. You need to right-click on that project in Solution Explorer
> > and select 'Set As Startup P

Re: Fun with .Net DLLs

[Stephen Russell]

What are you expecting in the debug/test?  In my mind, I'd make a console
app and reference this picture dll you made.  That console will act like
VFP in the pass something to the DLL and receive the output in some way or
another.

I  have been too busy to read the code you presented.  Are you expecting to
pass a path\file and get the modified path\Newfile back, or was this
streaming the file in memory to you that you catch the stream and do with
it as you pleased?

On Wed, Apr 5, 2023 at 7:15 AM Richard Kaye  wrote:

> Thanks, Darren! Much appreciated.
>
> I've got the DLL building OK in VS but figuring out how to debug is a
> challenge. Apparently because the solution is a "Helper" class library,
> direct debugging is not possible. In VFP I'm using wwDotNetBridge to load
> the assembly which appears to succeed but when I attempt to invoke the
> static method it returns a null. Until I can figure out the debugging
> process it's an arduous process. Rick Strahl has a pretty extensive white
> paper on how to do this sort of stuff but the learning curve is steep for
> an old VFP guy...
>
> --
>
> rk
>
> From: ProfoxTech  On Behalf Of Darren
> Sent: Tuesday, April 4, 2023 10:53 PM
> To: profoxt...@leafe.com
> Subject: RE: Fun with .Net DLLs
>
> Richard it is relatively simple.
>
> Done it many times but not for a while - I'll hunt down my notes and get
> something to you. Essentially it is making the .Net assembly com visible
> and
> then it is easy to use in VFP.
>
> I'll do that this evening.
>
> Cheers
>
>
> -Original Message-
> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
> Richard
> Kaye
> Sent: Wednesday, 5 April 2023 1:37 AM
> To: profoxt...@leafe.com
> Subject: RE: Fun with .Net DLLs
>
> Thanks, Alan, much appreciated.
>
> I was just going through the various build options. The 32 bit thing will
> be
> a the top of the checklist.
>
> I thought there was a magic way to connect the debugger to an external
> process (e.g. VFP). There's some stuff in Doug's white paper on how to do
> that but I'm just at the beginning of this journey.
>
> --
>
> rk
>
> From: ProfoxTech  profoxtech-boun...@leafe.com>> On Behalf Of Alan Bourke
> Sent: Tuesday, April 4, 2023 10:36 AM
> To: profoxt...@leafe.com
> Subject: Re: Fun with .Net DLLs
>
> Richard
> I assume you created a project of type 'Class Library'. No you can't debug
> those, you need to host it in some other sort of exectuable project. To
> debug that you either need to add another project of a type that is
> executable to your solution (like a Windows Forms, WPF or Console
> application) and reference the output from the first project in that, so
> you
> can test it. You need to right-click on that project in Solution Explorer
> and select 'Set As Startup Project'.
>
> Normally I would recommend to test it on the .NET side you actually use a
> proper testing framework like MSTest or NUnit. However what you're trying
> to
> really needs to be checked visually so that's probably overkill initially.
>
> Did you make the relevant methods COM-visible, i.e. like:
>
> [ComVisible(true)]
> [Guid("8C019E76-59BE-43A6-9DD9-66F7C9CAE67B")]
> [ProgId("MyApp.ExcelConvert")]
> [ClassInterface(ClassInterfaceType.AutoDual)]
> [ComSourceInterfaces(typeof(IExcelConvertEvents))]
> public class ExcelConvertHelper
> {
> ...
> }
>
> I must confess I've never gotten the wwDotNetBridge registration-free COM
> to
> work. I've always had to add an installer project in .NET and just make
> users install and register the assembly.
>
> Don't forget you have to build it as 32-bit to use it from VFP.
>
> --
> Alan Bourke
> alanpbourke (at) fastmail (dot) fm
>
[excessive quoting removed by server]

___
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 message: 
https://leafe.com/archives/byMID/cajidmy+ubx81q9k4m8ymz9auz3b3szt1bm_xzgiql_mh15k...@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.

I was on a call this morning with a guy who claimed to be a FP/VFP support with M$

[Stephen Russell]

His name is John Ramminger.  Does anyone have any memories of this guy?

Now he is a Sharepoint consultant.
-- 
Stephen Russell
Sr. Analyst
Ring Container Technology
Oakland TN

901.246-0159 cell


--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

___
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 message: 
https://leafe.com/archives/byMID/cajidmyjth0sqc3gf2+w+cvfqxatqcfayjuxgxxdjl3itr0+...@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: fox.wikis.com

[Stephen Russell]

Just go to the ARCHIVE of the web.

https://web.archive.org/web/202200*/http://fox.wikis.com/



On Thu, Oct 6, 2022 at 9:06 AM Ted Roche  wrote:

> On Thu, Oct 6, 2022 at 6:16 AM Man-wai Chang  wrote:
> >
> > That's just a backup, which might disappear some days.
>
> All of mankind's works are like dust in the wind.
>
> If you are worried that the Internet Archive will disappear, you could
> always download all the pages of the fox wiki from there onto your own
> media.
>
> Some search engines also allow access to cached pages.
>
> If the fox.wikis.com proprietors really wanted to make it all
> disappear, they'd update their robots.txt file and many cached copies
> would fail.
>
> > Is it really impossible to set fox.wikis.com read-only blocking all
> writers?
>
> Of course it could be done. That is not what the owner intended.
>
> Wiki is read-write.
> Read-only Wiki just text.
> Is it still Wiki?
>
> > / v \ 64-bit Fedora 25 Server Spin
>
> That's a dangerously out-of-date copy of Fedora. You should update
> your email footer.
>
> I met a traveller from an antique land,
> Who said—“Two vast and trunkless legs of stone
> Stand in the desert. . . . Near them, on the sand,
> Half sunk a shattered visage lies, whose frown,
> And wrinkled lip, and sneer of cold command,
> Tell that its sculptor well those passions read
> Which yet survive, stamped on these lifeless things,
> The hand that mocked them, and the heart that fed;
> And on the pedestal, these words appear:
> My name is Ozymandias, King of Kings;
> Look on my Works, ye Mighty, and despair!
> Nothing beside remains. Round the decay
> Of that colossal Wreck, boundless and bare
> The lone and level sands stretch far away.”
>
> Ozymandias, Shelley
>
[excessive quoting removed by server]

___
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 message: 
https://leafe.com/archives/byMID/CAJidMYKL3KcmUu-WSTZtY=o5jSquryBAaDQPrW-5mAYFKbm=n...@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: Pictures in a table

[Stephen Russell]

In some environments, you have to store the document in a db because you
are on a large network.  That path may not correspond to others say viewing
an XRay and getting an opinion from a team in Japan, Australia,  etc.

You also have to have killer backups of that folder where they are kept as
well.

Our rule is to convert all "visual" objects to pdf and insert that into the
db.  I have to store vendor publications on carcinogens with our raw
materials, and have plants all over the world have access to that if a
customer asks for it.

On Tue, Aug 16, 2022 at 9:33 AM Alan Bourke  wrote:

> IMO don't ever store binary objects in a relational database table. Store
> a relative path and filename from a root disk location.
>
> --
>   Alan Bourke
>   alanpbourke (at) fastmail (dot) fm
>
[excessive quoting removed by server]

___
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 message: 
https://leafe.com/archives/byMID/cajidmy+4g9hxrqpqrdk_cpikqqpmj-ihv88po4x-zh5vzet...@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: Need Help - Foxpro & Chilkat & Rest API

[Stephen Russell]

Do you use Postman to test what yo need to do with the API?  Then just make
the same call from the web side of VFP.  Catch json responses and you are
good.

On Tue, Jul 12, 2022 at 9:20 AM Richard Kaye  wrote:

> Generally speaking, the token is the key that unlocks access to the APIs
> you want to call. So you need to persist that in your business object, and
> pass it to any API calls you make. Depending on the API you're hitting, the
> token value could be in the request header or it could be a key:value pair
> in the payload.
>
> --
>
> rk
>
> From: ProfoxTech  On Behalf Of Paul H.
> Tarver
> Sent: Tuesday, July 12, 2022 9:38 AM
> To: profoxt...@leafe.com
> Subject: RE: Need Help - Foxpro & Chilkat & Rest API
>
> Definitely!
>
> I did have a small breakthrough yesterday as I was able to get an OAuth2
> Token returned from within VFP. Woohoo!
>
> Now if I can just figure out what to do with it. :)
>
> Paul H. Tarver
> Tarver Program Consultants, Inc.
>
> -Original Message-
> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ed
> Leafe
> Sent: Monday, July 11, 2022 4:54 PM
> To: profoxt...@leafe.com
> Subject: Re: Need Help - Foxpro & Chilkat & Rest API
>
> On Jul 11, 2022, at 16:51, Paul H. Tarver  p...@tpcqpc.com>> wrote:
> >
> > I'll keep looking for your project and when you release it, I'll definite
> > consider upgrading to your tool as soon as I can.
>
> Sounds like a potential beta tester! ;-)
>
> -- Ed Leafe
>
>
>
>
>
>
>
[excessive quoting removed by server]

___
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 message: 
https://leafe.com/archives/byMID/CAJidMY+=4-_hfya-ifx8tkdqoxbmdzdw5x4rd+tmvhdw_9m...@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: VFP to SharePoint Spreadsheet Dashboard

[Stephen Russell]

I'd consider doing a PowerBI dashboard to deliver the "news" on trailer
status.

Doing it in SP is good too, but updating that data source is a lot harder
IMO from VFP.

>From SQL Server there are hooks built for doing this in an SSIS job.  You
could schedule that job to run ever 2-5 min.  You could probably pull from
VFP data in SSIS as well.  Just getting that running is a hurdle to
overcome.

What version of SP?  On prem or M365?

On Tue, Apr 5, 2022 at 1:32 PM Tracy Pearson  wrote:

> It was a long time ago I heard a talk about SharePoint. Does the
> Spreadsheet
> basically use an Access database, or an MSSql server for the backend data?
> Wouldn't you just be updating that table and the SharePoint site will take
> care of the rest?
>
> I haven't done this myself, I only remember bits of the talk and none of
> the
> front end implementation.
>
> Tracy
>
> -Original Message-
> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of James
> Trogdon
> Sent: Tuesday, April 05, 2022 2:08 PM
> To: profoxt...@leafe.com
> Subject: VFP to SharePoint Spreadsheet Dashboard
>
>
> Hi All,
>
> The company I work for is eventually going to a new ERP but until that time
> I still must maintain some VFP (version 6 and 9) apps.  I have a trailer
> assigning project that will allow people to scan orders to a trailer.  The
> orders are then scanned when they begin loading and when they finish
> loading.  After the loading, a query is run to determine if all the orders
> for that trailer is complete.  I had thought to just email the information,
> but the users are wanting a live dashboard configured as a SharePoint
> Spreadsheet where everybody in the company can see it.  The shipping tower
> would like to mark when an order has been picked and delivered.  I've never
> done any development accessing SharePoint with VFP so I thought I would ask
> how you would display a dashboard that would refresh every 5 minutes or so
> but still allow certain fields to be marked as complete on the spreadsheet.
> I would assume the program would be setup as scheduled task running every 5
> minutes to update the spreads
>  heet.  Any help would be greatly appreciated.  Thanks!
>
>
>
>
>
>
> [Prestige Fabricators, Inc.]   James Trogdon
> IT Manager
> jtrog...@prestigefab.com
> O: 336.626.4596 ext. 12051
> 905 NC Highway 49 S, Asheboro, NC 27205
> 
> The content of this email is confidential and intended for the recipient
> specified in message only. It is strictly forbidden to share any part of
> this message with any third party, without a written consent of the sender.
> If you received this message by mistake, please reply to this message and
> follow with its deletion, so that we can ensure such a mistake does not
> occur in the future.
>
> Disclaimer
>
> The information contained in this communication from the sender is
> confidential. It is intended solely for use by the recipient and others
> authorized to receive it. If you are not the recipient, you are hereby
> notified that any disclosure, copying, distribution or taking action in
> relation of the contents of this information is strictly prohibited and may
> be unlawful.
>
> This email has been scanned for viruses and malware, and may have been
> automatically archived by Mimecast Ltd, an innovator in Software as a
> Service (SaaS) for business. Providing a safer and more useful place for
> your human generated data. Specializing in; Security, archiving and
> compliance. To find out more visit the Mimecast website.
>
>
> --- StripMime Report -- processed MIME parts ---
> multipart/related
>   multipart/alternative
> text/plain (text body -- kept)
> text/html
>   image/gif
> ---
>
[excessive quoting removed by server]

___
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 message: 
https://leafe.com/archives/byMID/cajidmykbopdtm7fabite3h_ofe5wxyapfx-o9hpwmbysba4...@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: CURSORTOXML and NULLs

[Stephen Russell]

You could consider your TSQL query to give you the XML in the initial query.

using :

Select 

FOR XML PATH('NameOfDataHere'), ROOT('NameOfDataHere'), ELEMENTS

When you name the columns, put in the XML element path/name

c.ClientCity as "billTo/address/city",




On Tue, Mar 29, 2022 at 6:45 PM Richard Kaye  wrote:

> Let’s try this again. (Stupid Outlook…)
>
> That’s another possibility. Thanks, Tracy. 😊
>
> The original data source is coming from a SQL backend so I’ve just added
> some ISNULL calls around the fields which matter to the
> CURSORTOXML/XMLTOCURSOR calls.
>
> --
>
> rk
>
> From: ProfoxTech  On Behalf Of Tracy Pearson
> Sent: Tuesday, March 29, 2022 7:33 PM
> To: profoxt...@leafe.com
> Subject: Re: CURSORTOXML and NULLs
>
> I tend to create the cursor and use flags to append to the existing cursor.
>
> Tracy
>
> On March 29, 2022 7:01:47 PM EDT, Richard Kaye  > wrote:
> While I'm poking away at this, I thought I'd check with the collective
> wisdom. I've found a situation where I want to take advantage of
> CURSORTOXML and XMLTOCURSOR. The issue I'm running into is if the cursor
> being converted to XML has fields with NULL values in the first record,
> this appears to affect the resulting XMLTOCURSOR conversion. Any NULL
> columns will be missing from the result cursor even if later rows in the
> XML contain values. The hacky workaround seems to be I have to make sure
> that the first record has non-null values for all columns I want in the
> cursor. Anyone have any other magic tricks?
>
[excessive quoting removed by server]

___
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 message: 
https://leafe.com/archives/byMID/CAJidMYKzLjdatmpSR67=p+d1qz69i+ukkq+mzmsgsbo5f0o...@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: [NF] Facets Database???

[Stephen Russell]

It could be working with them as well.

https://stackoverflow.com/questions/18347277/how-to-create-a-faceted-search-with-sql-server


On Mon, Mar 7, 2022 at 11:14 AM MB Software Solutions, LLC <
mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote:

> That reminds me of DotNet job ads when they asked the same thing.lol
>
> On 3/4/2022 4:57 PM, j...@johnweller.co.uk wrote:
> > It may be that the headhunter doesn't fully understand what they are
> asking for.  I remember a few weeks after Visual Basic was launched seeing
> adverts for programmers with at least two years' experience of Visual
> Basic. 😊
> >
> > John Weller
> > 07976 393631
> >
> >> -Original Message-
> >> From: ProfoxTech  On Behalf Of Ted Roche
> >> Sent: 04 March 2022 21:06
> >> To: profoxt...@leafe.com
> >> Subject: Re: [NF] Facets Database???
> >>
> >> Welcome back, Kurt!
> >>
> >> A quick web search for "facets database" doesn't seem to point to one
> >> product, but rather a feature that several different database engines
> are
> >> offering as different things. It's hard to know what the headhunter
> wants.
> >> Besides heads, of course.
> >>
> >
> >
> > ___
> > Post Messages to: ProFox@leafe.com
> > Subscription Maintenance:
> http://track.smtpsendemail.com/9074967/c?p=qLwa0VAYc-7hraYaZi48C8II4XVQdBBgSsX0n5tTq5ICyC4q4HjIweX8kW2Gdhsum2X0KLb3ToIEVSVwJz099UMB7pzAy1XXATkND1-8ultZuibFbW0Zxb2-8xomkrlNLOZc8EsjqrW53K8KXJztZs6X0TaL5kblwdxzU0LJo2U=
> > OT-free version of this list:
> http://track.smtpsendemail.com/9074967/c?p=G52Wz6yAfuRjd9i8Dr47wwdmnTcM0ORUPKrN0W3lDZpLtwbzD6SAR0bHJKi-Xu9nCj8kOlyosxYVpX1vaQVltXVEL5K3rTXkFSDUgdq4Im-JxTadHL_Wa5Xz80KRwVoK8yJunpbOyk2V3iXH9e_DLzueeqizhkcfy7V4xxUgWrY=
> > Searchable Archive:
> http://track.smtpsendemail.com/9074967/c?p=Pa1UDy5Co7-hmja9O78QcRo8rOfCL7HlldF1XrB-UEykDLt7USMaUjDbdn1d7c7AZavt8D1taN_xve7ygNpESlbEQejoKlyTNQXNwwsYnA9mZuSgXhnEYoMElK0YJruEeTQmob7D3iEmkbeYMynMtQ==
> > This message:
> http://track.smtpsendemail.com/9074967/c?p=jS8Fo1ekY5LPBtyN32QoZTD5ScRStSrggbuDbyB6freQiY8tbEBjEqD5lBNonI0hVPik02Q2k3jMc099irzx7I0POxxaQSy1Op_hxYVNcDT14sjfy0OW_TqyRm7tYtdbB5ugyyrd9bGvEzlg7-4r0y8THji2B3541koiCgo228qjgWosn7A_e52eduIgW9ktS77dddC8lM5pLKEEr-kUXg==
> > ** 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.
>
> --
> Michael J. Babcock, MCP
> Fox/VFP dev since 1997
> Developer of FabNet estimating software - mbsoftwaresolutions.com
[excessive quoting removed by server]

___
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 message: 
https://leafe.com/archives/byMID/CAJidMYL0ag-Srt7wn4gywG1JkyK7=edw6qhvt-d0gkoxkoa...@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.

I saw a Fox to SQL job posting

[Stephen Russell]

   - Develop a system to synchronize data between FoxPro and SQL Server
   databases.

https://codemag.com/Jobs/Apply/03bfd079-f665-43af-a1de-a8eab5c964fa

Probably remote and it gets you noticed at Code mag for future work.





-- 
Stephen Russell
Sr. Analyst
Ring Container Technology
Oakland TN

901.246-0159 cell


--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

___
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 message: 
https://leafe.com/archives/byMID/CAJidMY+Dse1cgi=1jl4g7hrxu8b3agprmrvjfch5zpqamxn...@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: [NF] Beyond Quickbooks

[Stephen Russell]

My company is pushing our ERP from on-prem to on-line.  We were told we
have to DELETE a lot of that old worthless data.  That is 400 gigs of GL
detail in one table alone as well as more in supporting tables.  The point
is we were told that we no longer need ALL of those transactions that are
past IRS rules.  It's been decades since I have used QB and have no memory
of deleting anything in it.

Have you investigated QB online?  I don't know if you could post t QB
online but figure with WestWind you can.  When you push to the cloud that
won't take old antiquated data as a guess, they will expect that you will
keep it on your own computer.  That is what we are going to do because we
can keep the old version on-prem.

I am just passing on what we are doing ourselves.  We have a lot of
learning on how to deal with data that is no longer ours and our data
warehouse.  With your situation, you may find that what QB presents to
users is just fine, and learning how to post a new way isn't that bad.  As
well as giving you more billings in the conversion.



On Fri, Jan 21, 2022 at 12:28 PM MB Software Solutions, LLC <
mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote:

> Yeah but they're near 2GB in file size (like 18 yrs worth of data) so
> they're in need of a solution beyond QB (or find a way to make QB keep
> working for them).  QB Online isn't an option as their VFP app
> integrates with the CFO's QB Desktop version.
>
> I'm no QB expert but I'd like to think there's some sort of process that
> can be done to consolidate/cleanup data over decades.
>
>
> On 1/19/2022 11:09 AM, AndyHC wrote:
> > Twenty some years ago I used Quicken (QuickBooks lite) and was so
> > impressed by the user interface I recommended it as an example of how
> > to write user-friendly code. I was less impressed by their lack of
> > transparency on file structures that allowed them to charge annually
> > for tax rules updates, bu still, pretty much everybody does that now
> > and - it stands out in my memory.
> >
> > ___
> > Post Messages to: ProFox@leafe.com
> > Subscription Maintenance:
> http://track.smtpsendemail.com/9074967/c?p=FJZZDP9yTbjgJ5ZPUwSUS-wIKpFZwpCv_BCeW2JXWfQUPFzRydkhXLgK3_GnxuzLgnNyNJM3u9zIDF1L3FlFoZDbBjiysRSvqRVm5bqndk8MCL14hvxFDtHmFexpubyG4pB7MtdtEyrM_v8Awdtflzysq7Mo4M0fHrz72FUclkY=
> > OT-free version of this list:
> >
> http://track.smtpsendemail.com/9074967/c?p=iWuDNlLfzFLZnoO2xL9Etz2nD-I0ou2NF4S26gPe5r5uNgJXb7CKXzNLQB_bWFD2L5kjDknmiO8Vj0UZ0pgrmYeOyZmrKPtDJIjXy_S8ryHEKjYumbeuhyW93lRn2fOSinKdUf3rgginRyyxr-dQ8Aso68OpNsKOUKzUGu7oz0s=
> > Searchable Archive:
> http://track.smtpsendemail.com/9074967/c?p=Z59I_KFsAbc-pg6LY43CMh7z_sPuEHEAMOwhBcs-4Kk6q7cwI9UtNFtR39RIMeOMDYNY7As0MgFAynXrSjt7qpWfZY6mClNjzKM8LdljH2Ey2vjhonDtK3tp9smXB-LAbx9MXHJkWfV2J-zEvkbUoQ==
> > This message:
> >
> http://track.smtpsendemail.com/9074967/c?p=j5twmiPldUyjasmSmAgVceCg8jW7n5Rz9LHNiksyAO_qFEmM-3VNCCLaRBKrmS6sPu2AdK_ur1mrZ-5KqkhssqLpQqYjMLwLatvRFYRHHH_WxTGoldv8wSmDSBoTF1_JoLf5fhuJ1fIsSirV2T85W5KiSF_V0jCYTx8l4cBcxwYATptUdSXk8lqh8DQcgyMYZI3ngLKj8WG8_zbmcBTHrYTxS4aCvaKwXZWoY4Iy1eQ=
> > ** 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.
>
> --
> Michael J. Babcock, MCP
> Fox/VFP dev since 1997
> Developer of FabNet estimating software - mbsoftwaresolutions.com
[excessive quoting removed by server]

___
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 message: 
https://leafe.com/archives/byMID/CAJidMY+X=xrpjesgnk0bip78mr_+xnp9qgdycps16uaqhdd...@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.

For all of you Forms guys...

[Stephen Russell]

Major improvements in the Forms side of .NET.

https://devblogs.microsoft.com/dotnet/whats-new-in-windows-forms-in-net-6-0/


I haven't done a forms based app for others in decades but you guys and
possibly gals still do.  Here is a code base that keeps getting
improvements and or updates and will allow you to write for linux or mac as
well.


-- 
Stephen Russell
Sr. Analyst
Ring Container Technology
Oakland TN

901.246-0159 cell


--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

___
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 message: 
https://leafe.com/archives/byMID/cajidmylxawjy1o1jzcs+q83rgp5lx6kqudv1fawwwcgzbxu...@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.

[NF] you are...

[Stephen Russell]

He: You are the ';' to my code. She: I code in Python.



-- 
Stephen Russell
Sr. Analyst
Ring Container Technology
Oakland TN

901.246-0159 cell


--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

___
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 message: 
https://leafe.com/archives/byMID/cajidmyl2oyoep4cy-+oyotyiky1hg6rjro4plodbdh550d0...@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.

[NF] Want to hear what .NET 6 has?

[Stephen Russell]

Marcus Egger gives another talk on what M$ is releasing next month.

Mobile, cloud, web. desktop, IOT, and more.

CODE Video - (codemag.com) <https://www.codemag.com/Videos/Play/99HmIyxlXsw>


-- 
Stephen Russell
Sr. Analyst
Ring Container Technology
Oakland TN

901.246-0159 cell


--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

___
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 message: 
https://leafe.com/archives/byMID/cajidmylinct8162q0aduekcwilw5rxcw1vsio929hp7662d...@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.

[NF] ML & Python anyone?

[Stephen Russell]

Good intro into ML using python as your code base.

https://www.makeuseof.com/machine-learning-project-ideas-for-beginners/


-- 
Stephen Russell
Sr. Analyst
Ring Container Technology
Oakland TN

901.246-0159 cell


--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

___
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 message: 
https://leafe.com/archives/byMID/cajidmylrjrftmo1o9wvekbmhacvvkk-+mm17cv5cnisoyjz...@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: Retire the CSV?

[Stephen Russell]

Richard, we have upped our standards.  Now up yours.

Bad Stephen

On Tue, Aug 24, 2021 at 2:38 PM Richard Kaye  wrote:

> And see my last thread about the CSV "standard" a few months ago. There
> are regional formats for CSVs.
>
> --
>
> rk
>
> -Original Message-
> From: ProfoxTech  On Behalf Of Stephen
> Russell
> Sent: Tuesday, August 24, 2021 3:35 PM
> To: profoxt...@leafe.com
> Subject: Re: Retire the CSV?
>
> Till users put in commas because they are needed Last name, first name.
> Or commas in dollar amounts.  Yeah those are some of my joys.
>
> On Tue, Aug 24, 2021 at 3:46 AM  wrote:
>
> > You wont get rid of the CSV anytime soon. It reminds me of the
> > University Professor who declared that email was old-hat and 'dead'
> > and so sent out the schedule for lectures on social media. Half of the
> > students didn’t arrive because they didn’t get it.
> >
> > If it aint broke, don’t fix it. And CSV, for all its limitations, aint
> > broke.
> >
> > -Original Message-
> > From: ProFox  On Behalf Of Dave Crozier
> > Sent: Tuesday, 24 August 2021 5:58 PM
> > To: ProFox Email List 
> > Subject: RE: Retire the CSV?
> >
> > However, if the data is stable and never changes in format then using
> > CSV is perfectly acceptable as well as quick.
> >
> > I must admit I have never liked using double quotes or single quotes
> > as terminating characters for strings and prefer to use the pipe
> > symbol | as a prefix/suffix for strings as it should never be present
> > in operator generated data.
> >
> > As they say, if it ain't broken then don't fix it  but if it
> > has never worked then generate a better solution in the first place!
> >
> > Dave Crozier
> > Software Development Manager
> > Flexipol Packaging Ltd.
> >
> > Mob: 07967 671080
> >
> > ﴾⚆ᨎ⚆﴿
> >
> >
> >
> > Flexipol® Packaging Ltd
> > T 01706 222 792
> > E dcroz...@flexipol.co.uk
> > W https://www.flexipol.co.uk/
> > Follow us:
> > Unit 14 Bentwood Road, Carrs Industrial Estate, Haslingden,
> > Lancashire,
> > BB4 5HH
> >
> > ​This communication and the information it contains is intended for
> > the person or organisation to whom it is addressed. Its contents are
> > confidential and may be protected in law. If you have received this
> > e-mail in error you must not copy, distribute or take any action in
> > reliance on it. 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.
> >
> > Flexipol Packaging Ltd. has taken every reasonable precaution to
> > minimise the risk of virus transmission through email and therefore
> > any files sent via e-mail will have been checked for known viruses.
> > However, you are advised to run your own virus check before opening
> > any attachments received as Flexipol Packaging Ltd will not in any
> > event accept any liability whatsoever once an e-mail and/or any
> attachment is received.
> >
> >  It is the responsibility of the recipient to ensure that they have
> > adequate virus protection.
> >
> >
> > --
> > --
> > --
> > --
> > -
> > ​​
> > ​Terms & Conditions:
> >  Notwithstanding delivery and the passing of risk in the goods, the
> > property in the goods shall not pass to the buyer until the seller
> > Flexipol Packaging Ltd. ("The Company") has received in cash or
> > cleared funds payment in full of the price of the goods and all other
> > goods agreed to be sold by the seller to the buyer for which payment
> > is then due. Until such time as the property in the goods passes to
> > the buyer, the buyer shall hold the goods as the seller's fiduciary
> > agent and bailee and keep the goods separate from those of the buyer
> > and third parties and properly stored protected and insured and
> > identified as the seller's property but shall be entitled to resell or
> use the goods in the ordinary course of its business.
> > Until such time as the property in the goods passes to the buyer the
> > seller shall be entitled at any time -Original Message--

Re: Retire the CSV?

[Stephen Russell]

Till users put in commas because they are needed Last name, first name.  Or
commas in dollar amounts.  Yeah those are some of my joys.

On Tue, Aug 24, 2021 at 3:46 AM  wrote:

> You wont get rid of the CSV anytime soon. It reminds me of the University
> Professor who declared that email was old-hat and 'dead' and so sent out
> the schedule for lectures on social media. Half of the students didn’t
> arrive because they didn’t get it.
>
> If it aint broke, don’t fix it. And CSV, for all its limitations, aint
> broke.
>
> -Original Message-
> From: ProFox  On Behalf Of Dave Crozier
> Sent: Tuesday, 24 August 2021 5:58 PM
> To: ProFox Email List 
> Subject: RE: Retire the CSV?
>
> However, if the data is stable and never changes in format then using CSV
> is perfectly acceptable as well as quick.
>
> I must admit I have never liked using double quotes or single quotes as
> terminating characters for strings and prefer to use the pipe symbol | as a
> prefix/suffix for strings as it should never be present in operator
> generated data.
>
> As they say, if it ain't broken then don't fix it  but if it has
> never worked then generate a better solution in the first place!
>
> Dave Crozier
> Software Development Manager
> Flexipol Packaging Ltd.
>
> Mob: 07967 671080
>
> ﴾⚆ᨎ⚆﴿
>
>
>
> Flexipol® Packaging Ltd
> T 01706 222 792
> E dcroz...@flexipol.co.uk
> W https://www.flexipol.co.uk/
> Follow us:
> Unit 14 Bentwood Road, Carrs Industrial Estate, Haslingden, Lancashire,
> BB4 5HH
>
> ​This communication and the information it contains is intended for the
> person or organisation to whom it is addressed. Its contents are
> confidential and may be protected in law. If you have received this e-mail
> in error you must not copy, distribute or take any action in reliance on
> it. 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.
>
> Flexipol Packaging Ltd. has taken every reasonable precaution to minimise
> the risk of virus transmission through email and therefore any files sent
> via e-mail will have been checked for known viruses. However, you are
> advised to run your own virus check before opening any attachments received
> as Flexipol Packaging Ltd will not in any event accept any liability
> whatsoever once an e-mail and/or any attachment is received.
>
>  It is the responsibility of the recipient to ensure that they have
> adequate virus protection.
>
>
> -
> ​​
> ​Terms & Conditions:
>  Notwithstanding delivery and the passing of risk in the goods, the
> property in the goods shall not pass to the buyer until the seller Flexipol
> Packaging Ltd. ("The Company") has received in cash or cleared funds
> payment in full of the price of the goods and all other goods agreed to be
> sold by the seller to the buyer for which payment is then due. Until such
> time as the property in the goods passes to the buyer, the buyer shall hold
> the goods as the seller's fiduciary agent and bailee and keep the goods
> separate from those of the buyer and third parties and properly stored
> protected and insured and identified as the seller's property but shall be
> entitled to resell or use the goods in the ordinary course of its business.
> Until such time as the property in the goods passes to the buyer the seller
> shall be entitled at any time -Original Message-
> From: ProFox  On Behalf Of Eric Selje
> Sent: 23 August 2021 15:30
> To: ProFox Email List 
> Subject: Re: Retire the CSV?
>
> He's right. And it won't happen.
>
> On Mon, Aug 23, 2021 at 8:43 AM Garrett Fitzgerald <
> sarekofvul...@gmail.com>
> wrote:
>
> > Rght
> >
> > On Mon, Aug 23, 2021 at 9:25 AM Stephen Russell
> > 
> > wrote:
> >
> > > https://www.bitsondisk.com/writing/2021/retire-the-csv/
> > >
> > > It's so simple they say.
> > >
> > > --
> > > Stephen Russell
> > > Sr. Analyst
> > > Ring Container Technology
> > > Oakland TN
> > >
> > > 901.246-0159 cell
> > >
> > >
> > > --- StripMime Report -- processed MIME parts ---
> > > multipart/alternative
> > >   text/plain (text body -- kept)
> > >

Re: SweetPotatosoftware.com

[Stephen Russell]

I like the logo that looks to have the cd drive sticking it's tongue out at
you.

On Tue, Aug 24, 2021 at 9:34 AM Ted Roche  wrote:

> On Tue, Aug 24, 2021 at 8:31 AM Vince Teachout  wrote:
>
> > Went right in, no problem.  It looks nice. I wonder if he updated it?
> >
>
> It looked different in 2016:
>
>
> https://web.archive.org/web/20160315105936/http://www.sweetpotatosoftware.com/home.htm
>
> >
> >
>
>
> --- 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: 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 message: 
https://leafe.com/archives/byMID/cajidmylvsjaanb8x2nrx_gks8yvw3l4gajefr6ive6r2zk1...@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.

Retire the CSV?

[Stephen Russell]

https://www.bitsondisk.com/writing/2021/retire-the-csv/

It's so simple they say.

-- 
Stephen Russell
Sr. Analyst
Ring Container Technology
Oakland TN

901.246-0159 cell


--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

___
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 message: 
https://leafe.com/archives/byMID/CAJidMY+JwxF8DZZM4j2Fm1nM9EYNztHnnKAV=yvbksxca5h...@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: [NF] Winforms

[Stephen Russell]

That text goes into the details of how I said to do it.  Thus I agree that
it can be done and re-used.

Now the Q I have is WHY?  If you have branded UI button styles?   What else
are you extracting to re-use with your enhancements on time and again?
Create the control library project

Define a custom control and its custom designer in C#/VB

Get your using
using System;
using System.Collections;
using System.ComponentModel;
using System.ComponentModel.Design;
using System.Diagnostics;
using System.Drawing.Design;
using System.Windows.Forms;
using System.Windows.Forms.Design;

Start coding off of it inherriting from a class
 public class MarqueeControlRootDesigner : DocumentDesigner

Due to all of this work I wouldn't do every control out there myself.

You can do the same thing in the Web space as windows forms so tOmato
tomAto.

20 years ago the idea of subclassing every little thing was novel.  Today I
just don't have the time to do that because it isn't worth it.

Another good idea is buying all of that dond for you via the various tool
companies that support .NET. This is outdated
https://visualstudiomagazine.com/articles/2015/09/01/9-top-net-ui-component-collections.aspx
but most of those companies are still doing what they do so well.



On Fri, Aug 20, 2021 at 6:01 AM Alan Bourke  wrote:

> On Wed, 18 Aug 2021, at 5:34 PM, Graham Brown wrote:
>
> > What am I missing?
>
> You're not missing anything. Visual inheritance in the Windows Forms
> designer does not work like VFP, Delphi or whatever. It didn't in 2002,
> and on inspection still doesn't now.
>
> This is how you do it with a UserControl.
>
>
> https://docs.microsoft.com/en-us/dotnet/desktop/winforms/controls/creating-a-wf-control-design-time-features?view=netframeworkdesktop-4.8
>
>
> --
>   Alan Bourke
>   alanpbourke (at) fastmail (dot) fm
>
[excessive quoting removed by server]

___
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 message: 
https://leafe.com/archives/byMID/cajidmylby-5u1xouoze-3hkfexpexmtqvsj7zyy1dmrxugw...@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: [NF] Winforms

[Stephen Russell]

You could create a project where you subclassed any form widget in your way.

Then in every new solution, you include that project and use those classes
at the top instead of:
using  System.Windows.Forms.Form

you would use :
using  MyUberCoolSystem.Windows.Forms.Form

Just like you had to do in VFP as I remember.

I would never do that again, personally.  If I need to override something
I'd do it in just this application, and not everything I did.  Extending
the functionality of classes is easy as needed.  In all of my data objects,
I override the ToString() to output a serialized json string of the data.



On Wed, Aug 18, 2021 at 7:04 AM Alan Bourke  wrote:

> It's been many years since I used WinForms but if I remember visual
> inheritance and WinForms designer support in Visual Studio don't work the
> same as you would be used to from VFP or VB6. Basically you have to
> programmatically add designer support, or as you say programmatically
> update any control properties you want to change.
>
> WPF and its successors are much better in this regard.
>
>
[excessive quoting removed by server]

___
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 message: 
https://leafe.com/archives/byMID/CAJidMYKx5Jcg10x=r4RiER1+tVVbMTBTF=td32vDCd6_=-r...@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.

Just heard the new verbage concerning Insert/Update

[Stephen Russell]

The method is UpSert

Your database has an object, stored procedure in SQLServer case, that
receives all the parameters for a single row of data for that table.

The first thing you do is attempt an update of that row.  If nothing is
updated you then do an insert of those same params.

I have been doing this practice for 1-2 years now and just heard the catchy
name for it.

I will also throw back the ID for the new record as an output param.



-- 
Stephen Russell
Sr. Analyst
Ring Container Technology
Oakland TN

901.246-0159 cell


--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

___
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 message: 
https://leafe.com/archives/byMID/cajidmyj-7ggyptcmz_3f_w-5b5qjxvht2hertngi2r22hab...@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.

Do you want to hear more about Win 11?

[Stephen Russell]

Put on by Code Magazine.Webinar: State of .NET - Windows 11 for Developers

*Date:* July 28, 2021 - Wednesday

*Time:* 1:00 PM Eastern Time (ET) / 12:00 PM Central Time (CT)

Find Your Local Time
<http://url7522.codemag.com/ls/click?upn=xfZQWdEXOwj5-2BpT2uVrc-2B15CHvD8v-2BrNr4qBbSBhH6T6Md7UE8gK9kgcY-2BQoQtDeR99Oj-2B-2BtFQNtfY0Gj7Ymw1L-2BHd9rU5b9iWpqvgmpH58-3Dx_Ra_lTq8dHXwfrTa-2Fti45-2F0nOhtleWtgznCG-2FgPcBUwLCkQe2j-2BayczJMDRC-2FUvEuAH8aBf9C6x0HnTFiTJBDhKrtkzlsxcC3LenAa666whRhOMG7DclGLHQ7r2bBHtEa9SufIRAA-2B8Q2q2eOQn0Si8AuDppRv3E53Ud3tgTbz-2FbmaBrQPVKrheAcrLtJlze85YnYZTMvbWtO-2BdVRTC8PyWHBdPvHmBBLJwE7xIOGIunyUI6z8qDvGHkXDLWvYxs7nEudwGQy0bACD6wEJbXHeN763Fpr1BOxZS3cC2dE0XQwcI-3D>

Click Here Download a Outlook Calendar File
<http://url7522.codemag.com/ls/click?upn=xfZQWdEXOwj5-2BpT2uVrc-2B1p500nk-2FFqgfZff0cWUmjcezfrz-2FUKiMxKwxTUqz6rGDCvgWrQ7cHLCT5y-2FFmoRuinxWGyflKMuKOyjhfutWL2-2BbYKJKf6qJTwr7YcFSne2pkZ3_lTq8dHXwfrTa-2Fti45-2F0nOhtleWtgznCG-2FgPcBUwLCkQe2j-2BayczJMDRC-2FUvEuAH8aBf9C6x0HnTFiTJBDhKrttlU33mjY5gTQz7q0U4XikyJ3QZZkWeLGGEgzta39aY2kPlNhHXKrYNFfESguqk2QbT9b0dHuIGQuCbiPQOt5DkG-2BUQbxeDIORMQ1KI4M85tO9QhAiJuHpt9krtUvUWEiSJ57ritpyelHJGyJ-2FO-2BYYg3JN3eL8X-2FZVwnpUsv6Z6eCub0QebZaGZ-2BXqOhzi1ZfXiKWN4jlJWdzrPWqndiTTY-3D>

-- 
Stephen Russell
Sr. Analyst
Ring Container Technology
Oakland TN

901.246-0159 cell


--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

___
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 message: 
https://leafe.com/archives/byMID/cajidmyjh7_5vvlvvb1r1_ih0eiwzwjsn2mal6ds-iedrwgt...@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: Windows 11???

[Stephen Russell]

Or port to Angualr, React, Vue, etc.

All of that potential porting revenue you have missed out on.

On Mon, Jun 28, 2021 at 9:05 AM MB Software Solutions, LLC <
mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote:

> Hmmm...I thought Windows 10 was the last OS!  Does this mean we have the
> anxiety yet again of "will our VFP apps work in Win" ???
>
> --
> Michael J. Babcock, MCP
> Fox/VFP dev since 1997
> Developer of FabNet estimating software - mbsoftwaresolutions.com
>
>
[excessive quoting removed by server]

___
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 message: 
https://leafe.com/archives/byMID/cajidmy+ivawulcdxr5jpwzhuprnn01bwvz_lqksqs-ht932...@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.

[NF] Python and where it is going.

[Stephen Russell]

If you are questioning python in your future.

https://www.pluralsight.com/resource-center/webinars/webinar---the-future-of-python/thank-you
-- 
Stephen Russell
Sr. Analyst
Ring Container Technology
Oakland TN

901.246-0159 cell


--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

___
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 message: 
https://leafe.com/archives/byMID/CAJidMYJXhJLSqDsScWxfEWOR-_EUCBWEos=vdlqfjkdbsfm...@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: [NF] VS 2022 will be 64 bit they say.

[Stephen Russell]

The brand image for Save is in need of an overhaul.
https://www.iconfinder.com/search/?q=save%20image

Does anyone under 25 know what a floppy disk was?

On Mon, Apr 19, 2021 at 12:04 PM Ed Leafe  wrote:

> On Apr 19, 2021, at 11:31, Stephen Russell  wrote:
> >
> > Also included are refreshed icons!  
>
> I like how they “refreshed” the save icon by turning the floppy disk
> upside-down! Now that’s super-fresh in 2022!
>
> -- Ed Leafe
>
>
>
>
>
>
>
[excessive quoting removed by server]

___
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 message: 
https://leafe.com/archives/byMID/CAJidMYJKjyyxM5CPzbhJ6VFOE=-nsy3s_kzynfuduyryfht...@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.

[NF] VS 2022 will be 64 bit they say.

[Stephen Russell]

https://devblogs.microsoft.com/visualstudio/visual-studio-2022/

Also included are refreshed icons!  


-- 
Stephen Russell
Sr. Analyst
Ring Container Technology
Oakland TN

901.246-0159 cell


--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

___
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 message: 
https://leafe.com/archives/byMID/cajidmylbz+9d1k9e-5a7l+0-5onmkveuc0+1bmrk9rz4x9k...@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: Variations in CSV settings by region

[Stephen Russell]

I'd take the CSV file and save it as XML.  Then rip from there.

Not sure if there is a json reader/writer for VFP yet.

if you look to sql server you could import the data through the IMPORT
wizard as well.  You tell it the delimiters etc per file.

On Fri, Apr 16, 2021 at 8:42 AM Richard Kaye  wrote:

> Throwing this one out to the collective wisdom. We're doing a lot with CSV
> import/experts these days with our web-based WWC application and are
> running into issues with regionalization. Here in the US, a "standard" CSV
> means commas between data elements and double quotes around text elements.
> But in Belgium, the delimiter is the semi-colon and text elements are not
> wrapped in double quotes. As best I can tell, Excel determines what format
> to use by the OS settings and not its own application settings. This makes
> importing from a CSV a bit of a dance for our Belgian clients as they have
> to change their regional settings, import the file that was received in US
> format, and then change their settings back. And, of course, changing
> region affects date and currency formats. For those of you working with
> clients from multiple locations where the standards may be different, what
> strategies do you use to deal with this?
>
> TIA
>
> --
>
> rk
>
>
>
> --- 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: 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 message: 
https://leafe.com/archives/byMID/CAJidMYJGvsup_znY_zeQTb=RAkEgeRQ2kBqg8zvrL=i_hww...@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: [NF] Desktop Development in the roaring 20s

[Stephen Russell]

Richer is word that can be used in two different ways.  The pure speed of
input of a document is negligible between the two environments.

Identification of data that is pertinent to the overall transaction, that
being can we make the customer buy more.  Amazon nails that with images of
items that you have looked at before but not purchased.  Can a desktop do
that?  Opening up multiple tabs to present more data to the user.  Order
history of customer or payments of customer and aging?

After working in the web space as well as a few older desktop apps, the
desktop has been a crap fest in functionality or the graphics of buttons is
so outdated, compared to what is crisp and clean on the web.



On Mon, Mar 29, 2021 at 9:49 PM MB Software Solutions, LLC <
mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote:

> It used to be that you could get a much richer user experience in a
> desktop app compared to a web app for many head-down data entry kinds of
> apps.  Is that still true to the most extent?
>
>
> On 3/29/2021 10:32 AM, Stephen Russell wrote:
> > Most of the group will remember Robert Green.
> >
> >
> https://channel9.msdn.com/Shows/Visual-Studio-Toolbox/Choices-in-Desktop-Development
> >
> >
> > An easy quick session that explains various opportunities available
> today.
> > The statement Apps are Apps is so true.
> >
> >
>
> --
> 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: 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 message: 
https://leafe.com/archives/byMID/cajidmy+yd1sxovozqatllgugpvrvfcpk0upjpb45b3edjgb...@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.

[NF] Desktop Development in the roaring 20s

[Stephen Russell]

Most of the group will remember Robert Green.

https://channel9.msdn.com/Shows/Visual-Studio-Toolbox/Choices-in-Desktop-Development


An easy quick session that explains various opportunities available today.
The statement Apps are Apps is so true.


-- 
Stephen Russell
Sr. Analyst
Ring Container Technology
Oakland TN

901.246-0159 cell


--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

___
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 message: 
https://leafe.com/archives/byMID/CAJidMYLMBAo=AFsO=8sz7vjiv4gkpcakwg7jaunnct4pn_e...@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.

Fwd: Webinar: Windows Desktop Development With .NET 5 - with Markus Egger - Wed 2/24 at 1:00 EST

[Stephen Russell]

For all of you doing desktop environments, .NET 5 looked back at that space
made improvements.  You may remember Marcus from his FP days.

-- Forwarded message -
From: CODE Magazine & Training 
Date: Fri, Feb 12, 2021 at 6:44 PM
Subject: Webinar: Windows Desktop Development With .NET 5 - with Markus
Egger - Wed 2/24 at 1:00 EST
To: Stephen Russell Ring Container Technology 


Join Us Wednesday, February 24 @ 1:00pm EST

Dear Stephen,

Save Wednesday, February 24th @ 1:00pm Eastern / 12:00pm Central / 10:00am
Pacific for our next CODE Magazine State of .NET webinar, “Windows Desktop
Development in .NET 5”. Join Markus Egger (President & Chief Software
Architect of EPS Software / CODE Consulting and Microsoft Regional
Director) as he reviews the options available for building Windows desktop
applications with .NET 5.

Markus will answer as many of your questions as possible. We're trying to
help educate as many developers as possible so please share this info with
your developer friends. Thanks!

Do you build or maintain Windows deskop applications? Tell us about it at
i...@codemag.com

.
State of .NET - Windows Desktop Development in .NET 5



*February 24, 2021 - Wednesday Start time: 1:00pm Eastern / 12:00pm Central
Duration: 75 minutes (60 minute presentation, 15 minute Q&A)*

We've created a series of State of .NET online events each focusing on a
specific .NET topic. This installment covers *Windows Desktop Development
With .NET 5*. While topics such as Blazor or Azure may be getting a lot
more attention, Windows Desktop development is still a very important
topic. Not just that, but with technologies such as WinUI, MAUI, and
others, there is a lot of movement in this segment of .NET development.
Join Markus Egger to take a close look at what you need to know to make the
right decisions for your path forward.

Topics covered in this event include:

   - WinForms - in .NET 4.x and .NET 5
   - Windows Presentation Foundation (WPF) - in .NET 4.x and .NET 5
   - Xamarin Forms and MAUI
   - WinUI and Fluid UI
   - Electron and Photino
   - and more…

*Note*: Only registered attendees will receive the live stream URL the
morning of the event via email.

Click here
<https://u14306485.ct.sendgrid.net/ls/click?upn=-2FlhZWJjobIdHG3rVYRj6ZASEtcOmhYHrZaHKd9UYbsXzglJERteDwd9yZeee9ME9PM6Rw2V1gNNtz190DBZMPvimulGvf1NaOdfifSUP7u0eAyvYr6mAVTWw2qaE0UyGmkiD_6MNhH-2F9xC4B4dmryIkr-2BKfBAvtS41u-2BD3PfFZMqGl3udO-2Fb19-2B5005eaGLD-2B18vU9zdQGFvPll54Asj-2FSBHEjVwFu3izD35qeckcmPiyLPcy2F3ef8ZfMy20NSZNZTfY5qgXt-2FIBbcQQmV7loRb0jV5KM3kjBd-2Be4MnybJ3f26EOEGRmAW2jyY8-2F7rIWgMijPRHiuKpxHMMK7bAtelQVNC6mIFh0oJ8VnSOVY93vhol1RPmWarsKGdhek0o9O0d34q-2FxBtewEtx1YA71efcYkmgzZyCudJ0k7PHD7O8Kz0I-3D>
for more information about this webinar.

*Click Here to Register for FREE!
<https://u14306485.ct.sendgrid.net/ls/click?upn=-2FlhZWJjobIdHG3rVYRj6ZHvtoiGCsxBe6GWqxUAIrhAzZXCTHUa0zwIsXWlKgqfu6GC9CDwaMJgw96x0w5MRh20YA6e7q-2BwvNXtZ1kNpaEY-3D3P2u_6MNhH-2F9xC4B4dmryIkr-2BKfBAvtS41u-2BD3PfFZMqGl3udO-2Fb19-2B5005eaGLD-2B18vUZk0TXfo95CI8bCWPeuSDGz0rvICRkue5pYn9AZ0lwMgtlIChgTMh8OmWxw4XSRmOkgagdsQC5BGsOPnAWEWo8mH7b7PRIWIzQJJVvXwzarwLeHmGnjOe7-2FEAUN-2BRnsYnonM5ovTRsIZgboxsdki6op2jdGtDc-2B5Ib8ZDK-2BFwrmIaIvWDEwE7KRG4F3uoINjCM1StHDvVX3PwemIiV0fPVCCpym93OuZtyt1Q488q8Ss-3D>*

Free CODE Magazine Content

As a Coronavirus special, we have been making ALL our magazine content
available for free through our new Mobile apps. To install those mobile
apps, go to https://codemag.com/mobile
<https://u14306485.ct.sendgrid.net/ls/click?upn=-2FlhZWJjobIdHG3rVYRj6ZPs4kc5kkcgAzcpJGGpxfln-2FP-2BjMVmswDq9yaHYhPJWMoQrm_6MNhH-2F9xC4B4dmryIkr-2BKfBAvtS41u-2BD3PfFZMqGl3udO-2Fb19-2B5005eaGLD-2B18vUv0SagQ1z1054AyKG-2BYpzWTJw9kC4MvTFh3adizfi1jK22-2BxisSv5DlCdaWLkbMnwh-2By5tjhKhXUIfZyap-2Fvt5e9OdUruEdt2J2dV6XixfZGgkAOOCQzQ6P4fFAA8COfuIglbpajbl5giEIZ7JnjOoKVog-2Bp3tFa7RpKsZ3pMO1qrtIYWQlOAjQIP3QgWx9cAN1msCV7p9FG8ZyctsIhEFIlTb9NVrS9D21gLimSuREQ-3D>
.

Access to the FREE content requires a CODE Magazine subscription. New
subscribers can sign up for a FREE subscription at
https://codemag.com/subscribe/corona
<https://u14306485.ct.sendgrid.net/ls/click?upn=-2FlhZWJjobIdHG3rVYRj6ZJVOMala7Lb8FuYCFA5osUHZfHJGHAGZ-2F5b443UbqtTU5Ifp_6MNhH-2F9xC4B4dmryIkr-2BKfBAvtS41u-2BD3PfFZMqGl3udO-2Fb19-2B5005eaGLD-2B18vU5g-2FnxzvgmGlFgxg0VKaOB3Heh91RXgMo-2FuF9oHD9TtGig6HpaL4ATaVyYYT1U7xWVPDaDiqvpT-2FfANi8r66DSOVcDntCpDToqi7-2FVDb7cu0Fqueph-2FNbC6-2Fc0dV4olsoH86ZJhzxvf7A4Dxyp5uEUVBQhl6hVqI-2FhXCE4MG276ZgWduq-2FEnzrhOzW-2FLfx4O0lQKqSLROOIh699sysSz1vqiSvccbY58tKPGlJ5WplY8-3D>.
Please pass this free subscription offer on to friends, colleagues, social
media followers, enemies, your archnemesis and anyone else you think would
benefit from reading about various software development topics for free.
Why we are sending you this notification

You are getting this email notification, because our database shows you as
having opted in for notifications of t

Re: sql server connection

[Stephen Russell]

Here is a powershell script example that will install the client on your
workstation(s).

https://www.server-world.info/en/note?os=Windows_Server_2019&p=mssql2019&f=4


I would skip ODBC at all costs and just use the client directly.

On Thu, Feb 11, 2021 at 8:17 AM Eric Selje  wrote:

> Rafael,
>
> They'll have to have the driver installed in order to talk to SQL Server.
> The best way is to provide them with an Installer program (use InnoSetup -
> free and easy) that installs your app as well as the driver. It can add a
> DSN too, although you may want to consider hardcoding that connection
> string into your EXE so the password isn't visible. Hopefully they're using
> a SQL account with the minimal privileges needed.
>
> I hope this helps,
>
> Eric
>
>
> On Thu, Feb 11, 2021 at 6:50 AM Rafael Copquin 
> wrote:
>
> > I have a VFP) app that uses MS sqlserver as backend. The SQL Server is
> > located in a web provider
> >
> > The connection is achieved by creating a DSN throught the ODBC driver in
> my
> > PC
> >
> > I need to deploy this app to several clients. But none of them should use
> > their ODBC driver to create the connection, or install the applicable SQL
> > Server Native Client in their PC.
> >
> > The idea is that I would send them my VFP application exe and they would
> > simply connect to the cloud SQL Server and run the app without any
> further
> > operations to install the exe.
> >
> > I tried SQLConnect and SQLStringConnect, but they always refer to an
> > existing DSN
> >
> > Is there a way to accomplish this without my clients intervention other
> > than lodging the exe in the applicable directory in their PC's ??
> >
> > Please advise and if possible, provide an example on how to do this
> >
> > TIA
> >
> > Rafael Copquin
> >
> >
> > --- 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: 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 message: 
https://leafe.com/archives/byMID/CAJidMY+nWmxe0jry-W-WGHp=zkxxwse5nt-brzmj0jys1ab...@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: Automation & Office 365

[Stephen Russell]

I saw this:
https://support.microsoft.com/en-us/office/choose-between-the-64-bit-or-32-bit-version-of-office-2dee7807-8f95-4d0c-b5fe-6c6f49b8d261

It lists the reason why you would choose 64/32 bit versions.  I had to use
this when we got newer Office and older SharePoint stuff no longer worked
the same way.  Editing in a data sheet instead of the list in SP.





On Fri, Jan 15, 2021 at 9:05 AM Richard Kaye  wrote:

> Yes. But installing the full 32 bit desktop version is a requirement.
> Works fine for Word, Excel  and Outlook.
>
> --
>
> rk
>
> -Original Message-
> From: ProfoxTech  On Behalf Of Frank Cazabon
> Sent: Friday, January 15, 2021 9:59 AM
> To: profoxt...@leafe.com
> Subject: Re: Automation & Office 365
>
> Thanks, have you got it working?
>
> I've asked them to uninstall the 64bit and try with the 32bit. Will report
> back what happens.
>
> Frank.
>
> Frank Cazabon
>
> On 15/01/2021 10:53 am, Alan Bourke wrote:
> > There's no reason why it wouldn't still work as long as you are using
> 32-bit Office. It's not the version, it's the bitness.
> >
> > 365 installs the 64-bit version of the applications by default now,
> which is annoying if you have Excel plugins, for example, or need to
> automate them from a 32-bit process.
> >
>
>
[excessive quoting removed by server]

___
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 message: 
https://leafe.com/archives/byMID/cajidmy+ppuqnwf5kd0ygujo4a0uowp_7hy2qmrtsbvny8t0...@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: MDI window theme github issue

[Stephen Russell]

Awesome.

I don't do DevOps as of yet.Getting a lot of our data accessible via
API for different applications as our ERP will move to the cloud.  That and
catching messages from a message queue and acting upon them.

On Fri, Dec 4, 2020 at 5:34 PM Tracy Pearson  wrote:

> I'm a DevOps minimalist. I work on projects that web interfaces, desktop
> interfaces, run as services, access MSSQL, access DBFs, work with COM
> objects, host ActiveX controls, are the ActiveX control, are the COM
> object,
> and I maintain the build process for the projects.
>
> These days I write as much C# code as I do VFP code, and some VBScripting
> for the build server.
>
> I finally got FoxUnit setup and working with one of my projects. I should
> have started TDD years ago.
>
> Lessons are a reminder that we are always needing to be taught something so
> we may teach others.
>
> -Original Message-
> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
> Stephen
> Russell
> Sent: Friday, December 04, 2020 4:19 PM
> To: profoxt...@leafe.com
> Subject: Re: MDI window theme github issue
>
> It has been decades since I have done forms-based apps.  Now it seems to be
> API and or workflows in a variety of different host systems.
>
> On Thu, Dec 3, 2020 at 1:34 PM Tracy Pearson 
> wrote:
>
> > The file picker has never been an Child window in a Multi Document
> > Interface
> > (MDI)
> > So, some of the old look has been addressed.
> >
> > The child windows in .NET Core WinForms MDI still have the old Windows 7
> > border.
> > This is because the problem is in the Windows code.
> >
> > -Original Message-
> > From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
> > Stephen
> > Russell
> > Sent: Thursday, December 03, 2020 1:02 PM
> > To: profoxt...@leafe.com
> > Subject: Re: MDI window theme github issue
> >
> > .NET 5 addressed this issue and brings modern visuals into a Win Forms
> > app.  That file picker looked like it was from Win95 days.  It is
> supposed
> > to now pull in the current version of Windows going forward.   This was
> per
> > Marcus Edger in a Code magazine video on .NET 5 about 2 weeks ago.
> >
> > On Thu, Dec 3, 2020 at 10:51 AM Tracy Pearson 
> > wrote:
> >
> > > Hello everyone,
> > >
> > > My coworker found this and shared it with me today.
> > > I have tested to see VFP apps correctly show the MDI form with a theme
> in
> > > Windows Server 2012.
> > > If you have a github account and would like to vote this up. I say
> thank
> > > you!
> > >
> > > https://github.com/dotnet/winforms/issues/3691
> > >
> > > It's not just a Winforms issue, it's a Windows base code issue.
> > > I hope it gets fixed.
> > >
> > > Have a good one!
> > > Tracy
> > >
> > >
[excessive quoting removed by server]

___
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 message: 
https://leafe.com/archives/byMID/CAJidMYLo+VcFHzO88LqkH8_XW1B=xnmhpldckev1vaz07ph...@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: MDI window theme github issue

[Stephen Russell]

It has been decades since I have done forms-based apps.  Now it seems to be
API and or workflows in a variety of different host systems.

On Thu, Dec 3, 2020 at 1:34 PM Tracy Pearson  wrote:

> The file picker has never been an Child window in a Multi Document
> Interface
> (MDI)
> So, some of the old look has been addressed.
>
> The child windows in .NET Core WinForms MDI still have the old Windows 7
> border.
> This is because the problem is in the Windows code.
>
> -Original Message-
> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
> Stephen
> Russell
> Sent: Thursday, December 03, 2020 1:02 PM
> To: profoxt...@leafe.com
> Subject: Re: MDI window theme github issue
>
> .NET 5 addressed this issue and brings modern visuals into a Win Forms
> app.  That file picker looked like it was from Win95 days.  It is supposed
> to now pull in the current version of Windows going forward.   This was per
> Marcus Edger in a Code magazine video on .NET 5 about 2 weeks ago.
>
> On Thu, Dec 3, 2020 at 10:51 AM Tracy Pearson 
> wrote:
>
> > Hello everyone,
> >
> > My coworker found this and shared it with me today.
> > I have tested to see VFP apps correctly show the MDI form with a theme in
> > Windows Server 2012.
> > If you have a github account and would like to vote this up. I say thank
> > you!
> >
> > https://github.com/dotnet/winforms/issues/3691
> >
> > It's not just a Winforms issue, it's a Windows base code issue.
> > I hope it gets fixed.
> >
> > Have a good one!
> > Tracy
> >
> >
[excessive quoting removed by server]

___
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 message: 
https://leafe.com/archives/byMID/cajidmyk4_fclxyuymh3hvbvp8b7oe_mbpno0ae-je6w0v6f...@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: SourceSafe from within Foxpro

[Stephen Russell]

>From SS you can do a file compare as well.  Allows you to see what the diff
is between the control and your workstation.

On Fri, Dec 4, 2020 at 12:31 AM Christof Wollenhaupt <
chris...@wollenhaupt.org> wrote:

> Hi Martin,
>
> > This works fine on a PC at the location of a client who I support, which
> > runs XP.  Also, on my own Windows 10 PC, VSS works perfectly from the VSS
> > application, but when I try to access it from VFP I get "database XXX
> does
> > not exist".
>
> Sometimes Microsoft's VirtualStore makes it look like a file is in a
> location, but when you access the same location with a different user or
> with an elevated application, then suddenly it's not there. The easiest way
> to check is using MODIFY FILE from VFP to see if VFP has actually the same
> content that you see from VSS. VirtualStore is located at
> %LOCALAPPDATA%\VirtualStore.
>
> If it turns out that everything is still OK, I would use Process Monitor
> as my next step to find out which file location VFP is looking at to find
> the VSS database and what error message Windows reports back. You can
> download Process Monitor from
> https://docs.microsoft.com/en-us/sysinternals/downloads/procmon <
> https://docs.microsoft.com/en-us/sysinternals/downloads/procmon>.
>
> --
> Christof
>
> --- 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: 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 message: 
https://leafe.com/archives/byMID/CAJidMYKZ5PfZVB7Y76cW5o=yiwqfsgfm5ctdxg-mgabky-r...@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: MDI window theme github issue

[Stephen Russell]

.NET 5 addressed this issue and brings modern visuals into a Win Forms
app.  That file picker looked like it was from Win95 days.  It is supposed
to now pull in the current version of Windows going forward.   This was per
Marcus Edger in a Code magazine video on .NET 5 about 2 weeks ago.

On Thu, Dec 3, 2020 at 10:51 AM Tracy Pearson  wrote:

> Hello everyone,
>
> My coworker found this and shared it with me today.
> I have tested to see VFP apps correctly show the MDI form with a theme in
> Windows Server 2012.
> If you have a github account and would like to vote this up. I say thank
> you!
>
> https://github.com/dotnet/winforms/issues/3691
>
> It's not just a Winforms issue, it's a Windows base code issue.
> I hope it gets fixed.
>
> Have a good one!
> Tracy
>
>
[excessive quoting removed by server]

___
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 message: 
https://leafe.com/archives/byMID/cajidmy+z0ipmxldm3ca_mibwqstcc2b87vslws2aszjjjrm...@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.

NF[ .net 5 conference]

[Stephen Russell]

https://www.dotnetconf.net/

I am surprised to see a few old FP names now very active in .NET groups.

They opened up with Forms apps and how many improvements have been made in
this newer version of .NET.  One of the most requested items was better
graphics for larger high-quality monitors.

-- 
Stephen Russell
Sr. Analyst
Ring Container Technology
Oakland TN

901.246-0159 cell


--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

___
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 message: 
https://leafe.com/archives/byMID/cajidmylp6qnhtunjzk_kxu-kyexbxqvewgwnjcgjycget6_...@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: Free Visual Foxpro

[Stephen Russell]

VS is free to use and for a solo shop make money with.  There are more
features in the paid-for versions and those all tie to working in teams
groups etc.

For all of the Mac and Linx folk there is a VS Code app that is a very lean
VS for creating code in but it will powershell/script the heck out anything
you need to do.

It might be a good idea to look into this now as .NET 5 is releasing today
and there is a huge 3 day presentation of it from M$.

Marcus Edgar did a good preview of .NET 5 a few weeks ago.

On Mon, Nov 9, 2020 at 9:17 PM MB Software Solutions, LLC <
mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote:

> Hi Charles,
>
> I don't think M$ gives any of it away for free, even older versions of
> their software??  Oh wait...they do give away some DotNet Studio
> versions, don't they?  Sorry...I know that doesn't help you with the Fox
> need.
>
> Hope the others tips help.
>
> --Mike
>
>
> On 11/6/2020 10:46 AM, Charles Hart Enzer, M.D. wrote:
> > Thank you, each of you
> >
> > How about free older versions of Visual Foxpro
> >
> > Shai / שי
> > Charles Hart Enzer, MD(Retired, USA), FAACAP
> >
> > Aliyah: Cincinnati to Jerusalem's German Colony May, 2017
> >
> >
> > Volunteer Associate Professor of Psychiatry
> > University of Cincinnati Medical Center
> > WebSite: http://www.enzermd.com
> >
> > Publications
> > http://www.enzermd.com/CV.html#Publications
> >
> > Danger of Choosing the Best:
> >
> > The Best may become an Enemy of the Good
> >
> > A Predictable Outcome of Great Evil
> >
> > Better to Seek the Least Determinal Alternative
> >
> >
> >
> >
> >
> >
> >
> >
> > On Fri, Nov 6, 2020, 2:45 PM Charles Hart Enzer, M.D. 
> > wrote:
> >
> >> I am leaving FPW26 because I have a new machine and no longer want to
> >> setup virtual XP
> >>
> >> What site has Visual Foxpro free
> >>
> >> Thank you
> >>
> >> --
> >>
> >>
> >> *Shai / שי **Charles Hart Enzer, MD(Retired, **Ohio**), FAACAP*
> >> *Aliyah : Cincinnati to Jerusalem
> >> 's German Colony
> >>  May 2017*
> >>
> >>
> >>
> >> *Volunteer Associate Professor of PsychiatryUniversity of Cincinnati
> >> Medical CenterWebSite: **EnzerMD.com *
> >> *Publications* 
> >>
> >> Danger of Choosing the Best:
> >> The Best may become an Enemy of the Good
> >> A Predictable Outcome of Great Evil
> >> Better to Choose the Least Detrimental Alternative
> >>
> >
> > --- 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: 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 message: 
https://leafe.com/archives/byMID/CAJidMYKY0yww8dszYd=offoffjsgnysfdxi+o7ddnykdvjs...@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: Record width

[Stephen Russell]

I hope you are the winner.

On Mon, Nov 2, 2020 at 6:25 PM MB Software Solutions, LLC <
mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote:

> I've got a client who's main data table for their orders is over 2300
> wide for record length.
>
> Anybody seen any wider in their travels?
>
>
>
> --
> 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: 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 message: 
https://leafe.com/archives/byMID/CAJidMYK6CDkWEvu10725NCG+BxSRg_noXyay0Wj4_o2Rp4n=h...@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: Do you have code in place for DST?

[Stephen Russell]

Got that right.  :)

This morning we had one server not getting updated in "time" and it was our
log in license service that was out of whack.  It failed to release users
from the weekend and when new peeps came in today it crapped out.  Oh I
love it when it is not any of my systems fault when stupid stuff like that
happens.

On Mon, Nov 2, 2020 at 4:29 PM Ed Leafe  wrote:

> On Nov 2, 2020, at 16:18, Stephen Russell  wrote:
> >
> > Who has to write programs that span time zones?  Do you adjust against HQ
> > time or UTC?
>
> Anything that is based on something other than UTC will fail.
>
>
> -- Ed Leafe
>
>
>
>
>
>
>
[excessive quoting removed by server]

___
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 message: 
https://leafe.com/archives/byMID/CAJidMYJqma6tw6cPDZ72j=q4cmahc9z1hajfeh8xusgrzgk...@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.

Do you have code in place for DST?

[Stephen Russell]

Who has to write programs that span time zones?  Do you adjust against HQ
time or UTC?

-- 
Stephen Russell
Sr. Analyst
Ring Container Technology
Oakland TN

901.246-0159 cell


--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

___
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 message: 
https://leafe.com/archives/byMID/cajidmykcewfzimbnduwjgvp7_2sjtaf-49nsuvozw5o1sba...@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: COUNT FOR hangs on record locking, but SQL - SELECT COUNT(*) works with no issue. Why?

[Stephen Russell]

In uber complicated queries or counts, in this case, I'll add various
counts in a query that uses UNION to allow index seeks per param with an
index hint for each that I am interested in.

Granted raw VFP will pull the entire cdx into ram and probably the entire
table because we have so much ram, and vfp table size is tiny.  Local ram
always kicks ass.  My current db file is 1.8TB.  My SQL server in Prod has
60 gig of ram for the instance that holds my ERP db.  It jams for doing the
traditional functionality all day, any day.  Nightly we pull
relevant business data into our DW.  Against the DW I can do any processing
I want and never stress the ERP system.

Our business rule is to never touch the live ERP system unless you are
after just in time data.  We only have 2 usage cases that need to do that
so far.  Customer portal updates on daily shipments in one and the
Certificate of Analysis for every truckload leaving.

We are very proud of holding that line.We do 150-250 trucks a day
depending on the day in the week.

On Mon, Oct 26, 2020 at 3:05 AM Jürgen Wondzinski 
wrote:

> >> You never have to count the table rows itself
>
> But but... wouldn't this only be relevant if you just want the raw
> RecordCount?
>
> As soon as you would do a COUNT FOR (or COUNT WHERE for you SQL guys) the
> metadata or systemtables don't help you a dime.  And VFP's queryEngine is
> so
> intelligent that it can optimze a COUNT FOR by asking the indices, as long
> as the FOR condition is equal to an indexkey.
> BTW: since SQLServer got VFP's Rushmore logics, it should be the same there
> too.
>
>
> wOOdy
>
>
> -Ursprüngliche Nachricht-
> Von: ProFox  Im Auftrag von Stephen Russell
> Gesendet: Montag, 26. Oktober 2020 02:01
> An: ProFox Email List 
> Betreff: Re: COUNT FOR hangs on record locking, but SQL - SELECT COUNT(*)
> works with no issue. Why?
>
> The example was to do a count(*) in VFP.  You don't have these system
> tables.
>
> SELECT SCHEMA_NAME(schema_id) AS [SchemaName], [Tables].name AS
> [TableName],
> SUM([Partitions].[rows]) AS [TotalRowCount] FROM sys.tables AS [Tables]
> JOIN
> sys.partitions AS [Partitions] ON [Tables].[object_id] =
> [Partitions].[object_id] AND [Partitions].index_id IN ( 0, 1 )
> -- WHERE [Tables].name = N'name of the table'
> GROUP BY SCHEMA_NAME(schema_id), [Tables].name;
>
> You never have to count the table rows itself.  I wasn't going to show this
> thinking that it wasn't viable in VFP.
>
> those lawyers who are too stupid to see the obvious.
>
>
[excessive quoting removed by server]

___
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 message: 
https://leafe.com/archives/byMID/cajidmyjm-2za6qmjrqzgqo9n7csfhpyhwsvoxbwbezga_bb...@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: COUNT FOR hangs on record locking, but SQL - SELECT COUNT(*) works with no issue. Why?

[Stephen Russell]

The example was to do a count(*) in VFP.  You don't have these system
tables.

SELECT SCHEMA_NAME(schema_id) AS [SchemaName],
[Tables].name AS [TableName],
SUM([Partitions].[rows]) AS [TotalRowCount]
FROM sys.tables AS [Tables]
JOIN sys.partitions AS [Partitions]
ON [Tables].[object_id] = [Partitions].[object_id]
AND [Partitions].index_id IN ( 0, 1 )
-- WHERE [Tables].name = N'name of the table'
GROUP BY SCHEMA_NAME(schema_id), [Tables].name;

You never have to count the table rows itself.  I wasn't going to show this
thinking that it wasn't viable in VFP.



On Sat, Oct 24, 2020 at 6:34 PM MB Software Solutions, LLC <
mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote:

> Hi Stephen,
>
> Your reply doesn't help the matter in question but I'll play along.  ;-)
>
> On "real DBMS" systems like your example, shouldn't it use the header or
> meta-data to know the record count rather than load the whole thing into
> memory?  That doesn't seem right.
>
>
> On 10/24/2020 11:25 AM, Stephen Russell wrote:
> > I just did a count(*) from one of our biggest tables.  It took 2 min to
> > load it into memory the first time.
> > SELECT count(*) cnt
> >FROM [erplndb].[dbo].[glTable600]
> >
> > cnt
> > 138,371,855
> >
> > The second time I run this it only takes .03 seconds.   The size of the
> > table and index is a mere 364 gigs today.
> >
> >
> >
> > On Fri, Oct 23, 2020 at 2:24 PM MB Software Solutions, LLC <
> > mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote:
> >
> >> The WHERE clause was something to count but I don't think it was
> >> optimizable because no index based on it.  (Vague recollection; not 100%
> >> sure.)
> >>
> >> SET MULTILOCKS is ON.
> >>
> >>
> >> On 10/22/2020 3:36 PM, Richard Kaye wrote:
> >>> True.  My next guess is it's using the index because your WHERE clause
> >> is Rushmore optimized. So it still doesn't need to move the record
> pointer
> >> in the source table. And I'll return to how your environment is setup.
> I'd
> >> have to go read the fine docs to understand why moving the record
> pointer
> >> is also trying to lock the row. Do you have SET MULTILOCKS ON?
> >>> --
> >>>
> >>> rk
> >>>
> >>> -Original Message-
> >>> From: ProfoxTech  On Behalf Of Richard
> >> Kaye
> >>> Sent: Thursday, October 22, 2020 3:28 PM
> >>> To: profoxt...@leafe.com
> >>> Subject: RE: COUNT FOR hangs on record locking, but SQL - SELECT
> >> COUNT(*) works with no issue. Why?
> >>> Leaving aside  the environment stuff like SET EXCLUSIVE and SET
> >> MULTILOCKS, my first guess is COUNT FOR actually moves the record
> pointer
> >> through every  row in the table, Whereas SELECT COUNT() is reading the
> >> header.
> >>> --
> >>>
> >>> rk
> >>>
> >>> -Original Message-
> >>> From: ProfoxTech  On Behalf Of MB
> >> Software Solutions, LLC
> >>> Sent: Thursday, October 22, 2020 3:24 PM
> >>> To: profoxt...@leafe.com
> >>> Subject: COUNT FOR hangs on record locking, but SQL - SELECT COUNT(*)
> >> works with no issue. Why?
> >>> VFP9SP3
> >>>
> >>> Why would a COUNT FOR hang ("Attempting to lock") whereas my easy
> >> workaround is SELECT COUNT(*) FROM SomeCursor WHERE  < yada>>   ??
> >>> tia,
> >>> --Mike
> >>>
> >>>
[excessive quoting removed by server]

___
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 message: 
https://leafe.com/archives/byMID/CAJidMY+rgm+DyMzvwWKSEuJvRaXKnC-fk9=j_r=n7fgnug7...@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: COUNT FOR hangs on record locking, but SQL - SELECT COUNT(*) works with no issue. Why?

[Stephen Russell]

glTable600 was replacing the true table name because we don't state true
identities.  It is our gl transaction table and it is a beast in size.

On Sat, Oct 24, 2020 at 10:43 AM Christof Wollenhaupt <
chris...@wollenhaupt.org> wrote:

> SQL server works completely differently from FoxPro. For Sql Server the
> performance even on the same system would heavily depend on the isolation
> level you use, concurrent access and memory usage. I've consulted on SQL
> server databases projects in the close to a TB database size range where
> developers were thinking that performance optimization means creating the
> right indexes, but totally ignored how SQL server locking works, how
> transactions work, how memory can be utilized, etc.
>
> It does make a big difference, if the database engine knows which parts of
> a file have changed (SQL Server) vs. it can only tell if a file has
> changed, if at all (VFP).
>
> BTW, what exactly is "glTable600"?
>
> --
> Christof
>
> > On 24. Oct 2020, at 17:25, Stephen Russell 
> wrote:
> >
> > I just did a count(*) from one of our biggest tables.  It took 2 min to
> > load it into memory the first time.
> > SELECT count(*) cnt
> >  FROM [erplndb].[dbo].[glTable600]
> >
> > cnt
> > 138,371,855
> >
> > The second time I run this it only takes .03 seconds.   The size of the
> > table and index is a mere 364 gigs today.
> >
>
>
>
> --- 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: 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 message: 
https://leafe.com/archives/byMID/CAJidMYL2ZYyAo2U_B5v=sfmjzfaqbjum0mnr1vyhd2eyav7...@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: COUNT FOR hangs on record locking, but SQL - SELECT COUNT(*) works with no issue. Why?

[Stephen Russell]

I just did a count(*) from one of our biggest tables.  It took 2 min to
load it into memory the first time.
SELECT count(*) cnt
  FROM [erplndb].[dbo].[glTable600]

cnt
138,371,855

The second time I run this it only takes .03 seconds.   The size of the
table and index is a mere 364 gigs today.



On Fri, Oct 23, 2020 at 2:24 PM MB Software Solutions, LLC <
mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote:

> The WHERE clause was something to count but I don't think it was
> optimizable because no index based on it.  (Vague recollection; not 100%
> sure.)
>
> SET MULTILOCKS is ON.
>
>
> On 10/22/2020 3:36 PM, Richard Kaye wrote:
> > True.  My next guess is it's using the index because your WHERE clause
> is Rushmore optimized. So it still doesn't need to move the record pointer
> in the source table. And I'll return to how your environment is setup. I'd
> have to go read the fine docs to understand why moving the record pointer
> is also trying to lock the row. Do you have SET MULTILOCKS ON?
> >
> > --
> >
> > rk
> >
> > -Original Message-
> > From: ProfoxTech  On Behalf Of Richard
> Kaye
> > Sent: Thursday, October 22, 2020 3:28 PM
> > To: profoxt...@leafe.com
> > Subject: RE: COUNT FOR hangs on record locking, but SQL - SELECT
> COUNT(*) works with no issue. Why?
> >
> > Leaving aside  the environment stuff like SET EXCLUSIVE and SET
> MULTILOCKS, my first guess is COUNT FOR actually moves the record pointer
> through every  row in the table, Whereas SELECT COUNT() is reading the
> header.
> >
> > --
> >
> > rk
> >
> > -Original Message-
> > From: ProfoxTech  On Behalf Of MB
> Software Solutions, LLC
> > Sent: Thursday, October 22, 2020 3:24 PM
> > To: profoxt...@leafe.com
> > Subject: COUNT FOR hangs on record locking, but SQL - SELECT COUNT(*)
> works with no issue. Why?
> >
> > VFP9SP3
> >
> > Why would a COUNT FOR hang ("Attempting to lock") whereas my easy
> workaround is SELECT COUNT(*) FROM SomeCursor WHERE  <>   ??
> >
> > tia,
> > --Mike
> >
> >
[excessive quoting removed by server]

___
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 message: 
https://leafe.com/archives/byMID/cajidmyjzmkge97eau44cqh6tavqc8yceqd2_zkn2+tiwfur...@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: [NF] nice python code tricks

[Stephen Russell]

My employer is looking to do more in python code if applicable.

I accept that as a challenge.

On Mon, Sep 28, 2020 at 11:17 AM Ed Leafe  wrote:

> On Sep 28, 2020, at 10:14, Stephen Russell  wrote:
> >
> > 10 Python Tips and Tricks For Writing Better Code
> > https://www.youtube.com/watch?v=C-gEQdGVXbk
>
> Those kinds of things are what I use when interviewing candidates. I’ll
> give them some code to review that has several of those less
> efficient/elegant structures, and based on how many they notice, I’ll have
> a pretty good idea where their experience level is.
>
>
> -- Ed Leafe
>
>
>
>
>
>
>
[excessive quoting removed by server]

___
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 message: 
https://leafe.com/archives/byMID/cajidmyjy0aag3qjl3anbfbqtsuls-dzl1mv98cfqst_z+8x...@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.

[NF] nice python code tricks

[Stephen Russell]

10 Python Tips and Tricks For Writing Better Code
https://www.youtube.com/watch?v=C-gEQdGVXbk


-- 
Stephen Russell
Sr. Analyst
Ring Container Technology
Oakland TN

901.246-0159 cell


--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

___
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 message: 
https://leafe.com/archives/byMID/cajidmyj8z83rn9ixaxvf312iryhfofexn4jecw0juvhd42p...@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: [NF] State of .NET webinar

[Stephen Russell]

I believe that is correct.

On Mon, Aug 17, 2020 at 3:16 PM Jürgen Wondzinski 
wrote:

> This would take place on Wednesday, 26.August 17:00 UTC ( 13:00 EST /
> 19:00 Germany)  ??
>
> -Ursprüngliche Nachricht-
> Von: ProFox  Im Auftrag von Stephen Russell
> Gesendet: Montag, 17. August 2020 15:46
> An: ProFox Email List 
> Betreff: [NF] State of .NET webinar
>
> Marcus used to be a FoxPro developer.
>
> We've created a series of State of .NET online events each focusing on a
> specific .NET topic. This installment covers various ways of doing *web
> development with Microsoft technologies & platforms*.
>
> Join Markus Egger (EPS Software President, Chief Software Architect and
> Microsoft Regional Director) as he continues our online series with his
> “State of Microsoft Web Development” presentation.
>
> Topics covered in this event include:
>
>- ASP.NET <http://asp.net/>
> Core
>- Razor Pages
>- Blazor (client-side and server-side)
>- Deployment to Windows and Linux Servers
>- Progressive Web Apps
>- Client-side frameworks (Vue.js, Angular, React)
>- Azure Static Pages
>
> Attendees will come away with an understanding of which technologies to
> use for which scenario.
>
> *Note*: Only registered attendees will receive the live stream URL via
> email the morning of the event.
> Register here:
>
> https://u14306485.ct.sendgrid.net/ls/click?upn=-2FlhZWJjobIdHG3rVYRj6ZHvtoiGCsxBe6GWqxUAIrhAGF6aPhrJCluVzNECGdOp6bZ4Q2i7aF9poTppvkfrkK6-2F4gYViqoSvTQgM-2BO54f-2BI-3DdLpH_6MNhH-2F9xC4B4dmryIkr-2BKfBAvtS41u-2BD3PfFZMqGl3tPwuFowY8IwZIYjfxUC7ZeNpUR-2F1R0iCDI6-2BbXVoyFkOSA07aQfj8-2FaY-2Br680FEjkHl-2BtB1MSSJ6SIFDPev4boLT4X-2BtyRSsqACQNQt1K1IX-2Be9v2qQrDyqmbU4soNSBA1fSmV3EYFyiSJRxzy85ZsJl4-2FsYRgO3TqBjglyCNKVwLhwleLppMdNyXGZh-2FHzBraETqazMfV416BJ0a76x4xZdL-2FozOieGL4kkzQUvSgBQ-3D-3D
>
>
[excessive quoting removed by server]

___
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 message: 
https://leafe.com/archives/byMID/CAJidMYKo6PLLx5uQOc1L27iX=hd7doc1_csor6sebsekash...@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.

[NF] State of .NET webinar

[Stephen Russell]

Marcus used to be a FoxPro developer.

We've created a series of State of .NET online events each focusing on a
specific .NET topic. This installment covers various ways of doing *web
development with Microsoft technologies & platforms*.

Join Markus Egger (EPS Software President, Chief Software Architect and
Microsoft Regional Director) as he continues our online series with his
“State of Microsoft Web Development” presentation.

Topics covered in this event include:

   - ASP.NET <http://asp.net/>
Core
   - Razor Pages
   - Blazor (client-side and server-side)
   - Deployment to Windows and Linux Servers
   - Progressive Web Apps
   - Client-side frameworks (Vue.js, Angular, React)
   - Azure Static Pages

Attendees will come away with an understanding of which technologies to use
for which scenario.

*Note*: Only registered attendees will receive the live stream URL via
email the morning of the event.
Register here:
https://u14306485.ct.sendgrid.net/ls/click?upn=-2FlhZWJjobIdHG3rVYRj6ZHvtoiGCsxBe6GWqxUAIrhAGF6aPhrJCluVzNECGdOp6bZ4Q2i7aF9poTppvkfrkK6-2F4gYViqoSvTQgM-2BO54f-2BI-3DdLpH_6MNhH-2F9xC4B4dmryIkr-2BKfBAvtS41u-2BD3PfFZMqGl3tPwuFowY8IwZIYjfxUC7ZeNpUR-2F1R0iCDI6-2BbXVoyFkOSA07aQfj8-2FaY-2Br680FEjkHl-2BtB1MSSJ6SIFDPev4boLT4X-2BtyRSsqACQNQt1K1IX-2Be9v2qQrDyqmbU4soNSBA1fSmV3EYFyiSJRxzy85ZsJl4-2FsYRgO3TqBjglyCNKVwLhwleLppMdNyXGZh-2FHzBraETqazMfV416BJ0a76x4xZdL-2FozOieGL4kkzQUvSgBQ-3D-3D


-- 
Stephen Russell
Sr. Analyst
Ring Container Technology
Oakland TN

901.246-0159 cell


--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

___
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 message: 
https://leafe.com/archives/byMID/cajidmyjk-1_fvqsobpth+n0hcrgay6kuvoslehwr8agmt2a...@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.

[NF] Curse and blessings of dynamic sql

[Stephen Russell]

Saw this on a video this morning and wanted to pass it along to you.

http://www.sommarskog.se/dynamic_sql.html



-- 
Stephen Russell
Sr. Analyst
Ring Container Technology
Oakland TN

901.246-0159 cell


--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

___
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 message: 
https://leafe.com/archives/byMID/CAJidMY+86zufwd9GTfkqB=kgim22pxgsnnnpatohtc3j1wf...@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: Task: Process thousands of records through a regular process -- multiple EXE runs to cut down processing time??

[Stephen Russell]

What is your bottleneck in the process, an update of the backend data ?

Can your update or insert be made in groups of 100 or 1000 at a pass,
instead of one at a time?  Or do you need a key back for
additional processing?

On Sat, Aug 1, 2020 at 12:07 PM MB Software Solutions, LLC <
mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote:

> I've got a regular process that runs, basically using key information to
> grab data from an API and then update the local VFP database.  There are
> maybe 64000 records to process, and each record to update through this
> process takes about a second, so to process this group would take over
> 17 hours.  Each record could be processed on its own; there are no
> relationships between each.
>
> I don't want to start it and run the 64000 in a row for 17+ hours.  I
> would like to design the app to use the table, RLOCK the row I'm
> processing, and the UNLOCK the row when I'm done.  I figure with this
> design, I could run multiple instances of the MyProgram.exe (similar to
> how WestWind Web Connection allows you to run multiple instances) to
> process the batch maybe 4x faster (if I launched 4 instances of
> MyProgram.exe).  The basic construct would be as follows:
>
> USE ListOfRecsToProcess IN 0 SHARED Alias MyList && record is PK (to
> process) i, tProcessed t, tError t, cSession c(10)
> SCAN FOR EMPTY(cSession) AND RLOCK('MyList')
>  IF ProcessRecord(MyList.ID) THEN
>  REPLACE tProcessed WITH DATETIME(), cSession WITH this.cSession
> IN MyList
>  ELSE
>  REPLACE tError WITH DATETIME(), cSession WITH this.cSession IN
> MyList
>  ENDIF
> ENDSCAN
>
>
> Does anybody see any problems with that general design?  The
> ProcessRecord method calls an API to get values and then updates the
> local VFP record accordingly.
>
> 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: 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 message: 
https://leafe.com/archives/byMID/cajidmykzwsphe+euz6t5bgipvt-4a2abdbzvriyu13ooo2g...@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: X# and .NET Core

[Stephen Russell]

Lamda is so easy to work with, in my mind when you have the data because
running back to either the api or your database is costly.

This run is used in posting lists of our employees by plant, to an API
service that makes filling out accident reports on-site at our plants
accessible on their phone app.

// sort all data by location
employees.Sort((x, y) => String.Compare(x.Location,
y.Location));
// only active
employees.RemoveAll(x => x.Active == false);
// get rid of all HQ folk
employees.RemoveAll(b => b.Location == "");


On Thu, Jul 30, 2020 at 6:13 PM MB Software Solutions, LLC <
mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote:

> To be honest, I never liked DotNet lambda expressions.  This line makes
> my eyes roll.
>
>
> On 7/30/2020 2:17 PM, Stephen Russell wrote:
> > If you are filtering you should consider lamda expressions
> > (x => x.ColumnName != 0).ToArray()
>
> --
> 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: 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 message: 
https://leafe.com/archives/byMID/cajidmykppweqf9cyjmhjk8fwtcsjx6fxxe2n4mrs0-u0oxc...@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: X# and .NET Core

[Stephen Russell]

maybe it is a linq call for loading the VFP data into a .NET friendly data
object?

Here is a how to do it in the OLD days of LINQ.  This would give you the
dataobject you would foreach() through.

using System.Data;
using System.Data.OleDb;
public class YourClass{
   public DataTable GetYourData()
   {
  DataTable YourResultSet = new DataTable();

  OleDbConnection yourConnectionHandler = new OleDbConnection(
  "Provider=VFPOLEDB.1;Data Source=C:\\SomePath\\;" );

  // if including the full dbc (database container) reference,
just tack that on//  OleDbConnection yourConnectionHandler = new
OleDbConnection(//  "Provider=VFPOLEDB.1;Data
Source=C:\\SomePath\\NameOfYour.dbc;" );


  // Open the connection, and if open successfully, you can try to query it
  yourConnectionHandler.Open();

  if( yourConnectionHandler.State == ConnectionState.Open )
  {
 OleDbDataAdapter DA = new OleDbDataAdapter();
 string mySQL = "select A1.*, B1.* "
 + " from FirstTable A1 "
 + "  join SecondTable B1 "
 + " on A1.SomeKey = B1.SomeKey "
 + " where A1.WhateverCondition ";  // blah blah...

 OleDbCommand MyQuery = new OleDbCommand( mySQL, yourConnectionHandle );

 DA.SelectCommand = MyQuery;

 DA.Fill( YourResultSet );

 yourConnectionHandle.Close();
  }

  return YourResultSet;
   }}

s <https://stackoverflow.com/a/10707417>

On Thu, Jul 30, 2020 at 1:43 PM Matt Slay 
wrote:

>  >>  Now how do you get your data into an object in X# I do not know.
>
>
> Indeed, still waiting on them to implement the SCATTER/GATHER commands.
>
> It is listed as Github issue # 387 with a Jun 2020 Miletsone, but I think
> they missed that a little...
>
> https://github.com/X-Sharp/XSharpPublic/issues/387
>
> Robert has replied in the discussion forum with "It will be relatively
> easy to implement this with a UDC."
>
> as can be seen in this message thread"
>
> https://www.xsharp.info/forum/private-vfp/1278-scatter-dumping-a-data-row-to-an-object#9182*
> *
>
> **
> *
> *
> *Matt Slay*
> **
>
>
> On 2020-07-30 1:17 PM, Stephen Russell wrote:
> > Scan is an iteration through data,right?  I would just use foreach()
> loop.
> > Now how do you get your data into an object in X# I do not know.
> >
> > If you are filtering you should consider lamda expressions
> > (x => x.ColumnName != 0).ToArray()
> >
> > On Wed, Jul 29, 2020 at 11:01 AM MB Software Solutions, LLC <
> > mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote:
> >
> >> No SCAN/ENDSCAN support yet?
> >>
> >>
> >> On 7/29/2020 11:56 AM, Johan Nel wrote:
> >>> Hi all VFPers,
> >>>
> >>> Well have not posted much lately about X# here due to some other
> >>> issues I have to attend to, but good progress are made with support
> >>> for the VFP dialect.
> >>>
> >>> As per the message regarding .NET Core, I would also like to share
> >>> progress with X# regarding .NET Core support.
> >>>
> >>> Attached the link and posting by Robert today.
> >>>
> >>> Hope it is of interest to (most) some.
> >>>
> >>> Johan Nel
> >>> George, South Africa.
> >>>
> >>>
> >>
> https://www.xsharp.info/forum/public-product/2069-xsharp-builds-on-net-core
> >>>
> >>> I would like to share some progress that I made today.
> >>> I have changed the X# build system to support building for .Net Core.
> >>> Consider an app that has one PRG file and a XSPROJ file.
> >>> The contents of the XSProj file looks like this:
> >>>
> >>> 
> >>>
> >>>
> >>>  Exe
> >>>  netcoreapp5.0
> >>>  true
> >>>  vo
> >>>
> >>> 
> >>>  
> >>>  
> >>>  
> >>>  
> >>> 
> >>> 
> >>> 
> >>> >>> Version="4.7.1" />
> >>> 
> >>> 
> >>>
> >>>
> >>> As you can see we are compiling for .Net Core 5.0 and for the VO
> >>> dialect. I have included the XSharp assemblies needed to open a DBF
> >>> file. The only "strange" thing in here is the package references to
> >>> the System.Text.Encoding.CodePages package, because by default .Net
> 

Re: X# and .NET Core

[Stephen Russell]

Scan is an iteration through data,right?  I would just use foreach() loop.
Now how do you get your data into an object in X# I do not know.

If you are filtering you should consider lamda expressions
(x => x.ColumnName != 0).ToArray()

On Wed, Jul 29, 2020 at 11:01 AM MB Software Solutions, LLC <
mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote:

> No SCAN/ENDSCAN support yet?
>
>
> On 7/29/2020 11:56 AM, Johan Nel wrote:
> > Hi all VFPers,
> >
> > Well have not posted much lately about X# here due to some other
> > issues I have to attend to, but good progress are made with support
> > for the VFP dialect.
> >
> > As per the message regarding .NET Core, I would also like to share
> > progress with X# regarding .NET Core support.
> >
> > Attached the link and posting by Robert today.
> >
> > Hope it is of interest to (most) some.
> >
> > Johan Nel
> > George, South Africa.
> >
> >
> https://www.xsharp.info/forum/public-product/2069-xsharp-builds-on-net-core
> >
> >
> > I would like to share some progress that I made today.
> > I have changed the X# build system to support building for .Net Core.
> > Consider an app that has one PRG file and a XSPROJ file.
> > The contents of the XSProj file looks like this:
> >
> > 
> >   
> >   
> > Exe
> > netcoreapp5.0
> > true
> > vo
> >   
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> >> Version="4.7.1" />
> > 
> > 
> >
> >
> > As you can see we are compiling for .Net Core 5.0 and for the VO
> > dialect. I have included the XSharp assemblies needed to open a DBF
> > file. The only "strange" thing in here is the package references to
> > the System.Text.Encoding.CodePages package, because by default .Net
> > Core does not have support for Codepage 1252 which I am using.
> > Unlike traditional project files there are no items included. By
> > default .Net Core includes all source code items in the folder.
> >
> > The code looks like this:
> >
> > USING System.Text
> >
> > FUNCTION Start() AS VOID
> > FIELD CUSTNUM, LASTNAME, FIRSTNAME
> > Encoding.RegisterProvider(CodePagesEncodingProvider.Instance)
> > ? "Hello from X#"
> > ? "OS   :",OS(TRUE)
> > ? "Framework:", System.Environment.Version:ToString()
> > ? "Xsharp   : version", Version(), "dialect",
> > RuntimeState.Dialect:ToString()
> > ? "Datetime :", DateTime()
> > ? "Program  :", ExecName(TRUE)
> > ? "Workdir  :", WorkDir()
> > ? "Curdir   :", System.IO.Directory.GetCurrentDirectory()
> >
> > ? "Opening, Indexing and listing a DBF with .Net Core"
> > ?
> > USE Customer
> > INDEX ON LASTNAME TO LASTNAME
> > DO WHILE ! EOF()
> > ? Str(CUSTNUM,2) , LASTNAME, FIRSTNAME
> > SKIP
> > ENDDO
> > ? "Press any key"
> > Console.ReadLine()
> > RETURN
> >
> >
> > As you can see I am calling a function in the Encoding class to link
> > the package that has the codepage support.
> > The rest is a normal mixture of Xbase code and .Net code.
> > To compile and run the program I type
> >
> > dotnet run
> >
> > on the command line.
> > The result is this:
> >
> > Hello from X#
> > OS   : Windows 10 Enterprise (x64) ( Version 10.0, Build 18363 )
> > Framework: 5.0.0
> > Xsharp   : version XSharp 2.5.2.0 dialect VO
> > Datetime : 29-07-2020 16:10:58
> > Program  : C:\test\bin\Debug\netcoreapp5.0\test.dll
> > Workdir  : C:\test\bin\Debug\netcoreapp5.0\
> > Curdir   : C:\test
> > Opening, Indexing and listing a DBF with .Net Core
> >
> >  6 Baker  James
> >  2 Borne  Maria
> > 15 Chandler   Walter
> >  3 Cooper Elizabeth
> > 12 Cusumano   Karen
> >  5 Dougherty  Janet
> > .
> > .
> > 14 Walsh  Gloria
> > 19 Zimmerman  Carla
> > Press any key
> >
> >
> > As you can see the runtime, RDD system and Macro compiler all work on
> > .Net Core 5.0 !
> > You can deploy this app with all support DLLs in one single Exe and 2
> > small DLLs by calling:
> >
> > dotnet publish --self-contained true -r win-x64
> > -p:PublishSingleFile=true -p:PublishTrimmed=true
> >
> >
> > This creates the following files, which make up the whole program:
> >
> > 29-07-2020  16:1328.955.153 test.exe
> > 28-05-2020  08:26   500.608 hostfxr.dll
> > 28-05-2020  08:26   506.248 hostpolicy.dll
> >
> > Even the XSharp DLLs are included in test,exe. The total size is 29 Mb.
> >
> > You can also prepare an image for Linux by replacing win-x64 with
> > linux-x64 and then the output is:
> >
> > 29-07-2020  16:1644.552.454 test
> > 28-05-2020  07:54   563.728 libhostfxr.so
> > 28-05-2020  07:54   532.408 libhostpolicy.so
> >
> > A self contained .Net app for Linux in 44 Mb !
> >
> > I hope you find this interesting.
> >
> > Robert
> >
> > And yes this will be included in the next build. Not with the VS
> > project system, that will take a bit longer.
> >
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of t

Re: [NF] .NET Core build to runtime 3.1.5 with SDK for 3.1.6 installed - Possible?

[Stephen Russell]

You can downgrade the version of core required in the project.  Either way,
you have to supply that in your installer.  Your clients probably won't
have it on thier machines.  I'd consider using the M$ one because it will
bring in the correct bootstraping you'll need.

I only do web installs and not systems that use a forms based UI.



On Tue, Jul 28, 2020 at 12:11 PM Tracy Pearson 
wrote:

> My searches on the internet are fetching a bunch of build .NET Core 2.1
> with
> .NET Core 3.0 installed.
> I'm in the later stages of getting a product ready for release and the test
> machines and build machines are still on 3.1.5.
>
> When I want to do a quick build from my system which was installed at
> 3.1.6,
> it refuses to run on the test machines. I get this:
> It was not possible to find any compatible framework version
> The framework 'Microsoft.AspNetCore.App', version '3.1.6' was not found.
>
> I tried dotnet build -f netcoreapp3.1.5 and got this:
> C:\Program
>
> Files\dotnet\sdk\3.1.302\Sdks\Microsoft.NET.Sdk\targets\Microsoft.NET.Target
> FrameworkInference.targets(127,5): error NETSDK1045: The current .NET SDK
> does not support targeting .NET Core 3.1.5.  Either target .NET Core 3.1 or
> lower, or use a version of the .NET SDK that supports .NET Core 3.1.5.
> [c:\work\pcservice\PcService12\PcService12.csproj]
>
> I distribute software to churches. I don't expect them to have a dedicated
> IT group.
> My concern is what happens when the SDK on the build machine moves from
> 3.1.5 to 3.1.6 due to an update from Microsoft.
> If I have already shipped the product and have it installed on multiple
> system, these systems will need the updated runtimes.
> Microsoft has supplied a PowerShell script that will download and install
> the latest runtime. The problem with that, is the default setting on a new
> Windows 10 Home machine is to not allow scripts to run.
> I know the installer is running as an authenticated administrator. It
> doesn't feel right to change that setting. That just feels like it will
> open
> a security risk on a customer machine. Then can I change it back to what it
> was? That thought leaves a bad feeling about the whole process.
>
> I have been using INNO Setup for years and was using it with this project.
> 1) I'm familiar with it 2) I ship a COM object and one-click did not
> support
> that when I researched it some years ago.
>
> So here are my questions:
> 1 - Is there a way to build to a lower release of the runtime?
> I know framework-dependent apps roll forward:
>
> https://docs.microsoft.com/en-us/dotnet/core/versions/selection#framework-de
> pendent-apps-roll-forward
> 
>
> 2 - Is there a different installer available that can help keep the
> runtimes
> updated with the EXE?
> I'm looking at needing to ship an updated runtime each time the build
> machine gets updated.
>
> I considered the Self-contained deployments that include the runtime. This
> would mean when an update to the framework shipped, we should ship a
> maintenance release to address the security problems in the old runtimes. I
> felt this was a compelling reason to allow Microsoft to update the runtimes
> and the app could be dependent on the installed framework. Now I have the
> drawback of the build machine has a newer SDK and it builds to that
> runtime.
>
>
> 3 - What have I not thought of going through all this?
>
> Thank you,
> Tracy
>
>
[excessive quoting removed by server]

___
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 message: 
https://leafe.com/archives/byMID/cajidmy+dpr+xyvv5orvgvkkr0fqfmfumjnc8x2ohgo_mait...@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: Unit tests (was Re: [NF] I will .....)

[Stephen Russell]

Or clear statistics :)  Massive data growth can change a sproc's best
intentions over time.

Placing select top 1 in your query was good for testing speed but could
lead to missing rows that you need over time.

On Fri, Jul 24, 2020 at 9:08 AM Richard Kaye  wrote:

> With MSSQL it's all about execution plans and statistics. An SP is a known
> quantity whereas SPT queries have to be evaluated each time they are run.
> Regardless, a poorly written SP or one with a bad plan in the cache can
> still perform badly. As Uncle Ted always tells us, you have to test in your
> environment with your data.
>
> --
>
> rk
>
> -Original Message-
> From: ProfoxTech  On Behalf Of MB Software
> Solutions, LLC
> Sent: Friday, July 24, 2020 9:30 AM
> To: profoxt...@leafe.com
> Subject: Re: Unit tests (was Re: [NF] I will .)
>
> I always thought stored procedures were faster??
>
> On 7/24/2020 8:43 AM, Richard Kaye wrote:
> > There are performance implications to using SPs, at least in MSSQL.
> >
> > --
> >
> > rk
> >
> > -Original Message-
> > From: ProfoxTech  On Behalf Of MB
> > Software Solutions, LLC
> > Sent: Thursday, July 23, 2020 10:27 PM
> > To: profoxt...@leafe.com
> > Subject: Re: Unit tests (was Re: [NF] I will .)
> >
> > On 7/23/2020 8:07 PM, Stephen Russell wrote:
> >> Pretty much for anything that is repetitive in nature.  All apps yes.
> >> I have the instances set to not allow homemade sql except for some of
> >> our new stuff in R, or my certificate report that passes SQL to
> >> include all of the Lot Numbers needed.  It is on a separate sql
> >> server and operates very slowly if I use a where in with code that
> executed at the calling server.
> >>
> >> Why would you NOT use sprocs is my #1 question?
> >
> > Years ago there was the debate as to whether you put all the logic into
> your backend database or DataObject class...I went for the latter.  Gave me
> easier portability if I ever needed it.  (And actually, I did...I went from
> VFP backends to MySQL/MariaDB 15 years ago.  Required VERY LITTLE code
> changes!)  Now that doesn't mean I don't use stored procedure...I do!  I
> just don't use them for basic INSERT/UPDATE/DELETE statements.  I do use
> triggers though too.
> >
> >
> > --
> > 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: 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 message: 
https://leafe.com/archives/byMID/cajidmyk2bxx5kyabmnu4fqcdjkxhpwhzw2po3ixy4hpnbvc...@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: Unit tests (was Re: [NF] I will .....)

[Stephen Russell]

This is an actual test in my code:

[TestMethod]
public void custItemView()
{
String item = "351000287";
String VenItem = EFData.GetCustomerPartFromView(item);
Assert.IsTrue(VenItem.Length > 0);
}

My function has a view of all items in our cross-reference tables. Is that
found and what is their item number for it.  I assert that it will be
found, and to verify it was, the length of the string has to have some
data.



On Fri, Jul 24, 2020 at 8:20 AM Alan Bourke  wrote:

> > I still have trouble conceptualizing how to write unit tests for data
> > access.
>
> That's an integration test, really, not a unit test.
>
> What I do is set up data sets  of VFP tables or SQL Server and then
> zip\unzip the one that applies to the test, as part of the test.
>
> --
>   Alan Bourke
>   alanpbourke (at) fastmail (dot) fm
>
[excessive quoting removed by server]

___
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 message: 
https://leafe.com/archives/byMID/cajidmyjcm0yhwajwj1qod8gfy8soucf663npkzrdhf20rct...@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: Unit tests (was Re: [NF] I will .....)

[Stephen Russell]

I'll bite. If you don't use sprocs for standard CRUD operations, why do you
need them?  Do you work with a great deal of 4th normal data that the
joining of the same tables over and over is easier in a sproc?  Or do you
have a process like EOM where you are doing repetitive things to data
tables?  Maybe it is good for dealing with data in separate
systems/environments that allow you to get warehousing data from WHS and
then issue pick tickets and truck lists to move it all?

My most used sproc gets shipping data from the ERP and pull specifications
from of BOM system for each item, and then averages metrics from our test
system by item by lot giving the customer a Certificate of Analysis.  I
pull AD data to determine who are the managers at that plant for every
truckload we ship.

On Thu, Jul 23, 2020 at 9:27 PM MB Software Solutions, LLC <
mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote:

> On 7/23/2020 8:07 PM, Stephen Russell wrote:
> > Pretty much for anything that is repetitive in nature.  All apps yes.  I
> > have the instances set to not allow homemade sql except for some of our
> new
> > stuff in R, or my certificate report that passes SQL to include all of
> the
> > Lot Numbers needed.  It is on a separate sql server and operates very
> > slowly if I use a where in with code that executed at the calling server.
> >
> > Why would you NOT use sprocs is my #1 question?
>
>
> Years ago there was the debate as to whether you put all the logic into
> your backend database or DataObject class...I went for the latter.  Gave
> me easier portability if I ever needed it.  (And actually, I did...I
> went from VFP backends to MySQL/MariaDB 15 years ago.  Required VERY
> LITTLE code changes!)  Now that doesn't mean I don't use stored
> procedure...I do!  I just don't use them for basic INSERT/UPDATE/DELETE
> statements.  I do use triggers though too.
>
>
> --
> 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: 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 message: 
https://leafe.com/archives/byMID/CAJidMYLg1gmTU=qBq7xDjk4JB2v6bgvO3+v4=ynhhbpyp8k...@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: Unit tests (was Re: [NF] I will .....)

[Stephen Russell]

Pretty much for anything that is repetitive in nature.  All apps yes.  I
have the instances set to not allow homemade sql except for some of our new
stuff in R, or my certificate report that passes SQL to include all of the
Lot Numbers needed.  It is on a separate sql server and operates very
slowly if I use a where in with code that executed at the calling server.

Why would you NOT use sprocs is my #1 question?

On Thu, Jul 23, 2020 at 5:30 PM MB Software Solutions, LLC <
mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote:

> Stephen -- Are you still using stored procedures for all your CRUD?
>
>
> On 7/23/2020 5:54 PM, Stephen Russell wrote:
> > I only see it as testing a connection to a defined data source.  You
> > have creds that work for a positive test.  You have creds that fail to
> > notify you that no connection was made.
> >
> > If your function receives params for the actual source you are just
> > changing the params you pass back, or where they are coming back from.
> >
> > Proving something didn't work helps you catch errors nicely and deal with
> > them.
> >
> > For my coding style, I have a function that may be overloaded 2-3-+ ways.
> > All of them need to be tested.
> >
> > On Thu, Jul 23, 2020 at 12:18 PM Garrett Fitzgerald <
> sarekofvul...@gmail.com>
> > wrote:
> >
> >> I still have trouble conceptualizing how to write unit tests for data
> >> access.
> >>
> >> On Thu, Jul 23, 2020, 11:37 MB Software Solutions, LLC <
> >> mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote:
> >>
> >>> I have done it that way before, and it works well.  I wrote the DataObj
> >>> and BizObj first before the UI for those purposes.  But alas, those are
> >>> mere validation and data access classes; those are not Unit Tests, by
> my
> >>> definition anyway.  Ever since I did this n-tier design after watching
> >>> Bob Lee's WhilFest presentation in 2003, it's worked out great.  It's
> >>> much easier to connect the UI to those processes.  But my comment still
> >>> stands:  I bet less than 5% of VFP devs write unit tests in their apps.
> >>>
> >>>
> >>> On 7/21/2020 8:09 PM, Stephen Russell wrote:
> >>>> Why not?
> >>>>
> >>>> Design by Test.  You create your functionality in TESTS and then use
> >>> those
> >>>> functions in a UI.
> >>>>
> >>>> On Tue, Jul 21, 2020 at 5:53 PM MB Software Solutions, LLC <
> >>>> mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote:
> >>>>
> >>>>> I would wager that less than 5% of devs (in VFP anyway) have unit
> >> tests
> >>>>> in their solution setup.
> >>>>>
> >>>>>
> >>>>> On 7/21/2020 10:04 AM, Johan Nel wrote:
> >>>>>> Ah my child, I have to confess I have never in my complete
> >> development
> >>>>>> career had a plan or unit test done...
> >>>>>>
> >>>>>> On 2020/07/21 15:13, Eric Selje wrote:
> >>>>>>> Forgive me father, for I have started coding without having a plan
> >> or
> >>>>>>> even
> >>>>>>> a unit test written first. It's been 51 years since my last
> >>> confession.
> >>>>>>> On Sat, Jul 18, 2020 at 1:57 PM Dennis Schuette 
> >>>>>>> wrote:
> >>>>>>>
> >>>>>>>> That's such an easy change, I won't even bill you for it.
> >>>>>>>>
> >>>>>>>> 1 hour of programming, 5 hours of debugging, and 3 customer
> >> requested
> >>>>>>>> enhancements later, I'm almost done!
> >>>>>>>>
> >>>>>>>> Customized Business Services, LLC (928) 580-6352
> >>>>>>>> Dennis Schuette Primary:
> >>>>>>>> den...@cbsds.com
> >>>>>>>> 49 NW 130 Avenue Alternate:
> >>>>>>>> schuette.den...@gmail.com
> >>>>>>>> Great Bend, KS  67530
> >>>>>>>>
> >>>>>>>> -Original Message-
> >>>>>>>> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf
> >> Of
> >>>>>>>> Stephen Russell
> >>>>>>>> Sent: Frid

Re: Unit tests (was Re: [NF] I will .....)

[Stephen Russell]

I only see it as testing a connection to a defined data source.  You
have creds that work for a positive test.  You have creds that fail to
notify you that no connection was made.

If your function receives params for the actual source you are just
changing the params you pass back, or where they are coming back from.

Proving something didn't work helps you catch errors nicely and deal with
them.

For my coding style, I have a function that may be overloaded 2-3-+ ways.
All of them need to be tested.

On Thu, Jul 23, 2020 at 12:18 PM Garrett Fitzgerald 
wrote:

> I still have trouble conceptualizing how to write unit tests for data
> access.
>
> On Thu, Jul 23, 2020, 11:37 MB Software Solutions, LLC <
> mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote:
>
> > I have done it that way before, and it works well.  I wrote the DataObj
> > and BizObj first before the UI for those purposes.  But alas, those are
> > mere validation and data access classes; those are not Unit Tests, by my
> > definition anyway.  Ever since I did this n-tier design after watching
> > Bob Lee's WhilFest presentation in 2003, it's worked out great.  It's
> > much easier to connect the UI to those processes.  But my comment still
> > stands:  I bet less than 5% of VFP devs write unit tests in their apps.
> >
> >
> > On 7/21/2020 8:09 PM, Stephen Russell wrote:
> > > Why not?
> > >
> > > Design by Test.  You create your functionality in TESTS and then use
> > those
> > > functions in a UI.
> > >
> > > On Tue, Jul 21, 2020 at 5:53 PM MB Software Solutions, LLC <
> > > mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote:
> > >
> > >> I would wager that less than 5% of devs (in VFP anyway) have unit
> tests
> > >> in their solution setup.
> > >>
> > >>
> > >> On 7/21/2020 10:04 AM, Johan Nel wrote:
> > >>> Ah my child, I have to confess I have never in my complete
> development
> > >>> career had a plan or unit test done...
> > >>>
> > >>> On 2020/07/21 15:13, Eric Selje wrote:
> > >>>> Forgive me father, for I have started coding without having a plan
> or
> > >>>> even
> > >>>> a unit test written first. It's been 51 years since my last
> > confession.
> > >>>>
> > >>>> On Sat, Jul 18, 2020 at 1:57 PM Dennis Schuette 
> > >>>> wrote:
> > >>>>
> > >>>>> That's such an easy change, I won't even bill you for it.
> > >>>>>
> > >>>>> 1 hour of programming, 5 hours of debugging, and 3 customer
> requested
> > >>>>> enhancements later, I'm almost done!
> > >>>>>
> > >>>>> Customized Business Services, LLC (928) 580-6352
> > >>>>> Dennis Schuette Primary:
> > >>>>> den...@cbsds.com
> > >>>>> 49 NW 130 Avenue Alternate:
> > >>>>> schuette.den...@gmail.com
> > >>>>> Great Bend, KS  67530
> > >>>>>
> > >>>>> -Original Message-
> > >>>>> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf
> Of
> > >>>>> Stephen Russell
> > >>>>> Sent: Friday, July 17, 2020 11:06 AM
> > >>>>> To: profoxt...@leafe.com
> > >>>>> Subject: [NF] I will .
> > >>>>>
> > >>>>> Alright, I'm not a priest, but I am a programmer.
> > >>>>>
> > >>>>> Confess to me your programming sins, and I shall absolve you.
> > >>>>>
> > >>>>>
> > >>>>>
> > >>>>> --
> > >>>>> Stephen Russell
> > >>>>> Sr. Analyst
> > >>>>> Ring Container Technology
> > >>>>> Oakland TN
> > >>>>>
> > >>>>> 901.246-0159 cell
> > >>>>>
> > >>>>>
> > >>>>> --- 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: 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 message: 
https://leafe.com/archives/byMID/CAJidMYJQgihPYZaeY-fzC=SostDGMr9=5ffpmutzw1pelr-...@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: [SPAM] [SPAM] Unit tests (was Re: [NF] I will .....)

[Stephen Russell]

Whenever you go back into it for one reason or another, add a new test for
that area you are working in.

If all of your code is in screens or forms, you might be doing it wrong.

On Wed, Jul 22, 2020 at 10:55 AM Eric Selje  wrote:

> /It doesn't make sense to retrospectively create unit test for an existing
> application/
>
> Useful for when you're going to make changes and you want to ensure they
> don't break your existing app, especially for code that you inherited and
> may not fully understand. That was the impetus behind that feature.
> Definitely seems backwards though.
>
> Eric
>
> On Wed, Jul 22, 2020 at 8:23 AM Christof Wollenhaupt <
> chris...@wollenhaupt.org> wrote:
>
> > > Having said that, TDD does work "best" for new development, and many
> VFP
> > > devs are not doing a ton of apps from scratch which is why it may not
> > have
> > > caught on. It also works best with logic that's not buried in the UI,
> and
> > > unfortunately a lot of us buried it there (forgive me father).
> >
> > We have used FoxUnit for our FoxPro DOS based application. That program
> > was certainly not written with unit tests or even classes in mind. But
> even
> > a procedure with private variables can be a testable unit if you design
> the
> > interface carefully.
> >
> > It doesn't make sense to retrospectively create unit test for an existing
> > application, I agree. However, when you modify existing code it's often
> > possible to move the parts that you need to change out of the SCX Click
> or
> > whatever method into a separate class. There is no need to do this all at
> > once, just when you need to make changes to code anyway.
> >
> > When code uses functions like MESSAGEBOX(), etc. you can replace those
> > with a simple messagebox or dialog class (such as the one in INTL) and
> then
> > in your test mock this class. Various tests can then cover multiple paths
> > through the code depending on a simulated choice a user made. You can
> also
> > assert that certain messages are shown to the user by making a call an
> > expectation in foxmock and then verify those afterwards.
> >
> > --
> > Christof
> >
> > --- 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: 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 message: 
https://leafe.com/archives/byMID/CAJidMYJf8diPkEdd9g=ylqs4nmk0+ieonvzdyzuzje8iyfl...@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: [SPAM] Unit tests (was Re: [NF] I will .....)

[Stephen Russell]

DBT.  Design by Test is how I work.

My UI rarely does any voodoo for making things work.  Been that way for
almost 20 years now.

On Wed, Jul 22, 2020 at 7:59 AM Eric Selje  wrote:

> I may be biased here, having given the Unit Test talk at SW Fox and now
> maintaining FoxUnit on GitHub, but to me Test-Driven Development is one of
> those things where I "saw the light". As Stephen says, writing the tests
> first forces you to think about design first, which always leads to better
> programs. And w/ FoxMock you can remove all externalities from the tests to
> ensure it's your code that's getting tested and not its dependencies on
> other services like SQL Server or other APIs.
>
> Having said that, TDD does work "best" for new development, and many VFP
> devs are not doing a ton of apps from scratch which is why it may not have
> caught on. It also works best with logic that's not buried in the UI, and
> unfortunately a lot of us buried it there (forgive me father). It can work
> well for existing apps though, and a fairly recent (5 years?) feature of
> FoxUnit is that it will scan your existing class libs and create a test
> harness for all of your methods to get you started.
>
> Here's the FoxUnit whitepaper
>  if
> anyone's interested.
>
> Eric
>
> On Wed, Jul 22, 2020 at 1:35 AM Christof Wollenhaupt <
> chris...@wollenhaupt.org> wrote:
>
> > >
> > > To make an unit test in VFP is as easy as anything:
> > > just write your code, highlight it, activate the shortcut (right mouse
> > > click), select the option 'Execute the selection'.  A very neat and
> quick
> > > solution.
> >
> > It's even quicker if you use FoxUnit and foxmock. Both are free on VFPX.
> > I've hundreds of unit tests that I can run with a single key stroke that
> > test many different modules of our applications. Writing testable code
> also
> > tends to lead to a cleaner class design that is more reusable.
> >
> > --
> > Christof
> >
> >
> >
> > --- 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: 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 message: 
https://leafe.com/archives/byMID/cajidmy+0s7ceozl7d8evwtao036mhos+wszgtzo7_+v5msx...@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: [SPAM] Unit tests (was Re: [NF] I will .....)

[Stephen Russell]

You test success and expected failure.

Your code lives in the business layer/object.  In one prg you call all of
that functionality one at a time to make sure it works, as expected.  If a
function receives a date as a parameter, pass in a bad date to validate it
doesn't work.

Over the life of your app as changes are made this is an easy way to see if
a change made effects anything else.

On Wed, Jul 22, 2020 at 1:35 AM Christof Wollenhaupt <
chris...@wollenhaupt.org> wrote:

> >
> > To make an unit test in VFP is as easy as anything:
> > just write your code, highlight it, activate the shortcut (right mouse
> > click), select the option 'Execute the selection'.  A very neat and quick
> > solution.
>
> It's even quicker if you use FoxUnit and foxmock. Both are free on VFPX.
> I've hundreds of unit tests that I can run with a single key stroke that
> test many different modules of our applications. Writing testable code also
> tends to lead to a cleaner class design that is more reusable.
>
> --
> Christof
>
>
>
> --- 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: 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 message: 
https://leafe.com/archives/byMID/CAJidMYLPei_L4HiWygOQP+biHD8=vtpgrw9cz5bc1lkzx78...@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: Unit tests (was Re: [NF] I will .....)

[Stephen Russell]

Why not?

Design by Test.  You create your functionality in TESTS and then use those
functions in a UI.

On Tue, Jul 21, 2020 at 5:53 PM MB Software Solutions, LLC <
mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote:

> I would wager that less than 5% of devs (in VFP anyway) have unit tests
> in their solution setup.
>
>
> On 7/21/2020 10:04 AM, Johan Nel wrote:
> > Ah my child, I have to confess I have never in my complete development
> > career had a plan or unit test done...
> >
> > On 2020/07/21 15:13, Eric Selje wrote:
> >> Forgive me father, for I have started coding without having a plan or
> >> even
> >> a unit test written first. It's been 51 years since my last confession.
> >>
> >> On Sat, Jul 18, 2020 at 1:57 PM Dennis Schuette 
> >> wrote:
> >>
> >>> That's such an easy change, I won't even bill you for it.
> >>>
> >>> 1 hour of programming, 5 hours of debugging, and 3 customer requested
> >>> enhancements later, I'm almost done!
> >>>
> >>> Customized Business Services, LLC (928) 580-6352
> >>> Dennis Schuette Primary:
> >>> den...@cbsds.com
> >>> 49 NW 130 Avenue Alternate:
> >>> schuette.den...@gmail.com
> >>> Great Bend, KS  67530
> >>>
> >>> -Original Message-
> >>> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
> >>> Stephen Russell
> >>> Sent: Friday, July 17, 2020 11:06 AM
> >>> To: profoxt...@leafe.com
> >>> Subject: [NF] I will .
> >>>
> >>> Alright, I'm not a priest, but I am a programmer.
> >>>
> >>> Confess to me your programming sins, and I shall absolve you.
> >>>
> >>>
> >>>
> >>> --
> >>> Stephen Russell
> >>> Sr. Analyst
> >>> Ring Container Technology
> >>> Oakland TN
> >>>
> >>> 901.246-0159 cell
> >>>
> >>>
> >>> --- 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: 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 message: 
https://leafe.com/archives/byMID/CAJidMYKGk81Ui6bu2Tmk2cW=myz8wjjqcutpi3h_mf_+urb...@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: We are only as good as we are informed!

[Stephen Russell]

Is this an I intend to behave differently than what was coded 10+ years ago?

On Mon, Jul 20, 2020 at 9:58 AM MB Software Solutions, LLC <
mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote:

> Had a client complain about issues in their system that happened over a
> month ago.
>
> WHERE'S THE NOTIFICATION?  Yes, I can stop the bleeding, but if you're
> not communicating issues to me, I can't be expected to know everything
> that's going on.
>
> There's that old saying: "The problem is communication, but that goes
> without saying."  ;-)
>
> Anybody else have stories like this?
>
>
> --
> 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: 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 message: 
https://leafe.com/archives/byMID/cajidmy+4xdoxuuts_mxwuouwqfpmrf0kff9kzgyj0firtkr...@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: [NF] I will .....

[Stephen Russell]

Playing with the snake?  Not good.

On Fri, Jul 17, 2020 at 2:22 PM John Weller  wrote:

> I have been unfaithful to my true love - I have been dabbling with Python
> and SQLite. I wish you could get FoxPro on a Raspberry Pi.
>
> John Weller
> 01380 723235
> 079763 93631
> Sent from my iPad
>
> > On 17 Jul 2020, at 17:07, Stephen Russell  wrote:
> >
> > Alright, I'm not a priest, but I am a programmer.
> >
> > Confess to me your programming sins, and I shall absolve you.
> >
> >
> >
> > --
> > Stephen Russell
> > Sr. Analyst
> > Ring Container Technology
> > Oakland TN
> >
> > 901.246-0159 cell
> >
> >
> > --- 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: 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 message: 
https://leafe.com/archives/byMID/CAJidMYKmLS7NJd_Y_YmhOr+HtTjwXrEXRa=sg5gua-pmlxa...@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.

[NF] I will .....

[Stephen Russell]

Alright, I'm not a priest, but I am a programmer.

Confess to me your programming sins, and I shall absolve you.



-- 
Stephen Russell
Sr. Analyst
Ring Container Technology
Oakland TN

901.246-0159 cell


--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

___
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 message: 
https://leafe.com/archives/byMID/cajidmylfjoxgnyxz0vqqyqqrao5kl81tfnjd1ss3fkshh7e...@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.

[NF] Are they watching you?

[Stephen Russell]

https://appleinsider.com/articles/20/07/15/google-sued-for-blatant-lies-about-user-privacy



-- 
Stephen Russell
Sr. Analyst
Ring Container Technology
Oakland TN

901.246-0159 cell


--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

___
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 message: 
https://leafe.com/archives/byMID/CAJidMYJ8TTmbKFMp=HiDr=ovubapyd4tqklbjqshqnr14ro...@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.

[NF] Less Filling or Tastes Great?

[Stephen Russell]

https://www.youtube.com/watch?v=5ycx9hFGHog

-- 
Stephen Russell
Sr. Analyst
Ring Container Technology
Oakland TN

901.246-0159 cell


--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

___
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 message: 
https://leafe.com/archives/byMID/cajidmyl7zc5kzts8jw02u42khvm1_kosseguddqaufj7yp+...@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: [NF] Suggestions for DBA tools for MariaDB?

[Stephen Russell]

Why will you have to go to Enterprise?  We are dumping enterprise on 3
servers with 13 instances and hundreds of dbs.  Only keeping one server for
BI capabilities.  Saving us around 650K in licensing.

Why do you need to push to Ent?

On Fri, Jul 10, 2020 at 12:06 PM Vince Teachout  wrote:

> On 07/10/20 11:12 AM, MB Software Solutions, LLC wrote:
> > SQLYog is my go-to beyond HeidiSQL.  Admittedly, I just use SQLYog for
> > schema comparison and automatic update SQL generation to get things in
> > sync.
> >
> > Curious -- why dump SQL Server?  Costs???
>
> Yes, costs.   We'll be required to use Enterprise edition when we
> migrate. 
>
>
>
> --
> 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: 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 message: 
https://leafe.com/archives/byMID/CAJidMYJgbVE0xp+rMEH=cly2+v7_5jnysofvm09_fybulny...@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: AZURE and VFP

[Stephen Russell]

Azure is fairly feature rich with respect to what kind of VM you want to
deploy.  Windows of Linux many flavors of each and you can add on disk
space as you see fit.  Want to reduce your costs, place that VM in a
cheaper area of the world compared to USA East coast.

I am working on certifications with Azure now as wanting to learn
something new in the COVID time frame.  They are much better today at
stating costs for your decisions then you get the bill with that shopper of
a line item.  Just like AWS allowing you to do everything Windows, Azure
allows you to do everything Linux.

.NET Core 3 is now out.  That is writing code to run in a non windows or a
windows environment.

On Sat, Jun 27, 2020 at 10:04 AM Alan Bourke 
wrote:

>
> Apparently it is possible to use the 'Azure Files' type of storage to
> provide a cloud-based shared folder that on-premise Windows can access, map
> a drive letter to and so forth.
>
> It is also apparently possible to then run an EXE off that share as long
> as you are using SMB3, so Windows 8 and up. However I would envision a
> potential world of hurt with permissions and so on.
>
> If the data is in Azure SQL this is really a job for a browser-based front
> end. Maybe you could knock something up in a low-code tool like PowerApps
> to do it.
>
>
>
> --
>   Alan Bourke
>   alanpbourke (at) fastmail (dot) fm
>
[excessive quoting removed by server]

___
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 message: 
https://leafe.com/archives/byMID/cajidmylnowc4nwf2vqx0kkdxhbthbopvqzqdke+hm5k5qof...@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: Greg Reichert / GLRsoftware.com

[Stephen Russell]

I use the WayBackMachine in times like this.  archive.org that is.  :)

https://web.archive.org/web/20111012092251/http://www.glrsoftware.com/index.asp




On Wed, Jun 24, 2020 at 4:24 AM Jürgen Wondzinski 
wrote:

> Anybody knows what happened with Greg Reichert and his domain
> glrsoftware.com?
> He had some very nifty VFP code parts there. I'm looking for his SysObj
> class; because I have only a damaged zip from that ☹
>
> wOOdy
>
>
[excessive quoting removed by server]

___
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 message: 
https://leafe.com/archives/byMID/CAJidMY+jS_v1g7aK-BS7e_-7EARa=EQmD9JtRS=yoptdq5k...@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: SQLite

[Stephen Russell]

SQLite is not an RDMS.  It isn't always on via an API like what you and I
are familiar with.  Each request is a new connection to the same db file.
It can be used on very light machines like a raspberry PI.

On Tue, Jun 23, 2020 at 12:36 PM MB Software Solutions, LLC <
mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote:

> Just curious--given what you said, why wouldn't you just go to MariaDB
> right away then, skipping SQLite?
>
>
> On 6/23/2020 11:48 AM, Vince Teachout wrote:
> > On 06/23/20 10:18 AM, John Weller wrote:
> >> Has anyone used SQLite with VFP?  I have always used DBFs as it seemed
> >> over-kill to use SQL Server for the small membership databases I've been
> >> using (2000 records) however I was introduced to SQLite as part of a
> >> Python
> >> course so thought I'd give it a try with VFP.
> >
> > I played with it a bit, and am considering porting my small, ancient
> > billing program over to it.
> >
> > I found it easy to use, although the limited data types annoys me, and
> > the right there out in the open database files worry me a bit.
> >
> > But it seems to work well, it's easy to use, and bonus, there are
> > actual ODBC drivers for it.  Not that your really need it, but then
> > you could do views, etc.
> >
> >
> >
>
> --
> 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: 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 message: 
https://leafe.com/archives/byMID/cajidmyj4udzomdap8xbbhpszuwig6duhsqj-bz+rzm5+pn_...@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: Populating Microsoft Outlook address book using a list of emails from a CSV file

[Stephen Russell]

Can you import a list cab style still?  I use to do it back in the day.

On Wed, May 27, 2020 at 3:03 PM MB Software Solutions, LLC <
mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote:

> Customer wants to pre-seed his Outlook contacts with a CSV list to save
> him time later when actually emailing these people for the first time.
>
> Haven't dove into this yet but wanted to throw it out to the group in
> case someone has already "been there, done that, here's the plan."
>
> tia!
> --Mike
>
>
>
[excessive quoting removed by server]

___
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 message: 
https://leafe.com/archives/byMID/CAJidMYJ1Pahk9xfD33eHtS=zxvfscibtbs27b-ktjzaiaqy...@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 Shared Management Objects (SMO)

[Stephen Russell]

Sorry and thanks.  Just using SMO, you need to know that to do anything.

On Fri, May 1, 2020 at 4:01 AM Alan Bourke  wrote:

> On Thu, 30 Apr 2020, at 5:11 PM, Stephen Russell wrote:
> > What do you want to do through SMO?
>
> It's actually Paul Newton who has the requirement, which is to discover
> SQL Server instances on the network.
>
> --
>   Alan Bourke
>   alanpbourke (at) fastmail (dot) fm
>
[excessive quoting removed by server]

___
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 message: 
https://leafe.com/archives/byMID/cajidmy+zy6stfpnbnxbwb05h5mwcipbjr9ujxqlwxwo4cad...@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 Shared Management Objects (SMO)

[Stephen Russell]

What do you want to do through SMO?

On Thu, Apr 30, 2020 at 10:38 AM Alan Bourke 
wrote:

> On Thu, 30 Apr 2020, at 4:16 PM, Stephen Russell wrote:
> > What SMO does for you is also available via powershell.  Because I have
> the
> > app written I don't work much in powershell for SQL Server analysis.
>
> Steven
>
> Yes indeed although leveraging Powershell as part of an EXE distributed to
> end users brings its own challenges  - you would need to #Require SqlServer
> probably and things like that.
>
> --
>   Alan Bourke
>   alanpbourke (at) fastmail (dot) fm
>
[excessive quoting removed by server]

___
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 message: 
https://leafe.com/archives/byMID/CAJidMYKiQ1Z0UqjKf_i9s9U874udfXbVZtBKDM=3nqr+uvl...@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 Shared Management Objects (SMO)

[Stephen Russell]

What SMO does for you is also available via powershell.  Because I have the
app written I don't work much in powershell for SQL Server analysis.

On Thu, Apr 30, 2020 at 2:58 AM Alan Bourke  wrote:

>
> Paul
>
> There is no COM interface to SQL-SMO, so you would have to create a .NET
> assembly with a COM-callable wrapper exposing the functions you want I
> think. Or even just a .NET EXE which dumps any results to a text file that
> the vfp SIDE CAN READ.
>
>
> --
>   Alan Bourke
>   alanpbourke (at) fastmail (dot) fm
>
>
[excessive quoting removed by server]

___
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 message: 
https://leafe.com/archives/byMID/CAJidMYKpNkr3KximA9hqXzBfjzOqU7-PBkCNewks=3eipnw...@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 Shared Management Objects (SMO)

[Stephen Russell]

I have a huge application built in sometime 2009-10 for managing SQL Server
stored procedures as well as submitting standard daily statements to the
variety of servers and instances I manage.

I don't know if you are going to be able to create all of the container
objects that are necessary to work with this.

You have to define the server object you then can pass in SQL code to
execute, or go through the many aspects of objects within a server,
database, backups, stored procedures, UDF, email, etc.

I generate a string for my "code" that I want executed from my WinForms
client.

This is the deadlock count query string:

 case "Deadlock Count":
SQL.Append("select resource_database_id, d.name,
count(*) from sys.dm_tran_locks tl ");
 SQL.Append("left join sys.databases d on
tl.resource_database_id = d.database_id ");
 SQL.Append("group by resource_database_id, d.name
order by 3 desc");
break;

I have a control with a LOT of different code I want to operate.  User
clicks on Deadlock Count and uses this case statement to render the code
that will be run on the instance|database.

This is the code that does the actual run query and show results:
 try
{
DataSet ds = db.ExecuteWithResults(sql);
dgResult.DataSource = ds.Tables[0];

}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "This was the error you
experienced");

}

There are many different types of queries that the db can perform, in this
case I want the result set that I am placing in my grid on the form.



On Wed, Apr 29, 2020 at 10:58 AM Tracy Pearson 
wrote:

> The COM object you are creating is named "sqlSMO", are you sure this isn't
> already the object you are looking for?
>
> Tracy
>
> -Original Message-
> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Paul
> Newton
> Sent: Wednesday, April 29, 2020 11:56 AM
> To: profoxt...@leafe.com
> Subject: SQL Server Shared Management Objects (SMO)
>
> Hi all
>
> We have been using the following to get a list of available servers
> loDMO = CreateObject("sqlSMO.Application")
> loServerList = loDMO.ListAvailableSQLServers
>
> However SQL-DMO was apparently deprecated with SQL Server 2005 and
> succeeded
> by SQL-SMO.  Has anybody used SQL Server Shared Management Objects in VFP
> and, if so, can they please give me some pointers on what I need to install
> and how to implement code to replace that above.  Many thanks
>
> Paul Newton
>
>
> --- 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: 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 message: 
https://leafe.com/archives/byMID/CAJidMYKgXEjZw5cb9SjxX-e5WJ9O=kos9gpjdntm+ukxemu...@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: File sharing services

[Stephen Russell]

You could write your own api to publish to your customers' use.  I write
apis that move data and not files.  Maybe you could create the API that was
able to publish a file list from a secured folder and then a second one to
receive a check list that identifies what documents they want to receive?

On Thu, Apr 23, 2020 at 3:52 PM Richard Kaye  wrote:

> Calling on the collective wisdom. What are people using th4eses days to
> share files with customers beside Dropbox? Preferably something that can be
> accessed via APIs.
>
> TIA
>
> --
>
> rk
>
>
>
> --- 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: 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 message: 
https://leafe.com/archives/byMID/CAJidMYLEjEmR97YaEQnWKua5E02aBtDpXQ=q7smz2i_pjab...@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: Decompile FoxPro Windows 2.6?

[Stephen Russell]

Reporting was a PITA as I remember.

On Thu, Apr 23, 2020 at 9:06 AM Roger Tremblay  wrote:

> I have used dosbox and it works very well when needing to run or compile
> old
> programs
>
>
> -Original Message-
> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Alan
> Bourke
> Sent: Thursday, April 23, 2020 10:03 AM
> To: profoxt...@leafe.com
> Subject: Re: Decompile FoxPro Windows 2.6?
>
> ReFox.
>
> Or install Windows 3.11 in DosBox and then run it on that.
>
> Or buy a PC )or set up a VM) with 32-bit Windows 10 and run it on that.
>
> :)
>
> --
>   Alan Bourke
>   alanpbourke (at) fastmail (dot) fm
>
[excessive quoting removed by server]

___
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 message: 
https://leafe.com/archives/byMID/cajidmyl65gv1qhwzybp3mfmp5+qb1n0fyy1svkq8_lokkqd...@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: Office automation using VFP 10 64-bit version

[Stephen Russell]

Consider making the root of the XLM object singular, such as Customer with
List as an element of it?

On Tue, Apr 21, 2020 at 3:15 PM Tracy Pearson  wrote:

> For what I have been working on, it has been an Xml string that I can
> process to and from  a cursor with the XmlAdapter.
> In C# I can process it to and from a List.
> The XmlAdapter will nest related tables such as Orders and OrderItems and
> bring that back to VFP cursors from the Xml string that is returned.
> In C# it would be a List and has a List as one of the
> properties.
>
> You have more functions available to you in the COM object then the VFP
> OleDB Provider.
>
> -Original Message-
> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of MB
> Software Solutions, LLC
> Sent: Tuesday, April 21, 2020 3:47 PM
> To: profoxt...@leafe.com
> Subject: Re: Office automation using VFP 10 64-bit version
>
> What's the return type?  An object with all of the properties? I'm sure
> you're not returning single values for everything.
>
>
> On 4/21/2020 11:23 AM, Tracy Pearson wrote:
> > It could, but I just call methods in the COM object to get data.
> >
> > -Original Message-
> > From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of MB
> > Software Solutions, LLC
> > Sent: Tuesday, April 21, 2020 11:11 AM
> > To: profoxt...@leafe.com
> > Subject: Re: Office automation using VFP 10 64-bit version
> >
> > So the front end C# appit's referring to the VFP COM object
> > properties in its UI?
> >
> >
> > On 4/21/2020 11:04 AM, Tracy Pearson wrote:
> >> You can write a VFP COM object that holds the business logic, and data
> >> access, if you are still using VFP Tables and update the UI with a
> 64-bit
> >> WPF application. Or a Web project that accesses the VFP data of a VFP
> >> desktop application.
> >> The VFP COM object could call code in the VFP Desktop application.
> >>
> >>
> >> -Original Message-
> >> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of MB
> >> Software Solutions, LLC
> >> Sent: Tuesday, April 21, 2020 10:53 AM
> >> To: profoxt...@leafe.com
> >> Subject: Re: Office automation using VFP 10 64-bit version
> >>
> >> On 4/20/2020 9:15 AM, Tracy Pearson wrote:
> >>> You are able to use an OUT of process COM across the 64-bit & 32-bit
> >>> barrier. I showed this in my 2019 SWFox session.
> >>>
> >>> I was working with a 64-bit C# and accessing a VFP 9 SP 2 COM compiled
> as
> >> an
> >>> EXE.
> >>> Fun stuff.
> >> What's the benefit to 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: 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 message: 
https://leafe.com/archives/byMID/CAJidMY+G6Z8LRSfZZ_T2VQjwRgMB_J2dSRCdOWbHVetJc=o...@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: Office automation using VFP 10 64-bit version

[Stephen Russell]

You can now do this I bet.

https://www.youtube.com/watch?time_continue=522&v=j0ng2Tp01Hc&feature=emb_title


On Tue, Apr 21, 2020 at 9:54 AM MB Software Solutions, LLC <
mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote:

> On 4/20/2020 9:15 AM, Tracy Pearson wrote:
> > You are able to use an OUT of process COM across the 64-bit & 32-bit
> > barrier. I showed this in my 2019 SWFox session.
> >
> > I was working with a 64-bit C# and accessing a VFP 9 SP 2 COM compiled
> as an
> > EXE.
> > Fun stuff.
>
>
> What's the benefit to 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: 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 message: 
https://leafe.com/archives/byMID/cajidmyjpfq-e_2rbalgsfqtapthy6vso8xsyuc4tzy83mpa...@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: VFP6 and VFP9 Legacy Application Support Help

[Stephen Russell]

I have a friend at church and his company does the same thing as well as
salvage, repair OEM equipment that is available for use right away.

Sounds similar.

On Wed, Feb 5, 2020 at 10:29 AM Eric Selje  wrote:

> A second for WhiteLight. By procuring a company like Rick's rather than an
> individual you're much more likely to have continuity.
>
> I'm looking forward to hearing how many millions they end up spending
> trying to get an ERP solution to do what their current solution does before
> realizing they're wasting their money.
>
> Eric
>
>
> On Tue, Feb 4, 2020 at 12:34 PM MB Software Solutions, LLC <
> mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote:
>
> > Normally I would say volunteer (and I kinda still am) but I've been busy
> > recently so not much free time.  I use Rick Schummer's WhiteLight
> > Computing company to assist me with C#, WestWindWeb Connection, and
> > other work when needed.  I can't say enough good things about Rick and
> > his team.  I know I'm finally dealing with great respected professionals
> > (and not the posers I dealt with in the past).
> >
> >
> > On 2/4/2020 1:26 PM, Desmond Lloyd wrote:
> > > I had posted this a few months ago and had received several responses,
> > to
> > > those people I apologize for not getting back to you
> > >
> > > I support an application called Quick Aviation.  It is a VFP
> application
> > > based on SBT Accounting and designed for by Aerospace MRO shops.
> > > Essentially our customer sends a part for a jet engine and we will
> > > repair,   overhaul or test the part based upon  Similar to  ERP with
> the
> > > exception that we never know what parts will be needed.
> > >
> > > Quick Aviation was independently written and we bought the code.   As
> you
> > > can imagine there have been all sorts of enhancements and custom
> reports
> > > written.  Originally written for FoxPro for Windows it runs under VFP6,
> > > with a great deal of additional reports and "add-ons" being written in
> > VFP9.
> > >
> > > We have approximately 150 users on the system.  Being ran on a VMWare
> > > virtual server.
> > > We ship thousands of parts per month and typically have over 2,000
> orders
> > > in process.
> > >
> > > Since I am the only person supporting the application and we are part
> of
> > a
> > > very large aerospace concern,  management is concerned with it's
> > > "stability" and ability to grow with the business. (We all know there
> > > should be no issues with that!)  Also they want to insure that the
> > > application is fully is properly supported.
> > >
> > > Am not sure how this would be setup,  but I would envision having a
> > person
> > > available to provide support,   user requested enhancements and report
> > > writing.   Perhaps some sort of monthly fee with additional fees for
> > > completed projects.
> > >
> > > Not sure how long this would last,  management is eyeing one of the big
> > ERP
> > > packages.  Our users like Quick  Aviation .
> > >
> > > Would appreciate any additional feedback,  plus am interested as to how
> > > other organizations might handle this situation
> > >
> > > TIA,
> > > Desmond
> > >
> > >
> > > --- 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: 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 message: 
https://leafe.com/archives/byMID/cajidmy+my60im2pull0vc6gnycs2ov0z-ec7v2h-3febkze...@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: [NF] Madman runs .NET Core application on Windows 3.11

[Stephen Russell]

I have made a lot of different applications with C# over the past 18 years
and hands down .NET was superior to VB6.  VB6 was so much closer to Access
in how you created a project compared to .Net 1 & 2.  The positive steps
forward that M$ did in the .NET space since then make me laugh when you
condemn them and still use SW from Win 95-98 as the basis of your career.

Today you find that more of the developers in .NET are using open source
tools in their projects as a whole.  In Data I can write code in python vs
TSQL.  This is part of a 2020 project for upgrading our DW.





On Thu, Jan 23, 2020 at 3:55 AM Alan Bourke  wrote:

> Conversely a lot of stuff that was impractical or impossible in VB6 is
> trivial in .NET.
>
> And no it isn't worse than DLL hell, if you even half know what you're
> doing.
>
> --
>   Alan Bourke
>   alanpbourke (at) fastmail (dot) fm
>
[excessive quoting removed by server]

___
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 message: 
https://leafe.com/archives/byMID/CAJidMYLhvnss8CAs_-zMcaKpksNjWv3fmFipbwVCsqKvv=3...@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: [NF] Blazor from Microsoft

[Stephen Russell]

The way I saw it was Silverlte fixed.

You can get a server stack in NIX that you can maintain and control.

There is a missing part to the mix as of last Nov.  I can't remember what
component that was but it was semi baked as of then.

On Mon, Jan 20, 2020 at 5:36 PM MB Software Solutions, LLC <
mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote:

> Just saw a mention of Blazor today in a Code Magazine email ad. Never
> heard of it. https://dotnet.microsoft.com/apps/aspnet/web-apps/blazor
>
> Anybody heard of it and can comment their thoughts on it?  Is it better
> than using JavaScript?  That's the first impression I get that they're
> saying from their marketing.
>
>
[excessive quoting removed by server]

___
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 message: 
https://leafe.com/archives/byMID/cajidmy+jb1ey3z_9hf_3yetgzoxt4uzmyjrjddomkyw0me5...@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: The Y2K Bug Returns: Revenge of the Kludge

[Stephen Russell]

One that no longer works here.

It was their attempt to hide the date of the mfg in labels we place on
EVERYTHING.  Actually they now work for the ERP company we use.  He was a
great cost accountant, not a good systems guy.

On Wed, Jan 8, 2020 at 10:45 AM MB Software Solutions, LLC <
mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote:

> What kind of a**hole uses just ONE digit for a year?!?!?
>
> On 1/8/2020 11:35 AM, Stephen Russell wrote:
> > We got bit with a lot of hard coded functionality on our Lot #s because
> of
> > our use of a 1 digit year.  That was started in 2011 and nobody thought
> of
> > an foul at 2020.
> >
> > ASNs to customers, MFG date on CofAs all fell under my control.  Happy
> > happy joy joy.
> >
> > On Wed, Jan 8, 2020 at 10:11 AM Ted Roche  wrote:
> >
> >> If you
> >>
> >> SET CENTURY ON
> >> SET CENTURY TO 19 ROLLOVER 20
> >>
> >> this is reminder it might be a good time to review the implications of
> that
> >> :)
> >>
> >>
> >>
> https://www.zdnet.com/article/the-y2k-bug-is-back-causing-headaches-for-developers-again/
> >>
> >> https://hackfox.github.io/section4/s4g035.html
> >>
> >> --
> >> Ted Roche
> >> Ted Roche & Associates, LLC
> >> http://www.tedroche.com
> >>
> >>
> >> --- 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: 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 message: 
https://leafe.com/archives/byMID/cajidmy+o7olh6u3n3_apdjng7buyq7pxwwhcqrdhcuuehnh...@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: The Y2K Bug Returns: Revenge of the Kludge

[Stephen Russell]

We got bit with a lot of hard coded functionality on our Lot #s because of
our use of a 1 digit year.  That was started in 2011 and nobody thought of
an foul at 2020.

ASNs to customers, MFG date on CofAs all fell under my control.  Happy
happy joy joy.

On Wed, Jan 8, 2020 at 10:11 AM Ted Roche  wrote:

> If you
>
> SET CENTURY ON
> SET CENTURY TO 19 ROLLOVER 20
>
> this is reminder it might be a good time to review the implications of that
> :)
>
>
> https://www.zdnet.com/article/the-y2k-bug-is-back-causing-headaches-for-developers-again/
>
> https://hackfox.github.io/section4/s4g035.html
>
> --
> Ted Roche
> Ted Roche & Associates, LLC
> http://www.tedroche.com
>
>
> --- 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: 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 message: 
https://leafe.com/archives/byMID/CAJidMYJM-FhkRVcWVyAJT40NsRW4RgxiSrJnLWzn729HU=p...@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: [NF] VFP function list status in X#

[Stephen Russell]

When I glanced over the functions it seems to me that you cannot have any
non VFP data.  All of the SQL query, insert, update delete was not
applicable.

Or was ai multitasking on it when I glanced at it?

On Tue, Dec 10, 2019 at 11:51 AM Matt Slay 
wrote:

> MB Software Solutions - I feel the same exact way about Scatter/Gather.
>
> To me, these two command are at the same level as the FoxPro SQL syntax
> and SqlExec(), both of which are also Not implemented yet.
>
> At this point with X#.VFP, there is sort of an all-or-nothing bar they
> have to hit before any further testing or consideration can be
> justified. And that's just at the language level... not to mention the
> UI piece which alone will be a huge wall given the proposed FoxPro.SCX -
> to WinForms transformation.
>
> I posted your reply to the XSharp board so the X# Dev Team can see your
> comment:
>
>
> https://www.xsharp.info/forum/public-vfp/1651-foxpro-function-list-updated#12152
>
>
>
> *Matt Slay*, President
> Jordan Machine Co.
> 355 Clow Lane
> PO Box 170339
> Birmingham, AL 35217
> Ph: 205-849-5050
> Fx: 205-849-5075
> matts...@jordanmachine.com 
> http://www.JordanMachine.com
>
>
>
> On 12/10/2019 9:38 AM, MB Software Solutions, LLC wrote:
> > Thanks for that.  The one that caught my eye is SCATTER/GATHER not
> > (yet) supported.  I used those commands in everything I do in my VFP
> > apps, especially in single record Add/Edit screens.  My objects have a
> > controlsource like "thisform.oRecord.MyField" which gets populated via
> > something like:
> >
> > DO FORM frmEditRecord NAME loFrm NOSHOW
> > SELECT MyTable
> > SCATTER MEMO NAME loFrm.oRecord
> > loFrm.Show()
> >
> > IF loFrm.lSaveChanges THEN
> > thisform.obiz.UpdateRecord(loFrm.oRecord)
> > ENDIF
> >
> > IF VARTYPE(loFrm) = "O" THEN
> > loFrm.release()
> > ENDIF
> >
> >
> > On 12/10/2019 1:21 AM, Johan Nel wrote:
> >> Hi all,
> >>
> >> A list of the current status of VFP function/procedure support was
> >> published on the X# website.
> >>
> >> https://www.xsharp.info/itm-help/foxpro-compatibility-list
> >>
> >> Hope this is of interest to most.
> >>
> >> Johan Nel
> >> George, South Africa.
> >>
> >>
[excessive quoting removed by server]

___
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 message: 
https://leafe.com/archives/byMID/cajidmyldchyzc9mmporvpghzr11rhh-j58fuswuxp9bvp+v...@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 Dump

[Stephen Russell]

That sounds like an ETL job that I would set up in SSIS

There are plenty of youtube vids on this.

We use SSIS to extract data from our ERP database nightly for inclusion in
the data warehouse and then for our data marts.


On Sat, Nov 30, 2019 at 1:52 PM Chris Davis  wrote:

> Thanks everyone for all the ideas and advice, I will give them a try.
>
> Effectively what I am trying to create is a way to replicate a VFP DBC to
> a SQL Database daily.
>
> -Original Message-
> From: ProfoxTech  On Behalf Of Stephen
> Russell
> Sent: Friday, 29 November 2019 16:08
> To: profoxt...@leafe.com
> Subject: Re: SQL Dump
>
> What incorrect answers these were.
>
> IN the DB you made in SQL Server you can import the data at SSIS speed.
>
> Rt click on the DB in the DB pane.  Tasks and Import Data.
>
> >From there you tell it to use VFP data via your oledb engine.  From
> >there
> it will make all tables and indexes from VFP and import it very fast.
>
> Sorry I was driving when this was first posted.  You can Youtube SQL
> Server Import data and see a few different vids on how to do this.  The
> wizard has been around for decades and still does a great job of setting up
> what you need to do and allowing you to watch the process as it is cranking.
>
> Your single row inserts will waste a lot of energy updating the log for
> each row you inserted.  This skips that altogether.
>
>
>
> On Thu, Nov 28, 2019 at 10:55 AM Chris Davis 
> wrote:
>
> > Hi All
> >
> > Is there any tricks I am missing which would speed up a dump of a VFP
> > table into a SQL table.
> >
> > I have predifined by SQL statement something like this
> >
> > "insert into mytable (myfield) values (?m.myfield)"
> >
> > I am then scanning through the VFP table performing a scatter memvar
> > and then executing the SQL.
> >
> > It works it just seems to take alot longer than I imagined it would.
> >
> > Thanks IA
> >
> > Chris.
> >
> >
> > --- 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: 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 message: 
https://leafe.com/archives/byMID/CAJidMYLkLiY07K-GCWrvCgg=tvQ-12PvMMDe=r0vyxrcfou...@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 Dump

[Stephen Russell]

What incorrect answers these were.

IN the DB you made in SQL Server you can import the data at SSIS speed.

Rt click on the DB in the DB pane.  Tasks and Import Data.

>From there you tell it to use VFP data via your oledb engine.  From there
it will make all tables and indexes from VFP and import it very fast.

Sorry I was driving when this was first posted.  You can Youtube SQL Server
Import data and see a few different vids on how to do this.  The wizard has
been around for decades and still does a great job of setting up what you
need to do and allowing you to watch the process as it is cranking.

Your single row inserts will waste a lot of energy updating the log for
each row you inserted.  This skips that altogether.



On Thu, Nov 28, 2019 at 10:55 AM Chris Davis  wrote:

> Hi All
>
> Is there any tricks I am missing which would speed up a dump of a VFP
> table into a SQL table.
>
> I have predifined by SQL statement something like this
>
> "insert into mytable (myfield) values (?m.myfield)"
>
> I am then scanning through the VFP table performing a scatter memvar and
> then executing the SQL.
>
> It works it just seems to take alot longer than I imagined it would.
>
> Thanks IA
>
> Chris.
>
>
> --- 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: 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 message: 
https://leafe.com/archives/byMID/CAJidMYKnHFsyFqmQGNn36dmBkjFXnyLiUzBuQCmqa=fayws...@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: X# code for drag and drop

[Stephen Russell]

Yes today you can get a free version of just about every dev tool that M$
makes with only a few hold backs separating it from the pay version.

On Wed, Nov 20, 2019 at 3:19 PM MB Software Solutions, LLC <
mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote:

> On 11/19/2019 8:13 AM, Alan Bourke wrote:
> > There's no need to be pirating any of the MS dev tools these days,
> especially for learning.
> >
>
> Agreed!  Aren't most of them free now?
>
>
[excessive quoting removed by server]

___
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 message: 
https://leafe.com/archives/byMID/CAJidMYK4GLKh1Nrko-=hrfqh+f2jserh_tmqj+uqfrd_day...@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: File Sync

[Stephen Russell]

Power shell scripts out there are easy to find. Just a thought.

On Wed, Nov 20, 2019 at 9:39 AM Chris Davis  wrote:

> Can anyone recommend a free and simple file syncing program to mirror a
> folder on a server to a local folder (files and subfolders).
>
> I had been using freefilesync / robocopy but struggling with both of these
> on one particular computer and want to try another such utility to see if
> it gives me a better idea of what the issue is.
>
> Thanks
>
> Chris.
>
>
> --- 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: 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 message: 
https://leafe.com/archives/byMID/CAJidMYKuvgOVYESv1D5=teaa9z8khnmjlk-zogsbjz8tpwk...@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: X# code for drag and drop

[Stephen Russell]

Back they M$ gave the codes out in India allowing them to install and
learn.  Co-workers at St. Jude said that as recent transplants to America.

On Fri, Nov 15, 2019 at 10:52 AM MB Software Solutions, LLC <
mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote:

> I thought you said INDIA, not CHINA.Do they pirate software in
> India too?  I knew China was bad.
>
> On 11/15/2019 3:07 AM, AndyHC wrote:
> >
> > It would be whatever they can get for <$10 and make 50 copies of -
> > So probably VB.Net from Visual Studio Express?
> > BUT it may well be VB6
> >
> > On 14-Nov-2019 7:47 PM, MB Software Solutions, LLC wrote:
> >> Andy -- Is that VB.Net or VB6?  lol
> >>
> >>
> > 
> >
[excessive quoting removed by server]

___
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 message: 
https://leafe.com/archives/byMID/CAJidMYLX1aJ2CuxrOKidyjLi9hYh=h7tdspjamwyf+dy0bq...@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: X# code for drag and drop

[Stephen Russell]

It was 15.  I was working with it and C# then doing a web app for a truck
parts OEM company.  Instead of printing books, we were presenting them or
the idea of picking the correct PTO for your transmission and your needs.
Books were generated from a VFP app that was the property of the company
that sold this unit to another owner.



On Thu, Nov 14, 2019 at 9:44 AM MB Software Solutions, LLC <
mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote:

> Um, was VB.NET even around 20 years ago?  I think not.
>
> #FakeNews
>
>
> On 11/14/2019 10:15 AM, Stephen Russell wrote:
> > I asked my BI Architect who is from India and he said VB.NET was the
> rage
> > 15-20 years ago before he moved here.
> >
> >
> > On Thu, Nov 14, 2019 at 8:18 AM MB Software Solutions, LLC <
> > mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote:
> >
> >> Andy -- Is that VB.Net or VB6?  lol
> >>
> >>
> >> On 11/14/2019 6:32 AM, AndyHC wrote:
> >>> Never mind X# - or C# for that matter - today's paper here in India
> >>> proudly reports that lower-school students are being grounded in
> >>> Visual Basic and HTML programming languages, senior students are
> >>> taught the basics of Java and C.
> >>>
> >>> In other News, the Gates Foundation is spending a fortune supporting
> >>> technical advancement in India.
> >>>
> >>> just sayin'
> >>>
> >>> On 13-Nov-2019 2:28 AM, Stephen Russell wrote:
> >>>> Not sure if you want to implement X# or not.  If you do, this is code
> to
> >>>> drag text into a listbox.
> >>>>
> >>>>
> >>
> https://www.codeproject.com/Articles/874005/WPF-Window-Allows-Tabbing-by-Drag-and-Drop
> >>>>
> >>>>
> >>>>
> >>>
[excessive quoting removed by server]

___
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 message: 
https://leafe.com/archives/byMID/cajidmy+j0kcwup+brfdk9zos7em-wqcj_+_vy79b0iet2hu...@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: X# code for drag and drop

[Stephen Russell]

I asked my BI Architect who is from India and he said VB.NET was the rage
15-20 years ago before he moved here.


On Thu, Nov 14, 2019 at 8:18 AM MB Software Solutions, LLC <
mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote:

> Andy -- Is that VB.Net or VB6?  lol
>
>
> On 11/14/2019 6:32 AM, AndyHC wrote:
> > Never mind X# - or C# for that matter - today's paper here in India
> > proudly reports that lower-school students are being grounded in
> > Visual Basic and HTML programming languages, senior students are
> > taught the basics of Java and C.
> >
> > In other News, the Gates Foundation is spending a fortune supporting
> > technical advancement in India.
> >
> > just sayin'
> >
> > On 13-Nov-2019 2:28 AM, Stephen Russell wrote:
> >> Not sure if you want to implement X# or not.  If you do, this is code to
> >> drag text into a listbox.
> >>
> >>
> https://www.codeproject.com/Articles/874005/WPF-Window-Allows-Tabbing-by-Drag-and-Drop
> >>
> >>
> >>
> >>
> >
> >
[excessive quoting removed by server]

___
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 message: 
https://leafe.com/archives/byMID/CAJidMYK03TfUSFSCfNrU1zjyzO=nrzt+skuze00-e72fcme...@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.

joke

[Stephen Russell]

What do you call a programmer's second autobiography?
[image: ✍️]
MySQL.

-- 
Stephen Russell
Sr. Analyst
Ring Container Technology
Oakland TN

901.246-0159 cell


--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

___
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 message: 
https://leafe.com/archives/byMID/cajidmyktabtctgiftaj9hqix1ekskerwa8baecn033t8cz_...@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.