Hi all,

Can i test the rushmore optimisation in the clause SET FILTER TO
&MyCondition.

In myCondition , i have myCondition =" pros_user=' "+ MyVar + " ' "


Cause i test sys(3054,1,"cMemVar") or sys(3054,2,"cMemVar")

The Memvar is empty .

Have an idea , if it's possible. ?

Thank's

Olivier

Re: sys(3054) and set filter by Sergey

Sergey
Sun Jun 24 10:45:49 CDT 2007

Hi Oliver,

The SYS(3054) works for SQL commands only. You can test your filter
condition by plugging it into a SELECT

SELECT * FROM mytable WHERE &myCondition INTO CURSOR crsTemp

--
--sb--

VFP MVP

OlivierH wrote:
> Hi all,
>
> Can i test the rushmore optimisation in the clause SET FILTER TO
> &MyCondition.
>
> In myCondition , i have myCondition =" pros_user=' "+ MyVar + " ' "
>
>
> Cause i test sys(3054,1,"cMemVar") or sys(3054,2,"cMemVar")
>
> The Memvar is empty .
>
> Have an idea , if it's possible. ?
>
> Thank's
>
> Olivier

Re: sys(3054) and set filter by OlivierH

OlivierH
Mon Jun 25 04:56:55 CDT 2007

This is a multi-part message in MIME format.
--------------010702070901090206000909
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit

Thank's Sergey

I had a doubt cause the help says

SYS(3054 [, 0 | 1 | 11 | 2 | 12] [, cMEMVAR])

1 Enables the display of the Rushmore filter optimization levels.


olivier


Sergey Berezniker a écrit :
> Hi Oliver,
>
> The SYS(3054) works for SQL commands only. You can test your filter
> condition by plugging it into a SELECT
>
> SELECT * FROM mytable WHERE &myCondition INTO CURSOR crsTemp
>

--------------010702070901090206000909
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Thank's Sergey<br>
<br>
I had a doubt cause the help says<br>
<br>
<pre>SYS(3054 [, 0 | 1 | 11 | 2 | 12] [, <span class="parameter">cMEMVAR</span>])
</pre>
<dl>
<dt><span class="nonLinkTerms">1</span>
Enables the display of the Rushmore filter optimization levels.</dt>
</dl>
<br>
olivier<br>
<br>
<br>
Sergey Berezniker a &eacute;crit&nbsp;:
<blockquote cite="mid:OMwE8antHHA.4424@TK2MSFTNGP04.phx.gbl" type="cite">Hi
Oliver,
<br>
<br>
The SYS(3054) works for SQL commands only. You can test your filter
condition by plugging it into a SELECT
<br>
<br>
SELECT * FROM mytable WHERE &amp;myCondition INTO CURSOR crsTemp
<br>
<br>
</blockquote>
</body>
</html>

--------------010702070901090206000909--

Re: sys(3054) and set filter by Olaf

Olaf
Mon Jun 25 05:20:36 CDT 2007

> I had a doubt cause the help says
>
> SYS(3054 [, 0 | 1 | 11 | 2 | 12] [, cMEMVAR])
>
> 1 Enables the display of the Rushmore filter optimization levels.


First sentence:
Enables or disables display of Rushmore optimization levels for queries.

For queries (SQL) only.

Bye, Olaf.



Re: sys(3054) and set filter by Sergey

Sergey
Mon Jun 25 06:35:27 CDT 2007

Hi Oliver,

In this case 'filter' refers to WHERE conditions of SQL command

--
--sb--

VFP MVP

OlivierH wrote:
> Thank's Sergey
>
> I had a doubt cause the help says
>
> SYS(3054 [, 0 | 1 | 11 | 2 | 12] [, cMEMVAR])
>
> 1 Enables the display of the Rushmore filter optimization levels.
>
>
> olivier
>

Re: sys(3054) and set filter by OlivierH

OlivierH
Mon Jun 25 10:35:50 CDT 2007

Thank's all

And Excuse me for my insistance.

Olivier

Olaf Doschke a écrit :
>> I had a doubt cause the help says
>>
>> SYS(3054 [, 0 | 1 | 11 | 2 | 12] [, cMEMVAR])
>>
>> 1 Enables the display of the Rushmore filter optimization levels.
>>
>
>
> First sentence:
> Enables or disables display of Rushmore optimization levels for queries.
>
> For queries (SQL) only.
>
> Bye, Olaf.
>
>
>