Query has very basic structure for rushmore

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

Query has very basic structure for rushmore

Message

From

07/07/2005 11:10:45

Ali Altun
World Media Group Ag
Offenbach Am Main, Germany

07/07/2005 10:58:32

Tore Bleken (Online)
Vear, Norway

General information

Forum:

Visual FoxPro

Category:

Databases,Tables, Views, Indexing and SQL syntax

Title:

Re: Query has very basic structure for rushmore

Environment versions

Visual FoxPro:

VFP 9

OS:

Windows XP SP2

Network:

Windows 2003 Server

Database:

Visual FoxPro

Miscellaneous

Thread ID:

01029945

Message ID:

01029964

Views:

> Check CPCURRENT() and CPDBF(). If they don't match, VFP9 won't use
> indexes on character expressions for optimization. VFP8 behaved
> differently, but this could cause wrong results

Although I have known this issue older thread, I controled again

? CPCURRENT() && 1254
? cpdbf("ABONE") && 1254
? cpdbf("HURUN") && 1254
? cpdbf("EKLER") && 1254

Map

View

Click here to load this message in the networking platform