Re: [NF] What would you miss from VFP, when migrating
Hi John, It is in the to-do list... On 2019/06/27 22:45, John Weller wrote: I think I would miss SCAN/ENDSCAN most. John John Weller 01380 723235 07976 393631 [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/087b6544-b713-b2ce-f99b-d38ca8da7...@xsinet.co.za ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] What would you miss from VFP, when migrating
The philosophy is that you have a function that is called and if you have: TEXT TO mVar ENDTEXT Internally it translate to: mVar := __TextWhatEver() So the function internally will handled based on the parameter list what needs to be done to the string. On 2019/06/27 21:43, Stephen Russell wrote: Am I missing something about TEXT/ENDTEXT where it just mashes up a string for you for whatever transpires within the loop? What do you do with that output or the textmerge when you are done with it? On Thu, Jun 27, 2019 at 10:09 AM MB Software Solutions, LLC < mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote: Steve Ellenoff and I were talking the other day about the beauty of TEXTMERGE (TEXT/ENDTEXT) and iirc he indicated that wasn't in DotNet (or earlier versions anyway). I use TEXT/ENDTEXT *HEAVILY* in code often. On 6/27/2019 8:51 AM, Johan Nel wrote: Hi VFPers I have asked this question on foxite too with very little feedback, so I am asking it here too. If you have to summarize the 1 or 2 features of VFP that you will feel is a step backwards when migrating to .NET or any other platform as a move forwards. Looking forward to your replies. Two things that was highlighted on Foxite: 1. Macro-compilation 2. Evaluate(
Re: [NF] What would you miss from VFP, when migrating
On 6/27/2019 6:39 PM, Paul H. Tarver wrote: Give me a little credit for being a better programmer than that. C'mon, Paul -- it's mega-million$ $teve we're talking about here. Mr. Deep Pockets with SQL Server blinders on usually with only Stored Procedures being the only viable safe option. lol --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/bbeed1f1-8a1d-5abc-ba83-cc8d62a4d...@mbsoftwaresolutions.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: [NF] What would you miss from VFP, when migrating
Only if I were trying to destroy my clients and my livelihood. Give me a little credit for being a better programmer than that. Paul H. Tarver -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Stephen Russell Sent: Thursday, June 27, 2019 5:02 PM To: profoxt...@leafe.com Subject: Re: [NF] What would you miss from VFP, when migrating just put this into your textbox that gets passed back: 1=1 ; Drop table customers go On Thu, Jun 27, 2019 at 3:54 PM Paul H. Tarver wrote: > I meant "dynamic" in the sense of controlling variables in SELECT WHERE > statements. Didn't intent to scare anyone. > > Paul H. Tarver > > > -Original Message- > From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of > Stephen > Russell > Sent: Thursday, June 27, 2019 3:17 PM > To: profoxt...@leafe.com > Subject: Re: [NF] What would you miss from VFP, when migrating > > As a dba that scares the shit out of me. Just being honest about dynamic > statements and hackers who might know how to mess with you. > > This fear is real. > > https://codecurmudgeon.com/wp/sql-injection-hall-of-shame/ > > > > On Thu, Jun 27, 2019 at 3:10 PM Paul H. Tarver wrote: > > > I use TEXT/ENDTEXT to create dynamic SQL Queries by merging static text > and > > dynamic variables, then pass the resulting string to SQLEXECUTE. Very > > convenient when creating large query strings. > > > > Paul H. Tarver > > > > > > -Original Message- > > From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of > > Stephen > > Russell > > Sent: Thursday, June 27, 2019 2:43 PM > > To: profoxt...@leafe.com > > Subject: Re: [NF] What would you miss from VFP, when migrating > > > > Am I missing something about TEXT/ENDTEXT where it just mashes up a > string > > for you for whatever transpires within the loop? > > > > What do you do with that output or the textmerge when you are done with > > it? > > > > On Thu, Jun 27, 2019 at 10:09 AM MB Software Solutions, LLC < > > mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote: > > > > > Steve Ellenoff and I were talking the other day about the beauty of > > > TEXTMERGE (TEXT/ENDTEXT) and iirc he indicated that wasn't in DotNet > (or > > > earlier versions anyway). I use TEXT/ENDTEXT *HEAVILY* in code often. > > > > > > > > > On 6/27/2019 8:51 AM, Johan Nel wrote: > > > > Hi VFPers > > > > > > > > I have asked this question on foxite too with very little feedback, > so > > > > I am asking it here too. > > > > > > > > If you have to summarize the 1 or 2 features of VFP that you will > feel > > > > is a step backwards when migrating to .NET or any other platform as a > > > > move forwards. > > > > > > > > Looking forward to your replies. > > > > > > > > Two things that was highlighted on Foxite: > > > > > > > > 1. Macro-compilation > > > > 2. Evaluate(
Re: [NF] What would you miss from VFP, when migrating
just put this into your textbox that gets passed back: 1=1 ; Drop table customers go On Thu, Jun 27, 2019 at 3:54 PM Paul H. Tarver wrote: > I meant "dynamic" in the sense of controlling variables in SELECT WHERE > statements. Didn't intent to scare anyone. > > Paul H. Tarver > > > -Original Message- > From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of > Stephen > Russell > Sent: Thursday, June 27, 2019 3:17 PM > To: profoxt...@leafe.com > Subject: Re: [NF] What would you miss from VFP, when migrating > > As a dba that scares the shit out of me. Just being honest about dynamic > statements and hackers who might know how to mess with you. > > This fear is real. > > https://codecurmudgeon.com/wp/sql-injection-hall-of-shame/ > > > > On Thu, Jun 27, 2019 at 3:10 PM Paul H. Tarver wrote: > > > I use TEXT/ENDTEXT to create dynamic SQL Queries by merging static text > and > > dynamic variables, then pass the resulting string to SQLEXECUTE. Very > > convenient when creating large query strings. > > > > Paul H. Tarver > > > > > > -Original Message- > > From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of > > Stephen > > Russell > > Sent: Thursday, June 27, 2019 2:43 PM > > To: profoxt...@leafe.com > > Subject: Re: [NF] What would you miss from VFP, when migrating > > > > Am I missing something about TEXT/ENDTEXT where it just mashes up a > string > > for you for whatever transpires within the loop? > > > > What do you do with that output or the textmerge when you are done with > > it? > > > > On Thu, Jun 27, 2019 at 10:09 AM MB Software Solutions, LLC < > > mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote: > > > > > Steve Ellenoff and I were talking the other day about the beauty of > > > TEXTMERGE (TEXT/ENDTEXT) and iirc he indicated that wasn't in DotNet > (or > > > earlier versions anyway). I use TEXT/ENDTEXT *HEAVILY* in code often. > > > > > > > > > On 6/27/2019 8:51 AM, Johan Nel wrote: > > > > Hi VFPers > > > > > > > > I have asked this question on foxite too with very little feedback, > so > > > > I am asking it here too. > > > > > > > > If you have to summarize the 1 or 2 features of VFP that you will > feel > > > > is a step backwards when migrating to .NET or any other platform as a > > > > move forwards. > > > > > > > > Looking forward to your replies. > > > > > > > > Two things that was highlighted on Foxite: > > > > > > > > 1. Macro-compilation > > > > 2. Evaluate(
RE: Odd build error when trying to create automation COM component; references drive/folder I don't have in Project Info/Servers tab
Mike, It looks to be stored in the project table. Reserved2. But it appears there is also other information there that may make editing that memo a challenge. Though, you can probably change the pj2 file created by FoxBin2Prg, then put it back to get the edit in place. HTH, Tracy -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard Kaye Sent: Thursday, June 27, 2019 5:42 PM To: profoxt...@leafe.com Subject: RE: Odd build error when trying to create automation COM component; references drive/folder I don't have in Project Info/Servers tab Did you try building with the recompile all option? Some rogue folder reference in a .h file? Pack the project? I know you said you searched but what tool did you use? Did you try searching the project using GoFish for that weird path? What is that class shown in your screencap and where does it come from? -- rk -Original Message- From: ProfoxTech On Behalf Of MB Software Solutions, LLC Sent: Thursday, June 27, 2019 5:30 PM To: profoxt...@leafe.com Subject: Odd build error when trying to create automation COM component; references drive/folder I don't have in Project Info/Servers tab Win7Pro 64-bit/VFP9SP2, building WestWind WebConnection Server file. Demo: https://www.screencast.com/t/Hz1rMjyo Building this EXE but it fails with error. Well, it still produces an EXE but it's like 10 KB (instead of its normal 5 MB) and of course doesn't work. The build complains of 3 missing XFRX graphics files but that's definitely not it. Seems to fail when it goes to register the Type Library and COM component. Typically, these reside in C:\AppFolder on the Testing/Production servers but I'm building them in E:\MyDev\MyClient\YadaYadaYada folder because that's where I took the source from the GitHub repository to edit and build it. I'm in Admin account, started VFP as Admin, so shouldn't be permissions issue. **Found this clue and I'm certain this is the problem: https://www.screencast.com/t/Y10rsIjO . For some reason, this says D:\WSAPPS\ and I don't have that folder. My fellow developer uses that tree structure with his dev machine but I don't. My D: drive is my CD drive. I develop on my E: drive. How do I get that value changed? I searched my source, including WCONNECT.h but no obvious things stand out. tia, --Mike [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/000401d52d31$f5a052f0$e0e0f8d0$@powerchurch.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Odd build error when trying to create automation COM component; references drive/folder I don't have in Project Info/Servers tab
Did you try building with the recompile all option? Some rogue folder reference in a .h file? Pack the project? I know you said you searched but what tool did you use? Did you try searching the project using GoFish for that weird path? What is that class shown in your screencap and where does it come from? -- rk -Original Message- From: ProfoxTech On Behalf Of MB Software Solutions, LLC Sent: Thursday, June 27, 2019 5:30 PM To: profoxt...@leafe.com Subject: Odd build error when trying to create automation COM component; references drive/folder I don't have in Project Info/Servers tab Win7Pro 64-bit/VFP9SP2, building WestWind WebConnection Server file. Demo: https://www.screencast.com/t/Hz1rMjyo Building this EXE but it fails with error. Well, it still produces an EXE but it's like 10 KB (instead of its normal 5 MB) and of course doesn't work. The build complains of 3 missing XFRX graphics files but that's definitely not it. Seems to fail when it goes to register the Type Library and COM component. Typically, these reside in C:\AppFolder on the Testing/Production servers but I'm building them in E:\MyDev\MyClient\YadaYadaYada folder because that's where I took the source from the GitHub repository to edit and build it. I'm in Admin account, started VFP as Admin, so shouldn't be permissions issue. **Found this clue and I'm certain this is the problem: https://www.screencast.com/t/Y10rsIjO . For some reason, this says D:\WSAPPS\ and I don't have that folder. My fellow developer uses that tree structure with his dev machine but I don't. My D: drive is my CD drive. I develop on my E: drive. How do I get that value changed? I searched my source, including WCONNECT.h but no obvious things stand out. tia, --Mike ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/bn6pr10mb1458e2d696a6ff24b8e2b5a9d2...@bn6pr10mb1458.namprd10.prod.outlook.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Odd build error when trying to create automation COM component; references drive/folder I don't have in Project Info/Servers tab
Win7Pro 64-bit/VFP9SP2, building WestWind WebConnection Server file. Demo: https://www.screencast.com/t/Hz1rMjyo Building this EXE but it fails with error. Well, it still produces an EXE but it's like 10 KB (instead of its normal 5 MB) and of course doesn't work. The build complains of 3 missing XFRX graphics files but that's definitely not it. Seems to fail when it goes to register the Type Library and COM component. Typically, these reside in C:\AppFolder on the Testing/Production servers but I'm building them in E:\MyDev\MyClient\YadaYadaYada folder because that's where I took the source from the GitHub repository to edit and build it. I'm in Admin account, started VFP as Admin, so shouldn't be permissions issue. **Found this clue and I'm certain this is the problem: https://www.screencast.com/t/Y10rsIjO . For some reason, this says D:\WSAPPS\ and I don't have that folder. My fellow developer uses that tree structure with his dev machine but I don't. My D: drive is my CD drive. I develop on my E: drive. How do I get that value changed? I searched my source, including WCONNECT.h but no obvious things stand out. tia, --Mike --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/09b9b494-5d2d-9f5a-9b42-2bd7db3de...@mbsoftwaresolutions.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Odd Error Message
Once had a network admin move everyone's "Documents" folder to a shared network path. Then didn't allow anyone to see the contents of the folder above it. \\Server\Share\{UserName} was how it was done. The user was able to put things in C:\Users\{UserName}\Documents and everything worked. So user couldn't write or see anything in the Share folder. But was allowed full access in their folder. Getting the SpecialFolder from windows and doing a "SET DEFAULT TO (cDocumentsFolder)" would throw "Invalid path or file name (Error 202)". Odd errors... Tracy -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Fletcher Johnson Sent: Thursday, June 27, 2019 4:37 PM To: profoxt...@leafe.com Subject: RE: Odd Error Message We did have a test to see if the temp folder existed. If it didn't we tried to create it. But it did exist. Given the purpose of the temp folder is to hold temporary data, we didn't bother with code to actually try to create a file, write to it, and then verify that it was written to. I mean, who would ever make a temporary folder read-only Anyway, once we figured it out, it was easy to fix. I don't know why VFP (I can't remember which version we were using) didn't complain about the problem - it's been too long. But I do know that our error handler did not get called and the code happily continued executing even though the write was not actually performed. We used both On Error as well as Try Catch when it was finally added. Fletcher ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/000301d52d2a$e8cfda70$ba6f8f50$@powerchurch.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: [NF] What would you miss from VFP, when migrating
I meant "dynamic" in the sense of controlling variables in SELECT WHERE statements. Didn't intent to scare anyone. Paul H. Tarver -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Stephen Russell Sent: Thursday, June 27, 2019 3:17 PM To: profoxt...@leafe.com Subject: Re: [NF] What would you miss from VFP, when migrating As a dba that scares the shit out of me. Just being honest about dynamic statements and hackers who might know how to mess with you. This fear is real. https://codecurmudgeon.com/wp/sql-injection-hall-of-shame/ On Thu, Jun 27, 2019 at 3:10 PM Paul H. Tarver wrote: > I use TEXT/ENDTEXT to create dynamic SQL Queries by merging static text and > dynamic variables, then pass the resulting string to SQLEXECUTE. Very > convenient when creating large query strings. > > Paul H. Tarver > > > -Original Message- > From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of > Stephen > Russell > Sent: Thursday, June 27, 2019 2:43 PM > To: profoxt...@leafe.com > Subject: Re: [NF] What would you miss from VFP, when migrating > > Am I missing something about TEXT/ENDTEXT where it just mashes up a string > for you for whatever transpires within the loop? > > What do you do with that output or the textmerge when you are done with > it? > > On Thu, Jun 27, 2019 at 10:09 AM MB Software Solutions, LLC < > mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote: > > > Steve Ellenoff and I were talking the other day about the beauty of > > TEXTMERGE (TEXT/ENDTEXT) and iirc he indicated that wasn't in DotNet (or > > earlier versions anyway). I use TEXT/ENDTEXT *HEAVILY* in code often. > > > > > > On 6/27/2019 8:51 AM, Johan Nel wrote: > > > Hi VFPers > > > > > > I have asked this question on foxite too with very little feedback, so > > > I am asking it here too. > > > > > > If you have to summarize the 1 or 2 features of VFP that you will feel > > > is a step backwards when migrating to .NET or any other platform as a > > > move forwards. > > > > > > Looking forward to your replies. > > > > > > Two things that was highlighted on Foxite: > > > > > > 1. Macro-compilation > > > 2. Evaluate(
Re: [NF] What would you miss from VFP, when migrating
Yeah, that'd suck. I guess you'd have to loop through record sets like ADO FOR MyLoop = 1 to MyRecordSet.Recordset.Count ENDFOR ??? "This sucks" On 6/27/2019 4:45 PM, John Weller wrote: I think I would miss SCAN/ENDSCAN most. John John Weller 01380 723235 07976 393631 [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/99eabb06-705c-cc91-367a-f448cc722...@mbsoftwaresolutions.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: [NF] What would you miss from VFP, when migrating
I think I would miss SCAN/ENDSCAN most. John John Weller 01380 723235 07976 393631 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/00b201d52d29$3ee19d60$bca4d820$@johnweller.co.uk ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Odd Error Message
We did have a test to see if the temp folder existed. If it didn't we tried to create it. But it did exist. Given the purpose of the temp folder is to hold temporary data, we didn't bother with code to actually try to create a file, write to it, and then verify that it was written to. I mean, who would ever make a temporary folder read-only Anyway, once we figured it out, it was easy to fix. I don't know why VFP (I can't remember which version we were using) didn't complain about the problem - it's been too long. But I do know that our error handler did not get called and the code happily continued executing even though the write was not actually performed. We used both On Error as well as Try Catch when it was finally added. Fletcher Fletcher Johnson fletchersjohn...@yahoo.com LinkedIn.com/in/FletcherJohnson twitter.com/fletcherJ strava.com/athletes/fletcherjohnson 408-946-0960 - work 408-781-2345 - cell -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Man-wai Chang Sent: Thursday, June 27, 2019 4:23 AM To: ProFox Email List Subject: Re: Odd Error Message You better double-check the error handler! It should not have ignored the write error to that TEMP folder. To verify whether a folder was writable, you could test write then delete a file in that folder and look for errors. You might need to temporarily use ON ERROR to trap file write errors before restoring the original error handler. I have done this kind of things many times. But then, why would someone lock down temporary folders? They are supposed to be TEMPORARY! But then, if the limit was on folder size, your code might still failed. So, your program still had to be fixed to detect that. A virus scanner could also produce the same error. Happy hunting anyway! :) On Thu, Jun 27, 2019 at 1:05 AM Fletcher Johnson wrote: > > folder) Anyway, it turns out that the IT folk at the time had decided > to lock down the Temp folder on all machines - but only by making it read > only.. > > The worst part is that, while we couldn't write to the file, we could open > it, etc. And when we tried to write to it, it acted like it did, even > though it didn't But then crashed later when we used it again and the > necessary values weren't there... -- .~. Might, Courage, Vision. SINCERITY! / v \ 64-bit Fedora 25 Server Spin /( _ )\ http://sites.google.com/site/changmw ^ ^ May the Force and farces be with you! [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/04f601d52d28$1c615420$5523fc60$@yahoo.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] What would you miss from VFP, when migrating
I now have an Information Safety manager who is applying real safety for our company to protect from the outside as well as ID-10-Ts who open the wrong documents. He has hacking sub-contractors that test our internal web apps and I get to see what they do in logs, and I ask if it was him or his team. We are now owned by Michael Dell and we now have a lot of new compliance to adhere to. 100% of all of our custom web access is via sprocs. Late this year or next year I'll be creating APIs to utilize as we start to post functionality to the cloud. Some data will be there and some will be here, depends on the system. On Thu, Jun 27, 2019 at 3:16 PM MB Software Solutions, LLC < mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote: > Knew you'd post that. I win my bets. lol > > Careful consideration is always made so thanks for the humor nonetheless. > > > On 6/27/2019 4:10 PM, Stephen Russell wrote: > > Thanks. > > > > It gives me a chuckle like this: > > https://www.explainxkcd.com/wiki/index.php/Little_Bobby_Tables > > > > --- > This email has been checked for viruses by Avast antivirus software. > https://www.avast.com/antivirus > > [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/CAJidMYJ8TwKZZ4vNoSjfUEJzp4Gfd0Xx-R2h=g42pha+hbx...@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] What would you miss from VFP, when migrating
As a dba that scares the shit out of me. Just being honest about dynamic statements and hackers who might know how to mess with you. This fear is real. https://codecurmudgeon.com/wp/sql-injection-hall-of-shame/ On Thu, Jun 27, 2019 at 3:10 PM Paul H. Tarver wrote: > I use TEXT/ENDTEXT to create dynamic SQL Queries by merging static text and > dynamic variables, then pass the resulting string to SQLEXECUTE. Very > convenient when creating large query strings. > > Paul H. Tarver > > > -Original Message- > From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of > Stephen > Russell > Sent: Thursday, June 27, 2019 2:43 PM > To: profoxt...@leafe.com > Subject: Re: [NF] What would you miss from VFP, when migrating > > Am I missing something about TEXT/ENDTEXT where it just mashes up a string > for you for whatever transpires within the loop? > > What do you do with that output or the textmerge when you are done with > it? > > On Thu, Jun 27, 2019 at 10:09 AM MB Software Solutions, LLC < > mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote: > > > Steve Ellenoff and I were talking the other day about the beauty of > > TEXTMERGE (TEXT/ENDTEXT) and iirc he indicated that wasn't in DotNet (or > > earlier versions anyway). I use TEXT/ENDTEXT *HEAVILY* in code often. > > > > > > On 6/27/2019 8:51 AM, Johan Nel wrote: > > > Hi VFPers > > > > > > I have asked this question on foxite too with very little feedback, so > > > I am asking it here too. > > > > > > If you have to summarize the 1 or 2 features of VFP that you will feel > > > is a step backwards when migrating to .NET or any other platform as a > > > move forwards. > > > > > > Looking forward to your replies. > > > > > > Two things that was highlighted on Foxite: > > > > > > 1. Macro-compilation > > > 2. Evaluate(
Re: [NF] What would you miss from VFP, when migrating
Knew you'd post that. I win my bets. lol Careful consideration is always made so thanks for the humor nonetheless. On 6/27/2019 4:10 PM, Stephen Russell wrote: Thanks. It gives me a chuckle like this: https://www.explainxkcd.com/wiki/index.php/Little_Bobby_Tables --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/be49e3a0-7670-4efd-85a7-c4e98cd85...@mbsoftwaresolutions.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] What would you miss from VFP, when migrating
Thanks. It gives me a chuckle like this: https://www.explainxkcd.com/wiki/index.php/Little_Bobby_Tables On Thu, Jun 27, 2019 at 2:45 PM MB Software Solutions, LLC < mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote: > In my largest case, it's usually helping to build SQLs dynamically > depending on a number of variables. In other cases, it's for building a > SET FILTER command which then gets executed. > > > On 6/27/2019 3:43 PM, Stephen Russell wrote: > > Am I missing something about TEXT/ENDTEXT where it just mashes up a > string > > for you for whatever transpires within the loop? > > > > What do you do with that output or the textmerge when you are done with > > it? > > > > On Thu, Jun 27, 2019 at 10:09 AM MB Software Solutions, LLC < > > mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote: > > > >> Steve Ellenoff and I were talking the other day about the beauty of > >> TEXTMERGE (TEXT/ENDTEXT) and iirc he indicated that wasn't in DotNet (or > >> earlier versions anyway). I use TEXT/ENDTEXT *HEAVILY* in code often. > >> > >> > >> On 6/27/2019 8:51 AM, Johan Nel wrote: > >>> Hi VFPers > >>> > >>> I have asked this question on foxite too with very little feedback, so > >>> I am asking it here too. > >>> > >>> If you have to summarize the 1 or 2 features of VFP that you will feel > >>> is a step backwards when migrating to .NET or any other platform as a > >>> move forwards. > >>> > >>> Looking forward to your replies. > >>> > >>> Two things that was highlighted on Foxite: > >>> > >>> 1. Macro-compilation > >>> 2. Evaluate(
RE: [NF] What would you miss from VFP, when migrating
I use TEXT/ENDTEXT to create dynamic SQL Queries by merging static text and dynamic variables, then pass the resulting string to SQLEXECUTE. Very convenient when creating large query strings. Paul H. Tarver -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Stephen Russell Sent: Thursday, June 27, 2019 2:43 PM To: profoxt...@leafe.com Subject: Re: [NF] What would you miss from VFP, when migrating Am I missing something about TEXT/ENDTEXT where it just mashes up a string for you for whatever transpires within the loop? What do you do with that output or the textmerge when you are done with it? On Thu, Jun 27, 2019 at 10:09 AM MB Software Solutions, LLC < mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote: > Steve Ellenoff and I were talking the other day about the beauty of > TEXTMERGE (TEXT/ENDTEXT) and iirc he indicated that wasn't in DotNet (or > earlier versions anyway). I use TEXT/ENDTEXT *HEAVILY* in code often. > > > On 6/27/2019 8:51 AM, Johan Nel wrote: > > Hi VFPers > > > > I have asked this question on foxite too with very little feedback, so > > I am asking it here too. > > > > If you have to summarize the 1 or 2 features of VFP that you will feel > > is a step backwards when migrating to .NET or any other platform as a > > move forwards. > > > > Looking forward to your replies. > > > > Two things that was highlighted on Foxite: > > > > 1. Macro-compilation > > 2. Evaluate(
RE: [NF] What would you miss from VFP, when migrating
+1 Paul H. Tarver -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Kevin Cully Sent: Thursday, June 27, 2019 12:25 PM To: profoxt...@leafe.com Subject: Re: [NF] What would you miss from VFP, when migrating The VFP Report Writer is amazing compared to other development tools I've seen, including my beloved Xojo. I've had to create my own report writer that spits out HTML based reports just to get me close to what VFP offered. Another language command is the SCATTER NAME and GATHER NAME. The ability to create an object with properties that corresponds to each field of a record is incredibly useful. Especially when combined with the TEXTMERGE command already stated earlier. -Kevin On 06/27/2019 08:51 AM, Johan Nel wrote: > Hi VFPers > > I have asked this question on foxite too with very little feedback, so > I am asking it here too. > > If you have to summarize the 1 or 2 features of VFP that you will feel > is a step backwards when migrating to .NET or any other platform as a > move forwards. > > Looking forward to your replies. > > Two things that was highlighted on Foxite: > > 1. Macro-compilation > 2. Evaluate(
Re: [NF] What would you miss from VFP, when migrating
In my largest case, it's usually helping to build SQLs dynamically depending on a number of variables. In other cases, it's for building a SET FILTER command which then gets executed. On 6/27/2019 3:43 PM, Stephen Russell wrote: Am I missing something about TEXT/ENDTEXT where it just mashes up a string for you for whatever transpires within the loop? What do you do with that output or the textmerge when you are done with it? On Thu, Jun 27, 2019 at 10:09 AM MB Software Solutions, LLC < mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote: Steve Ellenoff and I were talking the other day about the beauty of TEXTMERGE (TEXT/ENDTEXT) and iirc he indicated that wasn't in DotNet (or earlier versions anyway). I use TEXT/ENDTEXT *HEAVILY* in code often. On 6/27/2019 8:51 AM, Johan Nel wrote: Hi VFPers I have asked this question on foxite too with very little feedback, so I am asking it here too. If you have to summarize the 1 or 2 features of VFP that you will feel is a step backwards when migrating to .NET or any other platform as a move forwards. Looking forward to your replies. Two things that was highlighted on Foxite: 1. Macro-compilation 2. Evaluate(
Re: [NF] What would you miss from VFP, when migrating
Am I missing something about TEXT/ENDTEXT where it just mashes up a string for you for whatever transpires within the loop? What do you do with that output or the textmerge when you are done with it? On Thu, Jun 27, 2019 at 10:09 AM MB Software Solutions, LLC < mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote: > Steve Ellenoff and I were talking the other day about the beauty of > TEXTMERGE (TEXT/ENDTEXT) and iirc he indicated that wasn't in DotNet (or > earlier versions anyway). I use TEXT/ENDTEXT *HEAVILY* in code often. > > > On 6/27/2019 8:51 AM, Johan Nel wrote: > > Hi VFPers > > > > I have asked this question on foxite too with very little feedback, so > > I am asking it here too. > > > > If you have to summarize the 1 or 2 features of VFP that you will feel > > is a step backwards when migrating to .NET or any other platform as a > > move forwards. > > > > Looking forward to your replies. > > > > Two things that was highlighted on Foxite: > > > > 1. Macro-compilation > > 2. Evaluate(
Re: [NF] What would you miss from VFP, when migrating
The VFP Report Writer is amazing compared to other development tools I've seen, including my beloved Xojo. I've had to create my own report writer that spits out HTML based reports just to get me close to what VFP offered. Another language command is the SCATTER NAME and GATHER NAME. The ability to create an object with properties that corresponds to each field of a record is incredibly useful. Especially when combined with the TEXTMERGE command already stated earlier. -Kevin On 06/27/2019 08:51 AM, Johan Nel wrote: Hi VFPers I have asked this question on foxite too with very little feedback, so I am asking it here too. If you have to summarize the 1 or 2 features of VFP that you will feel is a step backwards when migrating to .NET or any other platform as a move forwards. Looking forward to your replies. Two things that was highlighted on Foxite: 1. Macro-compilation 2. Evaluate(
Re: [NF] What would you miss from VFP, when migrating
VFP cursors are under discussion and will be supported, one way or the other. There are obviously some .NET features like DataSet/DataTable/DataReader that are all under scrutiny to see how these VFP specifics will/can be accommodated. As you say, some of these we learn of everyday, same goes for me using X#/.NET and it is up to the community to assist in resolving these once the public VFP support is released. Again, first things first, get the basics in place then we as community in partnership with the DevTeam can sort out the outstanding more "unused" features. It is already clear now that the core of the language is stable, how quick the DevTeam is responding on fixing detected issues... Johan On 2019/06/27 18:53, Paul H. Tarver wrote: I would greatly miss the speedy import capabilities of Foxpro and the CREATE CURSOR to build temporary files to temporarily hold imported data. I also make extensive use of Class Libraries. More and more I'm using of creating Empty Objects and adding properties to store and manage lots of variables including making it possible to pass a single reference to the object as a parameter and making all of the properties available to other modules. And I agree 100% with wanting to keep the TEXTMERGE feature. I think I could do this all day and because it seems I'm still learning new ways to use VFP commands and features, I think I fear losing any of them! Paul H. Tarver -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Johan Nel Sent: Thursday, June 27, 2019 7:52 AM To: profoxt...@leafe.com Subject: [NF] What would you miss from VFP, when migrating Hi VFPers I have asked this question on foxite too with very little feedback, so I am asking it here too. If you have to summarize the 1 or 2 features of VFP that you will feel is a step backwards when migrating to .NET or any other platform as a move forwards. Looking forward to your replies. Two things that was highlighted on Foxite: 1. Macro-compilation 2. Evaluate(
RE: [NF] What would you miss from VFP, when migrating
I would greatly miss the speedy import capabilities of Foxpro and the CREATE CURSOR to build temporary files to temporarily hold imported data. I also make extensive use of Class Libraries. More and more I'm using of creating Empty Objects and adding properties to store and manage lots of variables including making it possible to pass a single reference to the object as a parameter and making all of the properties available to other modules. And I agree 100% with wanting to keep the TEXTMERGE feature. I think I could do this all day and because it seems I'm still learning new ways to use VFP commands and features, I think I fear losing any of them! Paul H. Tarver -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Johan Nel Sent: Thursday, June 27, 2019 7:52 AM To: profoxt...@leafe.com Subject: [NF] What would you miss from VFP, when migrating Hi VFPers I have asked this question on foxite too with very little feedback, so I am asking it here too. If you have to summarize the 1 or 2 features of VFP that you will feel is a step backwards when migrating to .NET or any other platform as a move forwards. Looking forward to your replies. Two things that was highlighted on Foxite: 1. Macro-compilation 2. Evaluate(
Re: [NF] What would you miss from VFP, when migrating
Thanks, Good news is that X# in its current version is mapping TEXT/ENDTEXT to an internal function... See personal communication regarding the command with Robert. TEXT .. ENDTEXT is also parsed and send to a function with the name "__TextSupport". That function is not included in the runtime yet, but if you include that function in your code then it works. So in short, this will be supported by X#, the internals are just not yet implemented, but will be with the final release of VFP support. If somebody interested, it can be developed by a community member as part of the opensource runtime... Regards, Johan. On 2019/06/27 17:08, MB Software Solutions, LLC wrote: Steve Ellenoff and I were talking the other day about the beauty of TEXTMERGE (TEXT/ENDTEXT) and iirc he indicated that wasn't in DotNet (or earlier versions anyway). I use TEXT/ENDTEXT *HEAVILY* in code often. On 6/27/2019 8:51 AM, Johan Nel wrote: Hi VFPers I have asked this question on foxite too with very little feedback, so I am asking it here too. If you have to summarize the 1 or 2 features of VFP that you will feel is a step backwards when migrating to .NET or any other platform as a move forwards. Looking forward to your replies. Two things that was highlighted on Foxite: 1. Macro-compilation 2. Evaluate(
Re: [NF] What would you miss from VFP, when migrating
Steve Ellenoff and I were talking the other day about the beauty of TEXTMERGE (TEXT/ENDTEXT) and iirc he indicated that wasn't in DotNet (or earlier versions anyway). I use TEXT/ENDTEXT *HEAVILY* in code often. On 6/27/2019 8:51 AM, Johan Nel wrote: Hi VFPers I have asked this question on foxite too with very little feedback, so I am asking it here too. If you have to summarize the 1 or 2 features of VFP that you will feel is a step backwards when migrating to .NET or any other platform as a move forwards. Looking forward to your replies. Two things that was highlighted on Foxite: 1. Macro-compilation 2. Evaluate(
[NF] What would you miss from VFP, when migrating
Hi VFPers I have asked this question on foxite too with very little feedback, so I am asking it here too. If you have to summarize the 1 or 2 features of VFP that you will feel is a step backwards when migrating to .NET or any other platform as a move forwards. Looking forward to your replies. Two things that was highlighted on Foxite: 1. Macro-compilation 2. Evaluate(
Re: Odd Error Message
You better double-check the error handler! It should not have ignored the write error to that TEMP folder. To verify whether a folder was writable, you could test write then delete a file in that folder and look for errors. You might need to temporarily use ON ERROR to trap file write errors before restoring the original error handler. I have done this kind of things many times. But then, why would someone lock down temporary folders? They are supposed to be TEMPORARY! But then, if the limit was on folder size, your code might still failed. So, your program still had to be fixed to detect that. A virus scanner could also produce the same error. Happy hunting anyway! :) On Thu, Jun 27, 2019 at 1:05 AM Fletcher Johnson wrote: > > folder) Anyway, it turns out that the IT folk at the time had decided > to lock down the Temp folder on all machines - but only by making it read > only.. > > The worst part is that, while we couldn't write to the file, we could open > it, etc. And when we tried to write to it, it acted like it did, even > though it didn't But then crashed later when we used it again and the > necessary values weren't there... -- .~. Might, Courage, Vision. SINCERITY! / v \ 64-bit Fedora 25 Server Spin /( _ )\ http://sites.google.com/site/changmw ^ ^ May the Force and farces be with you! ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/CAGv=MJBcpw94378NPbYKsTmwpbv3Qa1Yfn3=d4g28zsedux...@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.