Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Rakesh Kumar
  Where is Rakesh Kumar?
 Sunam
 India
 Rakesh Kumar
 To: Arslan Noman
  Where is Arslan Noman?
 Hyderabad
 Pakistan
 Arslan Noman
 Tags
Subject: RE: indexing
Thread ID: 373639 Message ID: 373902 # Views: 37 # Ratings: 0
Version: Visual FoxPro 9 Category: General VFP Topics
Date: Thursday, March 28, 2013 6:09:16 PM         
   


> > sir,
> > i have created a customer table with field name custid, custname, address etc
> > the datatype of custid is character type and i've set the index name as candidate.
> > when i enter data randomly through customer form and browse, the browse window
> > displays data in random manner. i want it to display in sorted manner.
> >
> > plz help me.
> >
> > thanx
>
>
>
> select your table then
>
>
index on custid tag custid

> and see after this
> for every time you use table ...
>
use (your table name) order custid



If custid is character
Index on val(custid) taq custid
Be Possitive

ENTIRE THREAD

indexing Posted by randhir kumar @ 3/24/2013 4:23:15 PM
RE: indexing Posted by Stefan Wuebbe @ 3/24/2013 4:55:04 PM
RE: indexing Posted by Arslan Noman @ 3/27/2013 3:38:39 PM
RE: indexing Posted by Rakesh Kumar @ 3/28/2013 6:09:16 PM