For several years, I've had a delete in a program (VFP 7.0) that is
stated:

delete from (dvyfile) where alltrim(vin)+alltrim(lastname) in (select
alltrim(vin)+alltrim(lastname) from j:\listfile)

I have an index alltrim(vin)+alltrim(lastname) in j:\listfile, and a
separate index on vin. This always ran pretty quick even good size
files on both sides of the equation. Without changing a thing, it
crawls in 9.0. Crawls to the extent of taking hours! I dropped and
recreated the indices with no change. What has happened in the
upgrade?

Monica

Try altering the setenginebhaviour setting

On 1 Sep 2006 07:19:45 -0700, "MollyShark" <mollyshark (AT) gmail (DOT) com> wrote:


--- AntiSpam/harvest ---
Remove X's to send email to me.

On 1 Sep 2006 07:19:45 -0700, "MollyShark" <mollyshark (AT) gmail (DOT) com> wrote:

Having an index on alltrim(vin) + alltrim(lastname) is kind of pointless
since VFP doesn't accept jagged length indices. It actually pads out the
index with spaces to the total size of the 2 fields so that they are all
fixed length.

I'm guessing here, but perhaps VFP9 is simply less forgiving than VFP7 was.
I never used 7 (skipped from 6 to 8), so I don't really know how version 7
worked, but since VFP9 has certainly been changed to be more ANSI standard
than previous versions, I figure it just isn't Rushmoring your query.

Check it with SYS(3054,11). I can't tell you if that sys command lives also
in vfp7.