You need to be sure as this is a big problem for data.all pc's need to be
checked.
Al
Sent from Samsung Mobile
Michael Madigan mmadi10...@yahoo.com wrote:
As far as I can tell, caching is turned off for all users and server.
From: Mike Copeland
Le 12/09/2012 05:17, Fred Taylor a écrit :
You do have an index tag on DATE in all the tables, right?
Fred
PUBLIC gcworkplan
=SYS(3092, optimisation.txt)
=SYS(3054, 12, gcworkplan)
your query goes here
=SYS(3054, 0)
=SYS(3092, )
Run this program and open the file optimisation.txt to see what
Le 12/09/2012 07:44, Fred Taylor a écrit :
Internally, I don't think there's a difference, it's just syntax.
oh, it's just a good habit to have ! First, if, one day, you want to upload
your
database towards Oracle, Sql Server, ...
The Foxil
___
Post
If the fact that more than one user is on the app slows the query, can you try
to open the tables exclusively or to FLOCK() them just to see what happens ?
Another way should be to build a COM object staying on the server and doing all
the heavy queries and creating cursors or returning XML
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
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
On Wed, Sep 12, 2012 at 5:56 AM, Dave Crozier da...@flexipol.co.uk 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
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
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!
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
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
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
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
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:
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 da...@flexipol.co.uk wrote:
Alan,
I'd totally agree. anyhow thanks for the PM's offering to
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:
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
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
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
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
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
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
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,
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
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,
Works in VFP 7, too.
Fred
On Wed, Sep 12, 2012 at 10:25 AM, Richard Kaye rk...@artfact.com 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:
http://sqlblog.com/blogs/kevin_kline/archive/2012/09/12/help-me-update-the-history-of-sql-server.aspx
--
Stephen Russell
Sr. Analyst
Ring Container Technology
Oakland TN
901.246-0159 cell
___
Post Messages to: ProFox@leafe.com
Subscription
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 srussell...@gmail.comwrote:
On Wed, Sep 12, 2012 at 12:47 PM, Fred Taylor fbtay...@gmail.com wrote:
Works in VFP 7, too.
-
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.
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
30 matches
Mail list logo