VFP Job in Albany

[Lew Schwartz]

Just passing this along:

 I found your profile online and thought you would be a great fit for
“Visual FoxPro Programmer Analyst Sr. Developer/ Team Lead” position
we are trying to fill in Albany, New York.



 A complete description of the job can be found below. If you are
interested, please respond with an updated copy of resume and answers
to short questionnaire at the bottom of my email. Please feel free to
call with any questions you may have. Lastly, if you are not
interested or available, but know someone who may be, please let me
know or pass along their info and I will reach out to them.



Position: Visual FoxPro Programmer Analyst Sr. Developer/ Team Lead

Location: Albany, New York

Duration: 12 Months Contract



Job Description:



Ideal candidate would be someone with 5 to 8 years of Visual
FoxPro experience
Ability to analyze, understand and document the business rules
from the Visual FoxPro code
Ability to analyze the data model Coordinate with the end-users
and the business team for any technical clarifications As this is for
an application re-engineering and migration from FoxPro to Visual
FoxPro, the candidate should validate the functional specification
against the functionality implemented in Visual FoxPro Identify
opportunities for improving the existing functionalities and recommend
the same to the .NET development team. Familiarity in .NET will be an
added advantage.
Must be a team player and have initiative and strong
self-management skills. Additionally, the candidate must be able to
quickly understand existing application code and be able to make
modifications/improvements as necessary.
We are looking for an experienced Visual FoxPro Developer for new
development and as well as support/trouble-shoot current applications.
Experience with all aspects of Visual FoxPro application
development and user support (including remote users).
You must have very solid VFP skills and Object oriented
design/programming in VFP.
Must be well experienced in developing Business applications
within the Insurance industry.
 Knowledge of Oracle database, PL/SQL, .Net and Crystal reports is a plus.



Required Skills:



 5 - 10 years of overall Information Technology experience
 Proven Sr. Developer/ Team Lead with FoxPro to Visual FoxPro
migration experience
 5+ years Visual FoxPro 6.0 or greater
 3+ years SQL Server (transact SQL, stored procedures, triggers, etc.)



Preferred Skills:



 Object-oriented programming principles
 C#
 WPF

I would really appreciate it if you can fill out the following:



Candidate Name:

Phone #:

Email:

Visa Status:

Current Location:

Availability to start:

Availability to interview in-person:

Availability to phone interview:

Expected Salary/Hourly Rate:

Willing to relocate: Yes / No



If you have any questions please feel free to call me at - 248-242-5279





Thanks & Regards,
Vinoth Kumar
Technical Recruiter
Cosourcing Partners
Email - vku...@cosourcingpartners.com
Phone : 248-242-5279

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/cafuu78cy1gutlar1pb4-gdfuitvs+qyyy+zfrpej-ag7zpj...@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: Speed

[Mike Copeland]

If I've been following this correctly, the speed is good when processed 
locally (on the same machine?) but slow most of the time when a network 
is involved although not always slow. I wouldn't point the finger at the 
server, nor the workstation...the network cables, maybe. The switch, maybe.

My finger would point at the query processing speed, not the actual flow 
of bits over the wire.

But I agree it sounds fishy.

Mike

 Original Message 
Subject: Re: Speed
From: Fred Taylor 
To: profoxt...@leafe.com
Date: 9/12/2012 2:47 PM

Programmers can fix software.  Hardware... not so much.  Depends on your
what your job is.

Fred


On Wed, Sep 12, 2012 at 12:32 PM, Stephen Russell wrote:

> On Wed, Sep 12, 2012 at 12:47 PM, Fred Taylor  wrote:
>> Works in VFP 7, too.
>>
> -
>
> Nobody thought this was a hardware issue?
>
>
>
>
> --
> Stephen Russell
> Sr. Analyst
> Ring Container Technology
> Oakland TN
>
> 901.246-0159 cell
>
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/5050e7a3.8000...@ggisoft.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: Speed

[Fred Taylor]

Programmers can fix software.  Hardware... not so much.  Depends on your
what your job is.

Fred


On Wed, Sep 12, 2012 at 12:32 PM, Stephen Russell wrote:

> On Wed, Sep 12, 2012 at 12:47 PM, Fred Taylor  wrote:
> > Works in VFP 7, too.
> >
> -
>
> Nobody thought this was a hardware issue?
>
>
>
>
> --
> Stephen Russell
> Sr. Analyst
> Ring Container Technology
> Oakland TN
>
> 901.246-0159 cell
>
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/cajcbksrfusz5xntfod1yrvvmwx_esdtr-m4huzwaaomkcsg...@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] great history of MSSQL with real time history in as well.

[Stephen Russell]

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

901.246-0159 cell

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/cajidmylrs62oroyupexb7d3y2lv31offza0bpheto4_vj2v...@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: Speed

[Fred Taylor]

Works in VFP 7, too.

Fred


On Wed, Sep 12, 2012 at 10:25 AM, Richard Kaye  wrote:

> IIRC the BETWEEN() function became Rushmore aware in VFP 9. However, the
> older I get, the probability of me RC decreases... ;-)
>
> --
> rk
>
> -Original Message-
> From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com]
> On Behalf Of MB Software Solutions, LLC
> Sent: Wednesday, September 12, 2012 1:14 PM
> To: profoxt...@leafe.com
> Subject: Re: Speed
>
> On 9/12/2012 1:02 PM, Fred Taylor wrote:
> > Just tried it to prove it to myself.  No difference in whichever
> > syntax you choose, optimization uses the TAG on the date field and is
> fully optimized.
>
>
> Thanks, Fred!  I'm in/out of offices today so no time to verify myself.
>   Glad you did to clear that up!
>
>
>
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/CAJCBksqPVOMPRRCxP4yN=yjfkdme9w-omi95ktbvhfb3ogm...@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: Speed

[Richard Kaye]

IIRC the BETWEEN() function became Rushmore aware in VFP 9. However, the older 
I get, the probability of me RC decreases... ;-)

--
rk

-Original Message-
From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On 
Behalf Of MB Software Solutions, LLC
Sent: Wednesday, September 12, 2012 1:14 PM
To: profoxt...@leafe.com
Subject: Re: Speed

On 9/12/2012 1:02 PM, Fred Taylor wrote:
> Just tried it to prove it to myself.  No difference in whichever 
> syntax you choose, optimization uses the TAG on the date field and is fully 
> optimized.


Thanks, Fred!  I'm in/out of offices today so no time to verify myself. 
  Glad you did to clear that up!



___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/DF1EEF11E586A64FB54A97F22A8BD044216ED5FA57@ACKBWDDQH1.artfact.local
** 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: Speed

[MB Software Solutions, LLC]

On 9/12/2012 1:02 PM, Fred Taylor wrote:
>>
>>
>>
>> What happens if you use "DATE BETWEEN trcask4 and trcask5" instead of
>> using VFP's BETWEEN function?  iirc, BETWEEN(field,arg1,arg2) was NOT
>> optimizable but "field BETWEEN arg1 and arg2" was optimizable.
>>
>>
>>
> Just tried it to prove it to myself.  No difference in whichever syntax you
> choose, optimization uses the TAG on the date field and is fully optimized.


Thanks, Fred!  I'm in/out of offices today so no time to verify myself. 
  Glad you did to clear that up!


-- 
Mike Babcock, MCP
MB Software Solutions, LLC
President, Chief Software Architect
http://mbsoftwaresolutions.com
http://fabmate.com
http://twitter.com/mbabcock16

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/5050c2e8.5030...@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: Speed

[Fred Taylor]

>
>
>
> What happens if you use "DATE BETWEEN trcask4 and trcask5" instead of
> using VFP's BETWEEN function?  iirc, BETWEEN(field,arg1,arg2) was NOT
> optimizable but "field BETWEEN arg1 and arg2" was optimizable.
>
>
>
Just tried it to prove it to myself.  No difference in whichever syntax you
choose, optimization uses the TAG on the date field and is fully optimized.

Fred


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

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/cajcbksq63uv0wgmc4mfnssqugk6ld5hwy2yayqmv3j8+48w...@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: Version control

[Dan Covill]

On 09/12/12 02:56, Dave Crozier wrote:
> Never having used alternative software, I think Paul McNett dabbled with 
> subversion using VFP and wonder if anyone has any comments on what to use and 
> why. I know about the format of VFP forms etc. being a pain as they are not 
> simple text.
>

A year ago I got interested in Distributed Source Control, looked into 
git and mecurial, and downloaded and tested Mercurial with the 
TortoiseHg GUI interface.  I was positively impressed, and am still 
using it, although sporadically because I'm no longer actively programming.

1. The Distributed model has huge advantages for an independent because 
there is no 'official' repository; you can join forces with another 
developer, located somewhere else, on a temporary basis and still keep 
everything together.

2. I understand Git is used by the Linux crowd, while Mercurial is used 
by the Mozilla folks.  IOW, Git is geekier.  So I tried Mercurial.

3. The Tortoise front end, available for Git, Mercurial, ans Svn, is 
very good.  A marvelous feature is a Windows Explorer mod that puts 
little red and green dots on files that have been modified and have/have 
not been committed.

4. I paid particular attention to possible VFP problems, and simply 
didn't have any.  Yes, the form and report files don't display as simple 
text in the difference views (because they're not), but they are 
detected properly and controlled properly, and that's what matters.

Try them.  They're free and they work.

Dan Covill
San Diego

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/5050bedd.4070...@san.rr.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: Speed

[MB Software Solutions, LLC]

On 9/11/2012 11:22 PM, Sytze de Boer wrote:
> Fred
> (Blush) NO
>
> S


DOH!  Dammit Sytze...you owe a round of pints for that one.  :-)


-- 
Mike Babcock, MCP
MB Software Solutions, LLC
President, Chief Software Architect
http://mbsoftwaresolutions.com
http://fabmate.com
http://twitter.com/mbabcock16

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/5050b8c1.6030...@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: Speed

[MB Software Solutions, LLC]

On 9/11/2012 9:35 PM, Sytze de Boer wrote:
> I'm losing my mind over this
>
> At a client site, they run a report which can take 30 mins to generate,
> over the network
> When they run it on a local pc, it takes 5 secs
>
> Without boring you with all the details, essentially, the following code
> makes up the report
> *trcask4=a date
> *trcask5=a date
>
> Select Date,stockcode,stktype,invnum,qty,ttlamount,disc,ppb,cost,Desc,
> "H" As SRCE From winhst   Where Between(Date,trcask4,trcask5) Union All;
> Select Date,stockcode,stktype,invnum,qty,ttlamount,disc,ppb,cost,Desc,
> "I" As SRCE  From wininvs  Where Between(Date,trcask4,trcask5) Union All ;
> Select Date,stockcode,stktype,invnum,qty,ttlamount,disc,ppb,cost,Desc,
> "J" As SRCE From wintime  Where Between(Date,trcask4,trcask5) Into Table
> (myfile)
>
> The Winhst file has about 500,000 records
> The other 2 less than a 1000 combined
>
> There seems to be a big difference in time if no-ones else has logged into
> the app from a different workstation
>
> Can anyone suggest a way to make this go quicker?


What happens if you use "DATE BETWEEN trcask4 and trcask5" instead of 
using VFP's BETWEEN function?  iirc, BETWEEN(field,arg1,arg2) was NOT 
optimizable but "field BETWEEN arg1 and arg2" was optimizable.

hth,
--Mike



-- 
Mike Babcock, MCP
MB Software Solutions, LLC
President, Chief Software Architect
http://mbsoftwaresolutions.com
http://fabmate.com
http://twitter.com/mbabcock16

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/5050b7af.1000...@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: Version control

[Paul McNett]

On 9/12/12 2:56 AM, Dave Crozier wrote:
> Never having used alternative software, I think Paul McNett dabbled with 
> subversion using VFP and wonder if anyone has any comments on what to use and 
> why. I know about the format of VFP forms etc. being a pain as they are not 
> simple text.

I used Subversion combined with a hacked-up scctext.prg (my scX project) that 
did
true 2-way binary-to-text conversion of the files so that I could do diffs and
merges. I still use it today for one remaining legacy VFP project but haven't 
been
developing scX for the better part of a decade now, and I don't recommend it 
for that
reason. I hear there is a more modern attempt at this and can't comment on it
personally because I haven't use it.

All my new source control is in git.

In general, I recommend you get away from the mentality of having integrated 
source
control, and learn to put the source control into your work stream manually, 
where it
makes sense. Here's my typical workstream:

1) sit down to work for a couple hours on a project
2) open a terminal and:
  cd 
  git pull (or svn update)
  git status (or svn status)  ## make sure I didn't leave modified files around
3) work the couple hours
4) review with tools like git/svn diff
5) git commit -a (or svn commit)
6) git push (not necessary in subversion)

The git workflow is simplified above, as there's much more you can do 
(branching is
very powerful in git, for example). I'm merely showing the simplest (and most
typical, for me at least) workflow.

Git is a much better product than Subversion for a few key reasons (speed, true
distributed source control, community acceptance). Git is actually simpler than
Subversion once you've worked with it for a little bit, however Subversion is 
still a
good choice in my opinion. I'm totally happy leaving my legacy stuff on 
Subversion.

I used (tried to use) Visual SourceSafe way back maybe 1999 and thought I must 
have
been simply misunderstanding the product since everyone was recommending it and 
kept
trying again and again but I came to the conclusion that it is one big stinking 
pile
of crapware. It was crap then compared to CVS, and now CVS is crap compared to
Subversion, yet you say Microsoft is still peddling Visual SourceSafe?

So, find the current vfp project that does what I was doing with scX only 
better and
more current, and decide to go with either git or subversion, and don't look 
back.
Other people have figured out all the hard parts for you by now, you merely 
need to
learn how to hook all the pieces together in a workflow that makes sense for 
you.

Paul


___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/5050b68e.5030...@ulmcnett.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: Version control

[MB Software Solutions, LLC]

On 9/12/2012 5:56 AM, Dave Crozier wrote:
> I have had very few occasions to use version control when using VFP but as we 
> are involved in a really large conversion job here I decided 3 months ago to 
> use a formal method of version control and as such decided on the old chesnut 
> Visual Source Safe as we have it under our MSDN agreement and it obviously 
> seems to fit in seamlessly (laugh out loud!!) with VFP.
>
> The few occasions I have used it and required it although "messy" it has 
> worked, however I now find that the VSS database has become totally screwed 
> beyond repair and hence no sensible audit trail etc to go back to as the 
> corruption seems to go back about two months prior to the changes I want to 
> re-instate. I know, bad planning on my behalf but I can go back to disk 
> backups even though it will involve a fair amount file comparing (beyond 
> compare will earn it's corn the next few days!).
>
> Never having used alternative software, I think Paul McNett dabbled with 
> subversion using VFP and wonder if anyone has any comments on what to use and 
> why. I know about the format of VFP forms etc. being a pain as they are not 
> simple text.
>
> I just don't want to trust VSS any more despite it being the nearest 
> "standard VFP" offering there is.


I recall Ed Leafe telling me about Tortoise SVN I thought many moons 
ago.  ??  At my current day gig, we had been using SourceGear's Vault, 
which seemed fine to me, but now we're using Team Foundation Server at 
the corporate HQ (and I suppose I'll be getting on board that any day 
now too with a new project to check in).


-- 
Mike Babcock, MCP
MB Software Solutions, LLC
President, Chief Software Architect
http://mbsoftwaresolutions.com
http://fabmate.com
http://twitter.com/mbabcock16

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/5050b612.2050...@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: Version Control

[Richard Kaye]

You could also run gendbc against your DBC and store the resulting PRG in your 
SCC system.

--
rk

-Original Message-
From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On 
Behalf Of Charlie Coleman
Sent: Thursday, March 25, 2004 7:06 PM
To: profoxt...@leafe.com
Subject: Re: Version Control

>Is there some sort of data description information that I could gather 
>about a database in Foxpro?
>I need to do version control on databases and tables.
>Anyone been down this road before?


___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/DF1EEF11E586A64FB54A97F22A8BD044216ED5FA02@ACKBWDDQH1.artfact.local
** 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: Version control

[Richard Kaye]

There is a SVN<->VFP project on VFPX that is supposed to give that integration 
to the VFP project. Because I'm so tied in to VSS I haven't pushed on it hard 
enough to figure out how well it works.

http://vfpx.codeplex.com/wikipage?title=SubFox

--
rk

-Original Message-
From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On 
Behalf Of Dave Crozier
Sent: Wednesday, September 12, 2012 9:53 AM
To: profoxt...@leafe.com
Subject: RE: Version control

Alan,
I'd totally agree. anyhow thanks for the PM's offering to help from 
everyone but I discovered an old VSS archive that has done the job so crisis 
averted but I'll certainly have a look at Christoff's stuff as a replacement.

Dave


___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/DF1EEF11E586A64FB54A97F22A8BD044216ED5F9F5@ACKBWDDQH1.artfact.local
** 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: Version control

[Paul Hill]

Dave,

Seeing as you have a MSDN license it might be worth looking into
Microsoft's Team Foundation Server.
No idea how it integrates with Fox though.

Paul

On 12 September 2012 14:52, Dave Crozier  wrote:
> Alan,
> I'd totally agree. anyhow thanks for the PM's offering to help from 
> everyone but I discovered an old VSS archive that has done the job so crisis 
> averted but I'll certainly have a look at Christoff's stuff as a replacement.
>
> Dave
>
> -Original Message-
> From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of 
> Alan Bourke
> Sent: 12 September 2012 12:44
> To: profox@leafe.com
> Subject: Re: Version control
>
> I'd say this is about on the money regarding SourceSafe:
>
> http://www.codinghorror.com/blog/2006/08/source-control-anything-but-sourcesafe.html
>
> I use it for VFP stuff at work because I have to but for everything else I 
> use Subversion.

-- 
Paul

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/cadwx0+ju-bt4apdeep8-xbbkthko+_uqngtzmt2-ekfbcnr...@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: Version control

[Dave Crozier]

Alan,
I'd totally agree. anyhow thanks for the PM's offering to help from 
everyone but I discovered an old VSS archive that has done the job so crisis 
averted but I'll certainly have a look at Christoff's stuff as a replacement.

Dave

-Original Message-
From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of 
Alan Bourke
Sent: 12 September 2012 12:44
To: profox@leafe.com
Subject: Re: Version control

I'd say this is about on the money regarding SourceSafe:

http://www.codinghorror.com/blog/2006/08/source-control-anything-but-sourcesafe.html

I use it for VFP stuff at work because I have to but for everything else I use 
Subversion.
--
  Alan Bourke
  alanpbourke (at) fastmail (dot) fm


[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/bd031ecabf2b60499200aab3dbb4a999f1268...@ex-a-fpl.fpl.LOCAL
** 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: Speed

[Frank Cazabon]

Sytze,

this sounds like it might be the oplocks problem where an application 
runs perfectly fine when only one user is logged in but slows down when 
more than one logs in.

Here are my notes on switching this off.

http://oplocks.net/how-to-disable-win32  


Multiuser system speed

1. Set OPLocks off for increased speed in multiuser systems

HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\MRXSmb\Parameters\

set OplocksDisabled = 1

OplocksDisabled REG_DWORD 0 or 1
Default: 0 (not disabled)

2. HKLM\System\CurrentControlSet\Services\LanmanServer\Parameters

SharingViolationRetries REG_DWORD 0?1000 attempts

Default: 5

Determines the maximum number of times the Server service attempts a 
file operation when the file system responds with a sharing violation 
error. If a client requests more attempts that the value of this entry 
allows, the Server service returns an error. This value entry applies to 
open, rename, and delete operations.

Note

Windows NT does not add this value to the Registry. You can add it by 
editing the Registry or by using a program that edits the Registry.

SharingViolationDelay REG_DWORD 0?1000 milliseconds

Default: 200

Determines the time interval between repeated requests for a file 
operation when the file system responds with a sharing violation error. 
This value entry applies to open, rename, and delete operations.
Decreasing this value (requesting more frequently) increases network 
traffic. However, increasing this value (requesting less frequently) 
might delay users unnecesarily.

Note

Windows NT does not add this value to the Registry. You can add it by 
editing the Registry or by using a program that edits the Registry.




Frank.

Frank Cazabon

On 11/09/2012 10:08 PM, Sytze de Boer wrote:
> Running with 100 Mbit cable and swith, I get 30 secs and 5 secs on
> subsequent runs
> Running Gigabit cable and switch, I get 7 secs and 2 secs on subsequent runs
>
> If I log in 2 users (where 2nd user does nothing except log in to the App)
> , running 100 Mbit, time is 60 secs



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

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/50507c4d.9040...@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: Version control

[Alan Bourke]

I'd say this is about on the money regarding SourceSafe:

http://www.codinghorror.com/blog/2006/08/source-control-anything-but-sourcesafe.html

I use it for VFP stuff at work because I have to but for everything else
I use Subversion.
-- 
  Alan Bourke
  alanpbourke (at) fastmail (dot) fm


___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/1347450255.31415.140661126909201.44e2c...@webmail.messagingengine.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: Version control

[Dave Crozier]

Yep,
Tried all of those to no avail.

Dave

-Original Message-
From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of 
Peter Cushing
Sent: 12 September 2012 11:41
To: profox@leafe.com
Subject: Re: Version control

Dave Crozier wrote:
> Peter,
> Well in retrospect that is what I should have done as I didn't notice the 
> initial corruption or when it happened and more important WHY! The existing 
> forms etc have been checking in no problem at all but retrieving ANY older 
> version just results in an error on ALL forms all versions!
>
> Garrett, thanks for that, I'll take a look.
>   
>
Dave,

Have you tried to fix the VSS data with any utilities, E.g.

http://msdn.microsoft.com/en-us/library/ysxsfw4x%28v=vs.80%29.aspx

Worth a shot if you can't get anything out of it.

Peter





Rajan Imports has changed - we are now Whispering Smith Ltd.  For more 
information see our website at www.whisperingsmith.com


Please update your address book with my new email address: 
pcush...@whisperingsmith.com

.

This communication is intended for the person or organisation to whom it is 
addressed.  The contents are confidential and may be protected in law.  
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.

www.whisperingsmith.com

Whispering Smith Ltd
Head Office:61 Great Ducie Street, Manchester M3 1RR. Tel:0161 831 3700 
Fax:0161 831 3715 London Office:17-19 Foley Street, London  W1W 6DW Tel:0207 
299 7960


[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/bd031ecabf2b60499200aab3dbb4a999f1268...@ex-a-fpl.fpl.LOCAL
** 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: Version control

[Peter Cushing]

Dave Crozier wrote:
> Peter,
> Well in retrospect that is what I should have done as I didn't notice the 
> initial corruption or when it happened and more important WHY! The existing 
> forms etc have been checking in no problem at all but retrieving ANY older 
> version just results in an error on ALL forms all versions!
>
> Garrett, thanks for that, I'll take a look.
>   
>
Dave,

Have you tried to fix the VSS data with any utilities, E.g.

http://msdn.microsoft.com/en-us/library/ysxsfw4x%28v=vs.80%29.aspx

Worth a shot if you can't get anything out of it.

Peter





Rajan Imports has changed - we are now Whispering Smith Ltd.  For more 
information see our website at www.whisperingsmith.com


Please update your address book with my new email address: 
pcush...@whisperingsmith.com

.

This communication is intended for the person or organisation to whom it is 
addressed.  The contents are confidential and may be protected in law.  
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.

www.whisperingsmith.com

Whispering Smith Ltd
Head Office:61 Great Ducie Street, Manchester M3 1RR. Tel:0161 831 3700 
Fax:0161 831 3715
London Office:17-19 Foley Street, London  W1W 6DW Tel:0207 299 7960


___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/505066c1.1070...@whisperingsmith.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: Version control

[Dave Crozier]

Peter,
Well in retrospect that is what I should have done as I didn't notice the 
initial corruption or when it happened and more important WHY! The existing 
forms etc have been checking in no problem at all but retrieving ANY older 
version just results in an error on ALL forms all versions!

Garrett, thanks for that, I'll take a look.

Dave

-Original Message-
From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of 
Peter Cushing
Sent: 12 September 2012 11:30
To: profox@leafe.com
Subject: Re: Version control

Dave Crozier wrote:
> I have had very few occasions to use version control when using VFP but as we 
> are involved in a really large conversion job here I decided 3 months ago to 
> use a formal method of version control and as such decided on the old chesnut 
> Visual Source Safe as we have it under our MSDN agreement and it obviously 
> seems to fit in seamlessly (laugh out loud!!) with VFP.
>
> 
> Dave
>
>   
I'm also using VSS at the moment, but also like to back that up with a disk 
copy every couple of months.  I just modify a batch file to include the stuff I 
want, then this gets copied to a server that gets backed up and I zip it up 
there, test the zip file and done.  Any large mods on a form say and I will go 
to the next number myform1 myform2 etc.  Then your new version can't screw up 
the old one.

I do find VSS a bit clunky and had a brief look round when I went to windows 7 
but nothing struck me as easy to use where I could also import the VSS data.  
Maybe I'll have to review them again.

Peter





Rajan Imports has changed - we are now Whispering Smith Ltd.  For more 
information see our website at www.whisperingsmith.com


Please update your address book with my new email address: 
pcush...@whisperingsmith.com

.

This communication is intended for the person or organisation to whom it is 
addressed.  The contents are confidential and may be protected in law.  
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.

www.whisperingsmith.com

Whispering Smith Ltd
Head Office:61 Great Ducie Street, Manchester M3 1RR. Tel:0161 831 3700 
Fax:0161 831 3715 London Office:17-19 Foley Street, London  W1W 6DW Tel:0207 
299 7960


[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/bd031ecabf2b60499200aab3dbb4a999f1268...@ex-a-fpl.fpl.LOCAL
** 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: Version control

[Peter Cushing]

Dave Crozier wrote:
> I have had very few occasions to use version control when using VFP but as we 
> are involved in a really large conversion job here I decided 3 months ago to 
> use a formal method of version control and as such decided on the old chesnut 
> Visual Source Safe as we have it under our MSDN agreement and it obviously 
> seems to fit in seamlessly (laugh out loud!!) with VFP.
>
> 
> Dave 
>
>   
I'm also using VSS at the moment, but also like to back that up with a 
disk copy every couple of months.  I just modify a batch file to include 
the stuff I want, then this gets copied to a server that gets backed up 
and I zip it up there, test the zip file and done.  Any large mods on a 
form say and I will go to the next number myform1 myform2 etc.  Then 
your new version can't screw up the old one.

I do find VSS a bit clunky and had a brief look round when I went to 
windows 7 but nothing struck me as easy to use where I could also import 
the VSS data.  Maybe I'll have to review them again.

Peter





Rajan Imports has changed - we are now Whispering Smith Ltd.  For more 
information see our website at www.whisperingsmith.com


Please update your address book with my new email address: 
pcush...@whisperingsmith.com

.

This communication is intended for the person or organisation to whom it is 
addressed.  The contents are confidential and may be protected in law.  
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.

www.whisperingsmith.com

Whispering Smith Ltd
Head Office:61 Great Ducie Street, Manchester M3 1RR. Tel:0161 831 3700 
Fax:0161 831 3715
London Office:17-19 Foley Street, London  W1W 6DW Tel:0207 299 7960


___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/5050643d.5030...@whisperingsmith.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: Version control

[Garrett Fitzgerald]

On Wed, Sep 12, 2012 at 5:56 AM, Dave Crozier  wrote:

> Never having used alternative software, I think Paul McNett dabbled with
> subversion using VFP and wonder if anyone has any comments on what to use
> and why. I know about the format of VFP forms etc. being a pain as they are
> not simple text.
>

I've been using Subversion with Christof's TwoFox tool to convert the
binary files to and from text. A lot of people swear by git, but it doesn't
make as much sense to me as svn does. YMMV, of course.

http://subversion.apache.org/
http://www.foxpert.com/docs/cvs.en.htm


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

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/cagd8mrfakyq_p+zf2hjchpa8gpwessp014wlayynmb19dfv...@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: Speed

[Dave Crozier]

Oh yes and I forgot to add have you tried running the program (aka 30 mins) 
then reindexing the tables and re-running it. Once again the indexes could all 
be in need of re-organisation.


-Original Message-
From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of 
Sytze de Boer
Sent: 12 September 2012 02:36
To: profox
Subject: Speed

I'm losing my mind over this

At a client site, they run a report which can take 30 mins to generate, over 
the network When they run it on a local pc, it takes 5 secs

Without boring you with all the details, essentially, the following code makes 
up the report *trcask4=a date *trcask5=a date

   Select Date,stockcode,stktype,invnum,qty,ttlamount,disc,ppb,cost,Desc,
"H" As SRCE From winhst   Where Between(Date,trcask4,trcask5) Union All;
   Select Date,stockcode,stktype,invnum,qty,ttlamount,disc,ppb,cost,Desc,
"I" As SRCE  From wininvs  Where Between(Date,trcask4,trcask5) Union All ;
   Select Date,stockcode,stktype,invnum,qty,ttlamount,disc,ppb,cost,Desc,
"J" As SRCE From wintime  Where Between(Date,trcask4,trcask5) Into Table
(myfile)

The Winhst file has about 500,000 records The other 2 less than a 1000 combined

There seems to be a big difference in time if no-ones else has logged into the 
app from a different workstation

Can anyone suggest a way to make this go quicker?


--
Kind regards
Sytze de Boer
Kiss Software


--- 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: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/bd031ecabf2b60499200aab3dbb4a999f1268...@ex-a-fpl.fpl.LOCAL
** 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: Speed

[Dave Crozier]

Sytze, 
Firstly I would do like Paul suggests and split the unions up to catch data 
into three separate cursors curA, curB and curC then do a "select * from curA 
union all select * from curB ... into cursor curResult" etc. Doing it this way 
you can at least find out which select is taking the time using the rushmore 
settings that Jean detailed.

One thing to look at is the amount of deleted records you may/may not have in 
the tables. Your 500K records may be more if there are lots of deleted records 
you can't initially see because of your "set deleted" setting. Lots of deleted 
records in one section of the table really do screw up access times as the 
indexes become unbalanced. If this is the case then add an index on deleted() 
to the table. I have found, contrary to mainstream opinion that this 
dramatically improves SQL select access times despite the fact that it is well 
documented that it shouldn't. 

In addition as Jean also previously said change the syntax to be .. Date 
between trcask4 and trcask5 ...

You can bet that the solution will be trivial and staring you in the face... 
it's always that way!

Dave


-Original Message-
From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of 
Sytze de Boer
Sent: 12 September 2012 02:36
To: profox
Subject: Speed

I'm losing my mind over this

At a client site, they run a report which can take 30 mins to generate, over 
the network When they run it on a local pc, it takes 5 secs

Without boring you with all the details, essentially, the following code makes 
up the report *trcask4=a date *trcask5=a date

   Select Date,stockcode,stktype,invnum,qty,ttlamount,disc,ppb,cost,Desc,
"H" As SRCE From winhst   Where Between(Date,trcask4,trcask5) Union All;
   Select Date,stockcode,stktype,invnum,qty,ttlamount,disc,ppb,cost,Desc,
"I" As SRCE  From wininvs  Where Between(Date,trcask4,trcask5) Union All ;
   Select Date,stockcode,stktype,invnum,qty,ttlamount,disc,ppb,cost,Desc,
"J" As SRCE From wintime  Where Between(Date,trcask4,trcask5) Into Table
(myfile)

The Winhst file has about 500,000 records The other 2 less than a 1000 combined

There seems to be a big difference in time if no-ones else has logged into the 
app from a different workstation

Can anyone suggest a way to make this go quicker?


--
Kind regards
Sytze de Boer
Kiss Software


--- 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: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/bd031ecabf2b60499200aab3dbb4a999f1268...@ex-a-fpl.fpl.LOCAL
** 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.