Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Cecil Champenois
  Where is Cecil Champenois?
 Little Elm
 Texas - United States
 Cecil Champenois
 To: Pete Sass
  Where is Pete Sass?
 Marathon, Ontario
 Canada
 Pete Sass
 Tags
Subject: RE: Discussion on Inconsistent Data
Thread ID: 395339 Message ID: 395355 # Views: 34 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Monday, January 13, 2014 9:51:13 PM         
   


> >
> > My heart goes out to you; that was quite an ordeal to fix that data. I spoke to a fellow developer here at my client's site who listened concernedly, but he has no direct input to fixing the issue and I am not sure who does. I am told to only do what I am told, not to talk to anyone who has nothing to do with my specific assignments, so I know that the issue will never be resolved. If I make any waves, I would probably hear something like this: "Hey, we've done it like this for 30 years, so why are you the only one complaining?"
> >
> > What I forgot to mention is that I'll be doing this all in either T-SQL, or C# with T-SQL. It would be so much easier to do the data fixing with FoxPro functions in my opinion, since that is what I know best.
> >
> > Cecil Champenois, Jr.
>
>
>
> Hi,
>
> You may wish to consider VFP for the data manipulation. VFP is very rich
> in string handling and parsing as you already know.
>
> Local cursor that you can browse really give you the ability for a sneak peek
> at what the result set is when a command is executed.
>
> I think C# has most of the same thing, but you do loose the ability for the
> browse and see as you try different SQL commands in the VFP command window.
>
> Now that I hear more about your project I am pondering how much T-SQL you can
> use as if is kind of sounding to me that your conversion is going to be very
> granular and right down to each individual record in a lot of cases.
>
> I think VFP probably has the edge on string handling.
>
> Pete "the IceMan", from the Great White North of Canada.
> www.marathongriffincomputers.com

I was told that I had to design it for a group that we send data to, so that they can use the software as a tool to put the data into their flat file format. In other words, I am doing their job. They use only C#, VB, and SQL Server, and sometimes ACCESS.

Cecil Champenois, Jr.

ENTIRE THREAD

Discussion on Inconsistent Data Posted by Cecil Champenois @ 1/13/2014 6:15:46 PM
RE: Discussion on Inconsistent Data Posted by David Mustakim @ 1/13/2014 6:40:05 PM
RE: Discussion on Inconsistent Data Posted by Cecil Champenois @ 1/13/2014 6:46:51 PM
RE: Discussion on Inconsistent Data Posted by Tony Vignone @ 1/13/2014 6:49:00 PM
RE: Discussion on Inconsistent Data Posted by Jun Tangunan @ 1/14/2014 6:36:47 AM
RE: Discussion on Inconsistent Data Posted by Cecil Champenois @ 1/14/2014 3:12:39 PM
RE: Discussion on Inconsistent Data Posted by Tony Vignone @ 1/14/2014 6:58:46 PM
RE: Discussion on Inconsistent Data Posted by Cecil Champenois @ 1/14/2014 7:44:48 PM
RE: Discussion on Inconsistent Data Posted by Tony Vignone @ 1/14/2014 11:12:28 PM
RE: Discussion on Inconsistent Data Posted by Vilhelm-Ion Praisach @ 1/13/2014 7:00:25 PM
RE: Discussion on Inconsistent Data Posted by Tony Vignone @ 1/14/2014 7:00:35 PM
RE: Discussion on Inconsistent Data Posted by Vilhelm-Ion Praisach @ 1/14/2014 7:53:25 PM
RE: Discussion on Inconsistent Data Posted by Tony Vignone @ 1/14/2014 11:08:17 PM
RE: Discussion on Inconsistent Data Posted by Pete Sass @ 1/13/2014 7:55:46 PM
RE: Discussion on Inconsistent Data Posted by Cecil Champenois @ 1/13/2014 9:09:42 PM
RE: Discussion on Inconsistent Data Posted by David Mustakim @ 1/13/2014 9:24:52 PM
RE: Discussion on Inconsistent Data Posted by Cecil Champenois @ 1/13/2014 9:49:26 PM
RE: Discussion on Inconsistent Data Posted by Pete Sass @ 1/13/2014 9:41:48 PM
RE: Discussion on Inconsistent Data Posted by Cecil Champenois @ 1/13/2014 9:51:13 PM
RE: Discussion on Inconsistent Data Posted by Michel Levy @ 1/13/2014 10:01:45 PM
RE: Discussion on Inconsistent Data Posted by Vilhelm-Ion Praisach @ 1/14/2014 6:45:45 AM
RE: Discussion on Inconsistent Data Posted by Jun Tangunan @ 1/14/2014 1:15:20 AM
RE: Discussion on Inconsistent Data Posted by Tore Bleken @ 1/14/2014 8:53:53 AM