General information
Category:
Forms & Form designer
how many records are returned ?
Arnon
>like
>Select * ;
> from mytable;
> where upper(myfield) > [SOMETHING];
>into cursor
>then it going like turtle ;( (about 80-90 sec). I sure that this table
>have index Upper(myfield) and then this query should be fully
optimizable,
>but SYS(3054,11) tell me info that this query is partially optimizable. I
>can't figure out what's wrong. No matter that myfield is character, the
>same happens with numeric field
>
>Have a happy day
>Vladimir Shevchenko
>
>> In the INIT method of the grid, issue a select statement with your
>filter
>
>> as the WHERE clause. If the WHERE clause is based on Indexed fields,
>this
>
>> is very fast. Base the control source of the grid to the cursor and you
>> will get blazing performance.
>
>
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only