Re: Seeker ...

IBenttini wrote:
> Hello everyone,
> I have rowsets with FNAME field = Charles and = to Cida.
> In my form seeker "EF" when I enter C or c I get Charles, because
is before 
> CI of CIDA,
> however if I should continue to add to my seeker the letter i or I, Should
I 
> go to CIDA?
> yet I dont go anywhere, WHY?
> Am I missing some in my properties? shold I miss some in my form?
> Is some thing wrong here:
> 
> this.CLIENTNA1 = new QUERY()
>    this.CLIENTNA1.parent = this
>    with (this.CLIENTNA1)
>       left = 61
>       top = 2.7273
>       sql = 'select * from "CLIENTNA.DBF"'
>       active = true
>    endwith
> 
>    with (this.CLIENTNA1.rowset)    //must exist for seeker to work
>       indexName = "FNAME"
>    endwith
> 
> If it is some wrong with the above, why is working with other forms.?
> 
> Please help when you can.
> THANKS,
> Ivan 

Ivan, is the index expression that you have for FNAME "UPPER"ed like 
this: upper(fname)? If not, "upper" it and that'll probably fix it.

The seeker converts to upper case, so whether you type in lower or 
upper, the string that is used to compare with the index is all upper 
case; but if the index string isn't uppercase ("Cida" rather than 
"CIDA", there will not be a successful find.

Hello everyone,
I have rowsets with FNAME field = Charles and = to Cida.
In my form seeker "EF" when I enter C or c I get Charles, because is
before 
CI of CIDA,
however if I should continue to add to my seeker the letter i or I, Should I 
go to CIDA?
yet I dont go anywhere, WHY?
Am I missing some in my properties? shold I miss some in my form?
Is some thing wrong here:

this.CLIENTNA1 = new QUERY()
   this.CLIENTNA1.parent = this
   with (this.CLIENTNA1)
      left = 61
      top = 2.7273
      sql = 'select * from "CLIENTNA.DBF"'
      active = true
   endwith

   with (this.CLIENTNA1.rowset)    //must exist for seeker to work
      indexName = "FNAME"
   endwith

If it is some wrong with the above, why is working with other forms.?

Please help when you can.
THANKS,
Ivan 

Thanks David,
Here is what I did, but still do not work.
////////////////////////////////////////////////////////////////////////////////
//////////
this.CLIENTNA1 = new QUERY()
   this.CLIENTNA1.parent = this
   with (this.CLIENTNA1)
      left = 61
      top = 2.7273
      sql = 'select * from "CLIENTNA.DBF"'
      active = true
   endwith

   with (this.CLIENTNA1.rowset)
     indexName = upper('FNAME')
   endwith
////////////////////////////////////////////////////////////////////////////////
///////////








"David Stone" <dlstone@wholegrain.com> wrote in message
news:z6njFsHlIHA.1688@news-server...
> IBenttini wrote:
>> Hello everyone,
>> I have rowsets with FNAME field = Charles and = to Cida.
>> In my form seeker "EF" when I enter C or c I get Charles,
because is before 
>> CI of CIDA,
>> however if I should continue to add to my seeker the letter i or I,
Should I 
>> go to CIDA?
>> yet I dont go anywhere, WHY?
>> Am I missing some in my properties? shold I miss some in my form?
>> Is some thing wrong here:
>> 
>> this.CLIENTNA1 = new QUERY()
>>    this.CLIENTNA1.parent = this
>>    with (this.CLIENTNA1)
>>       left = 61
>>       top = 2.7273
>>       sql = 'select * from "CLIENTNA.DBF"'
>>       active = true
>>    endwith
>> 
>>    with (this.CLIENTNA1.rowset)    //must exist for seeker to work
>>       indexName = "FNAME"
>>    endwith
>> 
>> If it is some wrong with the above, why is working with other forms.?
>> 
>> Please help when you can.
>> THANKS,
>> Ivan 
> 
> Ivan, is the index expression that you have for FNAME "UPPER"ed
like 
> this: upper(fname)? If not, "upper" it and that'll probably fix
it.
> 
> The seeker converts to upper case, so whether you type in lower or 
> upper, the string that is used to compare with the index is all upper 
> case; but if the index string isn't uppercase ("Cida" rather than

> "CIDA", there will not be a successful find.
> 
> David

In article <tobjh0MlIHA.1880@news-server>, hpbenttini@nc.rr.com says...
> 
> Here is what I did, but still do not work.
> //////////////////////////////////////////
>    with (this.CLIENTNA1.rowset)
>      indexName = upper('FNAME')
>    endwith
> //////////////////////////////////////////

No, this will never work. What you must do is to create an index which 
expression is UPPER(FName). Follow these steps:

A) Load your table in the Table Designer.
B) Select the menu item Structure/Manage indexes...
C) Click the "New" pushbutton
D) In the lower left corner, select the "Specify with expression" 
radiobutton.
E) In the "Index key expression" entryfield, type:
UPPER(FName)
F) At right, in the "Index name" entryfield, type: FName
G) Click the OK pushbutton.

In the contructor code of your form, put the right indexname (FName)
//////////////////////////////////////////
   with (this.CLIENTNA1.rowset)
     indexName = "FNAME"
   endwith
//////////////////////////////////////////

Jean-Pierre Martel, editor
The dBASE Developers Bulletin

Mercy Jean-Pierre,
But still did not work, what in the world am I doing wrong?
I believe I did every thing as you said, I take you very seriously.
Please help.
May I send my form to you?
Ivan



"Jean-Pierre Martel" <nospam@nospam.com> wrote in message 
news:MPG.225d65717d6aacc59898e6@news.dbase.com...
> In article <tobjh0MlIHA.1880@news-server>, hpbenttini@nc.rr.com
says...
>>
>> Here is what I did, but still do not work.
>> //////////////////////////////////////////
>>    with (this.CLIENTNA1.rowset)
>>      indexName = upper('FNAME')
>>    endwith
>> //////////////////////////////////////////
>
> No, this will never work. What you must do is to create an index which
> expression is UPPER(FName). Follow these steps:
>
> A) Load your table in the Table Designer.
> B) Select the menu item Structure/Manage indexes...
> C) Click the "New" pushbutton
> D) In the lower left corner, select the "Specify with
expression"
> radiobutton.
> E) In the "Index key expression" entryfield, type:
> UPPER(FName)
> F) At right, in the "Index name" entryfield, type: FName
> G) Click the OK pushbutton.
>
> In the contructor code of your form, put the right indexname (FName)
> //////////////////////////////////////////
>   with (this.CLIENTNA1.rowset)
>     indexName = "FNAME"
>   endwith
> //////////////////////////////////////////
>
> Jean-Pierre Martel, editor
> The dBASE Developers Bulletin
> Blue Star dBASE Plus Core Concepts Graduate