It may be an issue with a date column in FP that is not the same thing in
newer versions of SQL Server.
It may be a lot of other things as well, this is first guess.
How many gigs of data?
What version of SQL are you targeting? Are you using SSMS to work with
SQL? With that you could PULL
Hi
Don't know if this upsize code will help anybody else but will share it.
This has been run with SQL express 2008r2
Run the upsizing wizard to send the structure with no data. Run this on a
backup of the fox data.
This uses Pauls CABuilder to generate CursorAdapters for the SQL database
.
On Fri, Oct 6, 2023 at 10:20 AM Paul H. Tarver wrote:
> I wondered the same thing, but when I checked it out, I found that is a
> slightly pricier version of the SQL management tool I use which is from EMS
> Software Management. I think both Navicat and the EMS solutions occupy the
>
I wondered the same thing, but when I checked it out, I found that is a
slightly pricier version of the SQL management tool I use which is from EMS
Software Management. I think both Navicat and the EMS solutions occupy the same
space and appear to offer the same features but I've been using EMS
When I first started decades ago, I would attempt to use phpmyadmin to
import 600,000 plus record tables and it would always break.
Once I finally realized that it was a problem with phpmyadmin and started
using navicat, haven't had a problem since.
It's basically like the sql server
Thanks. I'll take a look.
-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Virgil Bierschwale
Sent: 06 October 2023 11:42
To: ProFox Email List
Subject: Re: FW: SQL Upsize
https://navicat.com/en/
On Fri, Oct 6, 2023 at 3:11 AM Graham Brown wrote
mail List
> Subject: Re: FW: SQL Upsize
>
> I use navicat.
> copy the dbf to csv or txt.
> use navicat to connect to sql server.
> and then do a import.
>
> I've added about 10GB data to mysql that way and it works pretty good.
> they have a version for sql server as well.
>
Thanks
What is Navicat?
-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Virgil Bierschwale
Sent: 05 October 2023 20:04
To: ProFox Email List
Subject: Re: FW: SQL Upsize
I use navicat.
copy the dbf to csv or txt.
use navicat to connect to sql server
I use navicat.
copy the dbf to csv or txt.
use navicat to connect to sql server.
and then do a import.
I've added about 10GB data to mysql that way and it works pretty good.
they have a version for sql server as well.
On Thu, Oct 5, 2023 at 11:36 AM Graham Brown wrote:
> Hi
> Thanks
&
Are you using the Upsizing Wizard? If so, have you gotten the latest and
greatest from Github/VFPX? It’s been updated a few times over the years and one
of the changes IIRC was to better handle newer versions of SQL. Well, newer
than what was around at the time. Highly recommended. Using SQL
going to try is manually creating the insert sql commands
and run these in EM, just a pita if I am missing something obvious.
Interesting one.
Graham
-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Kurt Wendt
Sent: 05 October 2023 17:21
To: ProFox Email List
is this - did your Process at least create the Database
files in SQL - and SOME of the records did make it into the Database? If
so, why not push the records into SQL Databases from FoxPro after the SQL
databases were already created?
Now, I know - it's Not Addressing your original problem. But, I
Hi all
I am upsizing a Foxpro DBC to SQL 2008 r2. This worked fine with earlier
versions of SQL but gives errors to newer versions of SQL. I am using ODBC
rather than Native client although it doesn't make any difference to the
errors.
For one specific table the upsize says 988 rows failed
Most probably not. We were looking for test students for a new integration.
While our student records system has dev, test, and prod, the immunization
tracker is live, so we can only mess with it Very Carefully. :)
I'll read up on those other two options just in case, though. I know what
they
As usual, the devil's in the details. With more details, there might
have been more elegant solutions. Oracle has options like
Cross-tabulation and Pivot that might give you the results you want,
especially if this turns out to be an ongoing request with new
vaccines coming around.
On Thu, Jun
Yeah, that was the q way I ended up implementing it - with 7 child
tables. :) I just couldn't believe nobody had added an idiomatic way to do
it in the language without jumping through hoops to get them. It's an
immunization record - I wanted all the students that had shots for Measles
1, Measles
What's the relationship between parents and children (Isn't that the
universal question?)
If parents can have many children and children can have many parents,
is there a M:M table to link them?
If a child record has a single ParentFK, that's kinda sad. If you
want Parents that have *ALL FOUR*
Garrett,
Something like this?
http://sqlfiddle.com/#!4/5ba4f0/2
On Thu, Jun 22, 2023 at 12:23 PM Garrett Fitzgerald
wrote:
> Is there an idiomatic way to get parent records that have all of the child
> records a, b, c, and d, short of joining the child table 4 times? Oracle
> 19, if it's
...@leafe.com
Subject: [NF] SQL ALL, but not quite
Is there an idiomatic way to get parent records that have all of the child
records a, b, c, and d, short of joining the child table 4 times? Oracle
19, if it's relevant.
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text
Is there an idiomatic way to get parent records that have all of the child
records a, b, c, and d, short of joining the child table 4 times? Oracle
19, if it's relevant.
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text body -- kept)
text/html
---
o:profoxtech-boun...@leafe.com] On Behalf Of Jeff
Roberts
Sent: Friday, April 15, 2022 9:49 AM
To: profoxt...@leafe.com
Subject: can visual foxpro create a table inside a sql statement?
I've been watching a video tutorial called "Mastery with SQL" that uses
Postgres for the back end. At
ts wrote:
> > I've been watching a video tutorial called "Mastery with SQL" that uses
> > Postgres for the back end. At one point while talking about subqueries
> the
> > instructor runs the following SQL query:
> >
> > SELECT * FROM (values ('short'
stery with SQL" that uses
Postgres for the back end. At one point while talking about subqueries the
instructor runs the following SQL query:
SELECT * FROM (values ('short', 0, 60), ('medium', 60, 120), ('long', 120,
1)) as c("desc", "min", "max");
I've been watching a video tutorial called "Mastery with SQL" that uses
Postgres for the back end. At one point while talking about subqueries the
instructor runs the following SQL query:
SELECT * FROM (values ('short', 0, 60), ('medium', 60, 120), ('long', 120,
1)) as c("des
- Develop a system to synchronize data between FoxPro and SQL Server
databases.
https://codemag.com/Jobs/Apply/03bfd079-f665-43af-a1de-a8eab5c964fa
Probably remote and it gets you noticed at Code mag for future work.
--
Stephen Russell
Sr. Analyst
Ring Container Technology
Oakland TN
+1
John Weller
07976 393631
> -Original Message-
> From: ProfoxTech On Behalf Of AndyHC
> Sent: 07 January 2022 17:14
> To: profoxt...@leafe.com
> Subject: Re: VFP9 and SQL memo fields - SOLVED
>
> On 06-Jan-22 7:54 AM, kbe...@mchsi.com wrote:
> > So
>
On 06-Jan-22 7:54 AM, kbe...@mchsi.com wrote:
So
the cloud provider somehow talked the hackers into reducing the ransom to
$50,000 and they paid it 2 days after Christmas.
They should be prosecuted for paying it! - AndyD
--- StripMime Report -- processed MIME parts ---
Ok sorry to bother everyone, this is no longer a problem and never was an SQL
problem.
The cloud provider the client was using got hacked with ransomware 3 days
before Christmas and
shut down the entire operation and all the companies that were running on their
servers. The original
ransom
but installing a driver on its own
won’t change anything.
Has the connection string for the application been changed to use 17?
I don’t think there is an “ODBC Driver 11 for SQL Server” but I could
be wrong. There’s definitely a 13 and a 17. There is also “SQL Server
Native Client 11.0
there is an “ODBC Driver 11 for SQL Server” but I could be wrong.
There’s definitely a 13 and a 17. There is also “SQL Server Native Client 11.0”.
Is it possible to use ODBC Manager in the environment in question to create a
connection to the SQL Server the EXE uses? If that works, then you know
Not trying to be obnoxious here but installing a driver on its own won’t change
anything.
Has the connection string for the application been changed to use 17?
I don’t think there is an “ODBC Driver 11 for SQL Server” but I could be wrong.
There’s definitely a 13 and a 17. There is also “SQL
Tm90IHRyeWluZyB0byBiZSBvYm5veGlvdXMgaGVyZSBidXQgaW5zdGFsbGluZyBhIGRyaXZlciBv
biBpdHMgb3duIHdvbuKAmXQgY2hhbmdlIGFueXRoaW5nLiDwn5iKDQoNCkhhcyB0aGUgY29ubmVj
dGlvbiBzdHJpbmcgZm9yIHRoZSBhcHBsaWNhdGlvbiBiZWVuIGNoYW5nZWQgdG8gdXNlIDE3Pw0K
I am pretty sure we are using Microsoft ODBC Driver 11 for SQL Server
I think they tried to install ODBC Driver 17 and had the same results
- Original Message -
From: "Richard Kaye"
To: "ProFox Email List"
Sent: Wednesday, January 5, 2022 8:43:26 AM
Subject: R
Do you know what SQL driver your EXE is currently using?
--
rk
From: ProfoxTech On Behalf Of kbe...@mchsi.com
Sent: Tuesday, January 4, 2022 8:48 PM
To: profoxt...@leafe.com
Subject: Re: VFP9 and SQL memo fields
Yes it is a compiled EXE for a legacy app that has been running great for years
Yes it is a compiled EXE for a legacy app that has been running great for years.
I am using West-Wind wwSQL class to execute Queries and Stored procedures. I
don't think it is remote views.
I call the method and it returns a cursor or an oData object.
I hope that helps as I am not an SQL
Can you provide some more context, Kent? Compiled EXE? Ad-hoc queries via SQL
pass-through? Remove views?
--
rk
From: ProfoxTech On Behalf Of kbe...@mchsi.com
Sent: Tuesday, January 4, 2022 4:54 PM
To: profoxt...@leafe.com
Subject: VFP9 and SQL memo fields
Happy New Year !!
I have a client
Happy New Year !!
I have a client trying to upgrade their SQL 2012 server to 2016 but we are
having a problem with the TEXT data type only returning 400 characters. We
tried to change to VARCHAR(Max) but that returns the same 400 character limit.
I am not an SQL expert so I am not sure what
Thanks folks.
--
Alan Bourke
alanpbourke (at) fastmail (dot) fm
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list:
There are also several utilities in the leafe.com downloads, by Kevin Cully
and Ed Leafe. I searched for "create" and then selected VFP in the search
dialogs.
On Thu, Sep 2, 2021 at 7:06 AM Alan Bourke wrote:
> In MSSQL you can script a table out to a Transact SQL script, including
Wasn't there a Thor tool that did that?
On Thu, Sep 2, 2021 at 8:13 AM Vince Teachout wrote:
> I've got a tool that I wrote years ago that takes an open table and
> scripts it to a VFP Create Table or an MSSQL Create table.
>
> Also one that creates SQL Select statements for a
I've got a tool that I wrote years ago that takes an open table and
scripts it to a VFP Create Table or an MSSQL Create table.
Also one that creates SQL Select statements for an open alias and Insert
statements (That last one is buggy)
If you're interested, I could send you the code.
On 09
le out to a Transact SQL script, including all
CREATE statements and multiple INSERT statements for the data.
Is there a VFP equivalent that anyone knows of? This is for including test data
in source control, it's better to have a PRG that can generate the database
than adding binary DBF fil
In MSSQL you can script a table out to a Transact SQL script, including all
CREATE statements and multiple INSERT statements for the data.
Is there a VFP equivalent that anyone knows of? This is for including test data
in source control, it's better to have a PRG that can generate the database
you weren't aware that NOT EMPTY appears to be unable to use
Rushmore optimization...
There is a regular index on the order.srep field. I added the SETs to
emulate the environment per legacy code.
The results are why I changed the original author's NOT EMPTY(field1)
SQL to field1 <> &quo
In case you weren't aware that NOT EMPTY appears to be unable to use
Rushmore optimization...
There is a regular index on the order.srep field. I added the SETs to
emulate the environment per legacy code.
The results are why I changed the original author's NOT EMPTY(field1)
SQL to field1
In our case, we require that our clients provide us with secure VPN access
to their network. All of our development and support is done across this vpn
connection and NOT to port open to the internet. Once our application is
installed within their network access to their self-hosted SQL is already
Have you considered the firewall port requirements involved for your clients in
the generally inadvisable process of exposing a SQL Server directly to the
internet?
--
Alan Bourke
alanpbourke (at) fastmail (dot) fm
___
Post Messages to: ProFox
I've not been able to make Windows Authentication work in the past, but I'll
keep that in mind and try it again sometime. So far, my clients have been
accommodating in terms of creating SQL Credentials. I also only need
Read/Only rights for the work I do, so that helps with their security
concerns
I do this with multiple applications and we handle it using a DSN-less
connection. The only requirement for the pc is a 32-bit MS SQL ODBC driver
must be installed, but no DSN needs to be created on the computer. Also, you
must have SQL Credentials configured on the SQL Server as you cannot use
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard
Kaye
Sent: Thursday, February 11, 2021 12:05 PM
To: profoxt...@leafe.com
Subject: RE: sql server connection
Really? All you have to do is set trusted=yes in the conn string, afaik. But
I could
And installing the 64 bit driver will include the 32 bit driver.
--
rk
-Original Message-
From: ProfoxTech On Behalf Of Richard Kaye
Sent: Thursday, February 11, 2021 1:05 PM
To: profoxt...@leafe.com
Subject: RE: sql server connection
Really? All you have to do is set trusted=yes
Really? All you have to do is set trusted=yes in the conn string, afaik. But I
could be wrong. We only use SQL security accounts in our environment.
I'm sure it's been mentioned before but this is a good resource for connection
strings - https://www.connectionstrings.com/sql-server/
--
rk
ael,
>
> They'll have to have the driver installed in order to talk to SQL Server.
> The best way is to provide them with an Installer program (use InnoSetup -
> free and easy) that installs your app as well as the driver. It can add a
> DSN too, although you may want to consider hardcodi
On 02/11/21 9:20 AM, Rafael Copquin wrote:
Hi Vince
I understand your example. Actually I used it and my test worked like a
charm.
However, wouldn't it require that my clients have the SQL Server Native
Client version already installed in their computers?
Rafael
The drivers, yes, but those
r to talk to SQL Server.
> The best way is to provide them with an Installer program (use InnoSetup -
> free and easy) that installs your app as well as the driver. It can add a
> DSN too, although you may want to consider hardcoding that connection
> string into your EXE so the password isn
Rafael,
They'll have to have the driver installed in order to talk to SQL Server.
The best way is to provide them with an Installer program (use InnoSetup -
free and easy) that installs your app as well as the driver. It can add a
DSN too, although you may want to consider hardcoding
I have a VFP) app that uses MS sqlserver as backend. The SQL Server is
located in a web provider
The connection is achieved by creating a DSN throught the ODBC driver in my
PC
I need to deploy this app to several clients. But none of them should use
their ODBC driver to create the connection
ng the record
pointer
is also trying to lock the row. Do you have SET MULTILOCKS ON?
--
rk
-Original Message-
From: ProfoxTech On Behalf Of Richard
Kaye
Sent: Thursday, October 22, 2020 3:28 PM
To: profoxt...@leafe.com
Subject: RE: COUNT FOR hangs on record locking, but SQL -
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
n g1.iid = p1.iid
>
> What's wrong with my code for this simple UPDATE SQL ?
>
> Here's the full segment to put it in context (with curToDo being the
> subset of Carriers_To_Process and curUniques being the unique ven_id
> field (so that we don't process a ven_id twice):
>
>
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
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
carriers_to_process p1 ;
INNER JOIN curWorkingGroup g1 on g1.iid = p1.iid
What's wrong with my code for this simple UPDATE SQL ?
Here's the full segment to put it in context (with curToDo being the
subset of Carriers_To_Process and curUniques being the unique ven_id
field (so
, and vfp table size is tiny. Local ram
always kicks ass. My current db file is 1.8TB. My SQL server in Prod has
60 gig of ram for the instance that holds my ERP db. It jams for doing the
traditional functionality all day, any day. Nightly we pull
relevant business data into our DW. Against
>> 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
sn't need to move the record
> pointer
> >> in the source table. And I'll return to how your environment is setup.
> I'd
> >> have to go read the fine docs to understand why moving the record
> pointer
> >> is also trying to lock the row. Do you have SET MULT
hangs on record locking, but SQL - SELECT
COUNT(*) works with no issue. Why?
Leaving aside the environment stuff like SET EXCLUSIVE and SET
MULTILOCKS, my first guess is COUNT FOR actually moves the record pointer
through every row in the table, Whereas SELECT COUNT() is reading the
Thanks, it makes sense not to reveal true identities. gl is "general ledger"?
> On 24. Oct 2020, at 18:04, Stephen Russell wrote:
>
> glTable600 was replacing the true table name because we don't state true
> identities. It is our gl transaction table and it is a beast in size.
---
glTable600 was replacing the true table name because we don't state true
identities. It is our gl transaction table and it is a beast in size.
On Sat, Oct 24, 2020 at 10:43 AM Christof Wollenhaupt <
chris...@wollenhaupt.org> wrote:
> SQL server works completely differently from FoxPro
SQL server works completely differently from FoxPro. For Sql Server the
performance even on the same system would heavily depend on the isolation level
you use, concurrent access and memory usage. I've consulted on SQL server
databases projects in the close to a TB database size range where
f Richard
> Kaye
> > Sent: Thursday, October 22, 2020 3:28 PM
> > To: profoxt...@leafe.com
> > Subject: RE: COUNT FOR hangs on record locking, but SQL - SELECT
> COUNT(*) works with no issue. Why?
> >
> > Leaving aside the environment stuff like SET EXCLUSIVE and SET
(or CALC or SUM etc) take into account? That's why it's waiting
until he's finished. Of course, for a perfect waiting experience, you should
SET REPROCESS correctly.
A SQL COUNT just takes a snapshot of the buffered data before the edit.
wOOdy
-Ursprüngliche Nachricht-
Von: ProFox Im
Definitely SET EXCL OFF since it's a multi-user app.
My money is on wOOdy. I honestly think I had asked something like this
years ago but forgot the details.
On 10/23/2020 3:33 PM, Richard Kaye wrote:
Other than the differences in the internals between an xBase function versus
the SQL
until he's finished. Of course, for a perfect waiting experience, you should
SET REPROCESS correctly.
A SQL COUNT just takes a snapshot of the buffered data before the edit.
wOOdy
-Ursprüngliche Nachricht-
Von: ProFox Im Auftrag von MB Software Solutions, LLC
Gesendet: Donnerstag, 22
Other than the differences in the internals between an xBase function versus
the SQL engine I'm out of guesses. I bet Christof (or Chen) could explain it...
I still don't understand why it's attempting to get a row lock. What about SET
EXCLUSIVE?
--
rk
-Original Message-
From
-Original Message-
From: ProfoxTech On Behalf Of Richard Kaye
Sent: Thursday, October 22, 2020 3:28 PM
To: profoxt...@leafe.com
Subject: RE: COUNT FOR hangs on record locking, but SQL - SELECT COUNT(*) works
with no issue. Why?
Leaving aside the environment stuff like SET EXCLUSIVE and SET
is also trying
to lock the row. Do you have SET MULTILOCKS ON?
--
rk
-Original Message-
From: ProfoxTech On Behalf Of Richard Kaye
Sent: Thursday, October 22, 2020 3:28 PM
To: profoxt...@leafe.com
Subject: RE: COUNT FOR hangs on record locking, but SQL - SELECT COUNT(*) works
: Thursday, October 22, 2020 3:24 PM
To: profoxt...@leafe.com
Subject: COUNT FOR hangs on record locking, but SQL - SELECT COUNT(*) works
with no issue. Why?
VFP9SP3
Why would a COUNT FOR hang ("Attempting to lock") whereas my easy workaround is SELECT
COUNT(*) FROM SomeCursor WHERE &l
Solutions, LLC
Sent: Thursday, October 22, 2020 3:24 PM
To: profoxt...@leafe.com
Subject: COUNT FOR hangs on record locking, but SQL - SELECT COUNT(*) works
with no issue. Why?
VFP9SP3
Why would a COUNT FOR hang ("Attempting to lock") whereas my easy workaround is
SELECT COU
VFP9SP3
Why would a COUNT FOR hang ("Attempting to lock") whereas my easy
workaround is SELECT COUNT(*) FROM SomeCursor WHERE <> ??
tia,
--Mike
--
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
+1
Paul H. Tarver
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard
Kaye
Sent: Wednesday, October 07, 2020 2:42 PM
To: profoxt...@leafe.com
Subject: RE: [NF] SQL Server access via ODBC won't work from one workstation
Hosts file?
--
rk
Hosts file?
--
rk
-Original Message-
From: ProfoxTech On Behalf Of Ted Roche
Sent: Wednesday, October 7, 2020 2:53 PM
To: profoxt...@leafe.com
Subject: Re: [NF] SQL Server access via ODBC won't work from one workstation
On Wed, Oct 7, 2020 at 4:49 AM Alan Bourke wrote:
> W
On Wed, Oct 7, 2020 at 4:49 AM Alan Bourke wrote:
> What version is SQL Server? There was a cumulative update to SQL Server
> 2019 recently which caused a lot of problems.
>
SQL Server Express 11.0.2100.60
>
> When creating the System DSN, does it work with an IP add
What version is SQL Server? There was a cumulative update to SQL Server 2019
recently which caused a lot of problems.
When creating the System DSN, does it work with an IP address as opposed to the
hostname, i.e.
xxx.xxx.xxx.xxx\SQLEXPRESS
Is the SQL Server instance using dynamic ports
Hey, kids:
We have a couple of development workstations that use ODBC to access a SQL
Server on a third machine. Access works fine from the dusty old machine we
keep around as a spare, but just stopped working from the shiny Lenovo T590
the other coder uses and has worked fine for years. Using
Saw this on a video this morning and wanted to pass it along to you.
http://www.sommarskog.se/dynamic_sql.html
--
Stephen Russell
Sr. Analyst
Ring Container Technology
Oakland TN
901.246-0159 cell
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text
That sounds more like a program bug then... :)
That app I was talking about didn't use database container, all DBFs.
And no triggers.
On Sat, Jun 27, 2020 at 2:11 AM MB Software Solutions, LLC
wrote:
>
> How does that have anything to do with the price of tea in China? lol
>
> It wasn't that
How does that have anything to do with the price of tea in China? lol
It wasn't that an index was out of whack; it's that the attempt to fully
optimize caused VFP to unfortunately filter the table instead of give me
an inaccurate count of the cursor.
On 6/26/2020 11:06 AM, Man-wai Chang
Maybe your server should reindex all DBFs every night after office
hours! That's what an 10-year-old FoxPro/DOS MIS system I used to
maintain was doing :)
On Thu, Jun 25, 2020 at 10:33 AM MB Software Solutions, LLC
wrote:
>
> MYSTERY SOLVED! IT *WAS* THE DELETED INDEX THAT CAUSED THE CHANGE
On 6/26/2020 10:15 AM, Alan Bourke wrote:
I always just use READWRITE. Any potential few KB or microseconds saving from
not using READWRITE became meaningless many years ago.
Exactly...that's what I meant about "I'll take the sub-second
performance hit."
--
This email has been checked
I always just use READWRITE. Any potential few KB or microseconds saving from
not using READWRITE became meaningless many years ago.
--
Alan Bourke
alanpbourke (at) fastmail (dot) fm
___
Post Messages to: ProFox@leafe.com
Subscription
' Another classic case is Gender: you always get half the population as
hits.'
Not really true anymore...LOL
On Thu, Jun 25, 2020 at 2:45 PM Ed Leafe wrote:
> On Jun 24, 2020, at 21:32, MB Software Solutions, LLC <
> mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote:
> >
> > So much for my
On Jun 24, 2020, at 21:32, MB Software Solutions, LLC
wrote:
>
> So much for my seeing if the DELETED() index helped. As I said...I don't
> think any very small performance gain would be worth the aggravation this
> caused. (Made me doubt other areas working for years tooyou know, the
I did set it as BINARY index. I changed all my logical field indexes
to binary a long time ago. My reasoning for what I said is that I would
have to go back to anywhere where I didn't have the READWRITE or
NOFILTER clause and expected to show the RECCOUNT() like the example I
posted, then
The INDEX on DELETED is absolutely ok, if you do it as a BINARY index. The
BINARY index is basically the rushmore map. Each record is represented as one
bit, thus the resulting indexmap is way smaller and faster than the traditional
indexing map.
[excessive quoting removed by server]
On 6/24/2020 10:53 PM, Richard Kaye wrote:
In the real world it's probably negligible. I almost always use READWRITE.
Ditto. Successful for 20 +/- years with it. :-)
--
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
of SELECT SQL
On 6/24/2020 5:35 PM, Richard Kaye wrote:
> If you don't need the overhead of a writable cursor you can also use NOFILTER
> to force the query engine to not just do a USE...AGAIN with a filter. As for
> why now, the simplest answer I can think of is there was someth
: ProfoxTech On Behalf Of MB
Software Solutions, LLC
Sent: Wednesday, June 24, 2020 5:24 PM
To: profoxt...@leafe.com
Subject: Re: Bizarre scenario solved by READWRITE clause on end of
SELECT SQL
Correction...user is on a virtual machine with operating system being
WINDOWS 10 PRO. (Server
On 6/24/2020 5:35 PM, Richard Kaye wrote:
If you don't need the overhead of a writable cursor you can also use NOFILTER
to force the query engine to not just do a USE...AGAIN with a filter. As for
why now, the simplest answer I can think of is there was something about the
query and the
() index tags. I
know...test and find out which is betterbut if it improves some
queries but causes freak side effects like this, then no, I'll take the
subsecond hit.
On 6/24/2020 7:16 PM, Ted Roche wrote:
Mixing the DBF() model and the SQL model causes funny stuff like this. Why
it ever
1 - 100 of 3063 matches
Mail list logo