Re: Remote FoxPro Work???

2019-07-02 Thread Kurt at VR-FX
Hey there Lew - I saw your name - before I read your reply - and HELL YEAH I remember meeting up with you! Its really great to hear from you - and thank you so much for your kind words. Have fun up in MA! -K- On 7/2/2019 9:26 PM, Lew Schwartz wrote: Hey Kurt - you and I met once or twice in

Re: Remote FoxPro Work???

2019-07-02 Thread Lew Schwartz
Hey Kurt - you and I met once or twice in NYC. I'm fully retired now, living in MA & still lurking on the list. Haven't programmed in years. Good luck & hang in there. -Lew On Tue, Jul 2, 2019, 5:56 PM Kurt at VR-FX wrote: > Yeah - I know - these days - that's a pretty crazy request. > > I kno

Re: Remote FoxPro Work???

2019-07-02 Thread Kurt at VR-FX
Hey Paul - thank you VERY Much for your kind words!!! YEah - its a VERY Difficult time for me. Probably one of the most difficult times in my life... And - I wholeheartedly agree - developing apps w/VFP beats other tools - since its truly RAD! And, I don't mean it in the COOL Way kids say it!!

Re: Remote FoxPro Work???

2019-07-02 Thread Kurt at VR-FX
U mean - Convert an old FP for DOS app to VFP? Cause - Hell - I would LOVE to do THAT! I would be truly KILLER at that!!! But - alas - trying to find those kinda people may be a bit tough... -K- On 7/2/2019 6:40 PM, Koen Piller wrote: Kurt, I donot agree with you on this. When I say 'a modern

RE: Remote FoxPro Work???

2019-07-02 Thread Paul H. Tarver
+1 I am still developing and supporting VFP6.0 and VFP9.0 apps daily for my very narrow market. After having done extensive testing on multiple development tools over the last six years, I can definitively say there is nothing I can't do for my clients in my particular market and do it faster with

RE: Reverse Wildcard String Comparison

2019-07-02 Thread Paul H. Tarver
I've made the comment to this group before: Almost day I learn something new that Foxpro can do that changes the way I work. I use this tool everyday and I kid you not, the joke in my office is when I yell out, "I learned my new Foxpro trick for the day!" Thank you Ricardo! Your tip put me exactl

Re: Remote FoxPro Work???

2019-07-02 Thread Koen Piller
Kurt, I donot agree with you on this. When I say 'a modern Win10 appilication' I just mean an application built with VFP9SP2 with some modern UI - like FoxyRibbon, FoxyPreviewer etc. This is for the endusers already an immazing improvement when you have worked with a FoX2.2 built application. Sure

[NF] Work in SalesForce?

2019-07-02 Thread Kurt at VR-FX
I'm curious. I have a buddy of mine who has been DEMANDING that I get onto the SalesForce bandwagon. Seems there is a HUGE Demand out there it. And, supposedly - its Stupid easy to learn. So - I Am VERY curious to know. IS there any folks here who work with it!?!? -K- _

Re: Remote FoxPro Work???

2019-07-02 Thread Kurt at VR-FX
Hey Koen - I TOTALLY Appreciate the input. Problem is - I can't convert a VFP app to a Modern Win10 app - since, I don't have any experience w/tech that would allow me to do exactly that. Sure - I know FoxInCloud has a kind of conversion utility to do something like that, but, alas - I don't ha

Re: Remote FoxPro Work???

2019-07-02 Thread Koen Piller
Kurt My advise: throw a website together in which you advertise your skills. Donot prompte Foxpro but do promote you can convert old fashioned DOS apps (VFP 2.2, Clipper and the like ) to a Win10 app. Lots lots of these old programs still running around seeking for a modern upgrade Koen Op di 2 ju

RE: Reverse Wildcard String Comparison

2019-07-02 Thread Paul H. Tarver
No snark implied or taken! The reason for this isn't about the source data as much about the destination data. We are pulling the data for use in another system and we are trying to populate a new field with content based upon similar source data. It will be normalized in the destination system.

Re: Reverse Wildcard String Comparison

2019-07-02 Thread Ricardo Molina
There's no need for a UDF, VFP has a built-in function LIKE(). Create Cursor depts ( deptnum c(3), Descript c(10), Value i) Insert Into depts ( deptnum, Descript, Value) Values ( "1??", "Dept 1", 99930) Insert Into depts ( deptnum, Descript, Value) Values ( "2??", "Dept 2", 92382) Insert Into dept

Remote FoxPro Work???

2019-07-02 Thread Kurt at VR-FX
Yeah - I know - these days - that's a pretty crazy request. I know some of you have followed me a bit - and know I lost my job in Nov 2017 - where I was working down on Wall Street. Then, moved to Cali to look for a job - could NOT find work in San Francisco. Even applied to UCLA for a program

Re: Reverse Wildcard String Comparison

2019-07-02 Thread Ted Roche
Requisite snarky comment: if a join depends on only _part_ of the value of another field, the data is not normalized. Are the DeptNum fields really literally question marks and digits, as if they were wildcards? If so, you could write some UDF to convert DOS wildcards of * and? to SQL wildcards o

Reverse Wildcard String Comparison

2019-07-02 Thread Paul H. Tarver
Ok, I need a little help and here's the scenario: I have an x-ref table that looks like this: DeptNum, Description, Value 1??, Dept 1, 99930 2??, Dept 2, 92382 3??, Dept 3, 83728 ?4?, Dept 4, 27377 Next, I have a data table with thousands of employees with department numbers I want

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

2019-07-02 Thread Frank Cazabon
This had started because Mike had stated: That's always been my approach to avoiding SQL injection but I thought Steve or somebody else here LONG ago had debunked that approach as still vulnerable? So I was concerned that the technique that has been put forward as the safest way to avoid SQ

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

2019-07-02 Thread Stephen Russell
It takes some testing. I presented the first easiest hack and I may have said use the opening ' because I thought that you were looking for text data and not INT value in that table you were querying against. Creating a series of tests just to be sure, is helpful. In the end, when everything is

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

2019-07-02 Thread Frank Cazabon
Ah, I was concerned that all these years of me using parameters for safety you had some proof that they were unsafe. Frank. Frank Cazabon On 01/07/2019 03:54 PM, Stephen Russell wrote: 25 years ago as a guess. I probably didn't use the ? operator. On Mon, Jul 1, 2019 at 2:39 PM MB Software