Toggling between Sort/Index

In article <Sx6HHcoYIHA.512@news-server>, stu_serv@yahoo.com says...
> I'm using the seeker function and it only use the current index.  How can I
toggle between the different indexs via SQL? 
> 

Sheldon,

Create several ROWSET objects (each with a different ROWSET.indexName), 
but only have one SEEKER object. Switch the SEEKER.rowset property to 
the correct ROWSET for the search you want to do.

-- 
Geoff Wass [dBVIPS]
Montréal, Québec, Canada

.|.|.|        dBASE info at http://geocities.com/geoff_wass       |.|.|.
.|.|.| ---------------------------------------------------------- |.|.|.

Sheldon -

What I do is this: on my main form for my tracking program I show which is 
the current index and I allow for index switching via user selection.  THEN 
when you run your module with the seeker function it will be using the 
current index, no matter what it is.

As an example, my tracker defaults to CUSTNO but can be put in alphaname+DOB 
order.  Seems this might be easier than creating more rowsets, although that 
would work also.

bigMike


"Sheldon Stewart" <stu_serv@yahoo.com> wrote in message 
news:Sx6HHcoYIHA.512@news-server...
> I'm using the seeker function and it only use the current index.  How can 
> I toggle between the different indexs via SQL? 

Thanks

Geoff Wass [dBVIPS] Wrote:

> In article <Sx6HHcoYIHA.512@news-server>, stu_serv@yahoo.com says...
> > I'm using the seeker function and it only use the current index.  How
can I toggle between the different indexs via SQL? 
> > 
> 
> Sheldon,
> 
> Create several ROWSET objects (each with a different ROWSET.indexName), 
> but only have one SEEKER object. Switch the SEEKER.rowset property to 
> the correct ROWSET for the search you want to do.
> 
> -- 
> Geoff Wass [dBVIPS]
> Montréal, Québec, Canada
> 
> .|.|.|        dBASE info at http://geocities.com/geoff_wass       |.|.|.
> .|.|.| ---------------------------------------------------------- |.|.|.
> .|.|.|             IT Consultant http://Geoff_Wass.com            |.|.|.

In article <zvxuwnkcIHA.1088@news-server>, Stu_serv@yahoo.com says...
> Thanks

Sheldon,

You're welcome.

-- 
Geoff Wass [dBVIPS]
Montréal, Québec, Canada

.|.|.|        dBASE info at http://geocities.com/geoff_wass       |.|.|.
.|.|.| ---------------------------------------------------------- |.|.|.