Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: tushar Kanvinde
  Where is tushar Kanvinde?
 Kolhapur, Maharastra
 India
 tushar Kanvinde
 To: Steven Rebello
  Where is Steven Rebello?
 Bangalore
 India
 Steven Rebello
 Tags
Subject: RE: Index tag
Thread ID: 268944 Message ID: 268960 # Views: 52 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Thursday, July 15, 2010 4:25:54 PM         
   


> >
> > I do not understand what you are saying. If you index on dfrmdate, the order will be on dfrmdate and there will not be only unique values unless your query only extracted unique values.
> >
> > Mike Yearwood
> > Microsoft MVP Visual FoxPro 2008, 2009
> > We have enough youth. We need a fountain of smart!
> > There may be many ways to skin a cat, but there are very few right ways to do it.
>
> Hi Mike,
>
> It's strange...I have all mixed and duplicated dates in the select query. Only after adding the index I get unique records.

What is your select query.

Regards
Tushar

ENTIRE THREAD

Index tag Posted by Steven Rebello @ 7/15/2010 3:05:30 PM
RE: Index tag Posted by Mike Yearwood @ 7/15/2010 3:39:13 PM
RE: Index tag Posted by Steven Rebello @ 7/15/2010 3:55:00 PM
RE: Index tag Posted by tushar @ 7/15/2010 4:25:54 PM
RE: Index tag Posted by Steven Rebello @ 7/15/2010 4:27:08 PM
RE: Index tag Posted by Samir H. @ 7/15/2010 5:12:09 PM
RE: Index tag Posted by Mike Yearwood @ 7/15/2010 8:02:57 PM
RE: Index tag Posted by Steven Rebello @ 7/17/2010 6:36:53 PM
RE: Index tag Posted by Mike Yearwood @ 7/18/2010 7:26:34 PM
RE: Index tag Posted by Steven Rebello @ 7/19/2010 4:40:52 AM
RE: Index tag Posted by Samir H. @ 7/19/2010 4:55:21 AM
RE: Index tag Posted by mk sharma @ 7/22/2010 8:05:53 AM
RE: Index tag Posted by Mike Yearwood @ 7/22/2010 5:34:21 PM
RE: Index tag Posted by Steven Rebello @ 7/22/2010 6:02:48 PM
RE: Index tag Posted by Mike Yearwood @ 7/22/2010 8:51:46 PM
RE: Index tag Posted by Steven Rebello @ 7/23/2010 3:26:30 PM
RE: Index tag Posted by Mike Yearwood @ 7/15/2010 6:51:50 PM