>> You never have to count the table rows itself
But but... wouldn't this only be relevant if you just want the raw
RecordCount?
As soon as you would do a COUNT FOR (or COUNT WHERE for you SQL guys) the
metadata or systemtables don't help you a dime. And VFP's queryEngine is so
intelligen
In uber complicated queries or counts, in this case, I'll add various
counts in a query that uses UNION to allow index seeks per param with an
index hint for each that I am interested in.
Granted raw VFP will pull the entire cdx into ram and probably the entire
table because we have so much ram, a
VFP9SP2 using DBC tables.
The curWorkingGroup cursor had just ONE record in it. The
Carriers_To_Process table (PK = IID field) has tens of thousands. The
idea is that I'm just processing small sections at a time from
Carriers_To_Process. Rather than update the one or two records in the
curW
You still need a WHERE clause...
--
rk
-Original Message-
From: ProfoxTech On Behalf Of MB Software
Solutions, LLC
Sent: Monday, October 26, 2020 12:06 PM
To: profoxt...@leafe.com
Subject: This SQL didn't update just one record but ALL recordsOOPS!
VFP9SP2 using DBC tables.
T
I read too fast. Ignore me.
--
rk
-Original Message-
From: ProfoxTech On Behalf Of Richard Kaye
Sent: Monday, October 26, 2020 12:12 PM
To: profoxt...@leafe.com
Subject: RE: This SQL didn't update just one record but ALL recordsOOPS!
You still need a WHERE clause...
--
rk
--
Just curious, what happens if you try this?
UPDATE carriers_to_process ;
SET cSession = this.cSession ;
FROM carriers_to_process p1,curWorkingGroup g1 ;
where g1.iid = p1.iid
That's using the old syntax inne
Hello Everyone!
I have been enjoying chatting with people and getting to see some faces of
people for the first time.
The sessions have been worth the time to watch live. There is a lot of
chatter in the chat window as well. I haven't been paying attention to the
chat much.
Maybe I'll get a cha
Putting faces to these names has been one of my favorite things about the
conference so far!
Eric
On Mon, Oct 26, 2020 at 12:41 PM Tracy Pearson
wrote:
> Hello Everyone!
>
> I have been enjoying chatting with people and getting to see some faces of
> people for the first time.
>
> The sessions
Having the legendary Dave Crozier at the event is a high point for me. And
maybe Mike Babcock can get the video thing worked out for tomorrow. 😊
--
rk
-Original Message-
From: ProfoxTech On Behalf Of Eric Selje
Sent: Monday, October 26, 2020 2:30 PM
To: profoxt...@leafe.com
Subject: Re
I didn't say it, but it was on my mind when I started the thread.
Tracy
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard Kaye
Sent: Monday, October 26, 2020 2:52 PM
To: profoxt...@leafe.com
Subject: RE: Tomorrow is the last day of Virutal Fox
Last week I wrote about this old VFP5 app that I inherited which had some
files with the phd extension. I never had heard or encountered that kind of
files but Dave Crozier helped me with them.
However, digging more deeply into this old app (which BTW I need to upgrade
to VFP9 and add some perks to
Thanks, wOOdyI failed to make that clear. ;-)
On 10/26/2020 4:05 AM, Jürgen Wondzinski wrote:
You never have to count the table rows itself
But but... wouldn't this only be relevant if you just want the raw
RecordCount?
As soon as you would do a COUNT FOR (or COUNT WHERE for you SQL
Time to use the "good" laptop. :D
On 10/26/2020 2:52 PM, Richard Kaye wrote:
Having the legendary Dave Crozier at the event is a high point for me. And
maybe Mike Babcock can get the video thing worked out for tomorrow. 😊
--
rk
-Original Message-
From: ProfoxTech On Behalf Of Eric
No, the exercise was to count something of a specific criterianot a
general RECCOUNT of the resulting dataset.
On 10/25/2020 9:00 PM, Stephen Russell wrote:
The example was to do a count(*) in VFP. You don't have these system
tables.
SELECT SCHEMA_NAME(schema_id) AS [SchemaName],
[Tables]
This thread reminds me...wasn't there a way to specify your custom file
extension rather than the native VFP ones? Wondered if anyone ever did
that (to get away from the "ew it's FoxPro!" stigma)???
On 10/26/2020 3:51 PM, Rafael Copquin wrote:
Last week I wrote about this old VFP5 app that I
It's a DLL right? How is it failing?
If it is an FLL, I'm still not sure why it wouldn't work between versions of
VFP runtimes.
Are you missing a dependency of the DLL?
Tracy
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Rafael
Copquin
Sent: Mo
Hi Tracy
It is an FLL named cpaxvfp5.fll
When I try to run the code I get the message that COMPAXION is FoxPro
version reliant.
BTW, the code used in the old app is
SET TALK OFF
SET LIBRARY TO CPAXVFP5.FLL
SET TALK ON
nRetVal=CPAX_Move('datos.cxi','bases.*')
SET TALK OFF
SET LIBRARY TO
Rafael
E
Hi Rafael,
Now I understand why it is VFP version specific FLL. If the data types used in
the DBF aren't supported, it will corrupt data.
I have not worked with that tool.
I hope you are able to get what you need to complete your task.
Tracy
-Original Message-
From: ProfoxTech [mailt
Mike,
Kind of...
The Config.FPW allows the configuration of the Label and Index extensions.
Bill Anderson
On Mon, Oct 26, 2020 at 12:56 PM MB Software Solutions, LLC <
mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote:
> This thread reminds me...wasn't there a way to specify your custom file
Hi Rafael,
CXI files are Virtual Volumes, which have been compressed with the COMPAXION
library from XITECH. Inside that CXI volumes the DBFs (or any other file) are
stored in a compressed and crypted format. Unfortunately, XiTech seems out of
business.
What you should do: Fire up VFP5, load t
+1
Paul H. Tarver
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Tracy
Pearson
Sent: Monday, October 26, 2020 12:42 PM
To: profoxt...@leafe.com
Subject: Tomorrow is the last day of Virutal Fox Fest
Hello Everyone!
I have been enjoying chatting wit
21 matches
Mail list logo
