Re: [NF] What would you miss from VFP, when migrating

2019-06-27 Thread Johan Nel
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

Re: [NF] What would you miss from VFP, when migrating

2019-06-27 Thread Johan Nel
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

Re: [NF] What would you miss from VFP, when migrating

2019-06-27 Thread MB Software Solutions, LLC
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.

RE: [NF] What would you miss from VFP, when migrating

2019-06-27 Thread Paul H. Tarver
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:

Re: [NF] What would you miss from VFP, when migrating

2019-06-27 Thread Stephen Russell
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 > > >

RE: Odd build error when trying to create automation COM component; references drive/folder I don't have in Project Info/Servers tab

2019-06-27 Thread Tracy Pearson
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

RE: Odd build error when trying to create automation COM component; references drive/folder I don't have in Project Info/Servers tab

2019-06-27 Thread Richard Kaye
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

Odd build error when trying to create automation COM component; references drive/folder I don't have in Project Info/Servers tab

2019-06-27 Thread MB Software Solutions, LLC
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

RE: Odd Error Message

2019-06-27 Thread Tracy Pearson
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

RE: [NF] What would you miss from VFP, when migrating

2019-06-27 Thread Paul H. Tarver
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:

Re: [NF] What would you miss from VFP, when migrating

2019-06-27 Thread MB Software Solutions, LLC
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

RE: [NF] What would you miss from VFP, when migrating

2019-06-27 Thread John Weller
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:

RE: Odd Error Message

2019-06-27 Thread Fletcher Johnson
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,

Re: [NF] What would you miss from VFP, when migrating

2019-06-27 Thread Stephen Russell
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

Re: [NF] What would you miss from VFP, when migrating

2019-06-27 Thread Stephen Russell
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

Re: [NF] What would you miss from VFP, when migrating

2019-06-27 Thread MB Software Solutions, LLC
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

Re: [NF] What would you miss from VFP, when migrating

2019-06-27 Thread Stephen Russell
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 >

RE: [NF] What would you miss from VFP, when migrating

2019-06-27 Thread Paul H. Tarver
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

RE: [NF] What would you miss from VFP, when migrating

2019-06-27 Thread Paul H. Tarver
+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

Re: [NF] What would you miss from VFP, when migrating

2019-06-27 Thread MB Software Solutions, LLC
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

Re: [NF] What would you miss from VFP, when migrating

2019-06-27 Thread Stephen Russell
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 <

Re: [NF] What would you miss from VFP, when migrating

2019-06-27 Thread Kevin Cully
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

Re: [NF] What would you miss from VFP, when migrating

2019-06-27 Thread Johan Nel
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

RE: [NF] What would you miss from VFP, when migrating

2019-06-27 Thread Paul H. Tarver
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

Re: [NF] What would you miss from VFP, when migrating

2019-06-27 Thread Johan Nel
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

Re: [NF] What would you miss from VFP, when migrating

2019-06-27 Thread MB Software Solutions, LLC
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

[NF] What would you miss from VFP, when migrating

2019-06-27 Thread Johan Nel
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

Re: Odd Error Message

2019-06-27 Thread Man-wai Chang
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