Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Benny Thomas
  Where is Benny Thomas?
 Jeddah
 Saudi Arabia
 Benny Thomas
 To: sudhir
  Where is sudhir?
 
 India
 sudhir
 Tags
Subject: RE: INDEX ON DATE + INVOICE NO.
Thread ID: 21953 Message ID: 21954 # Views: 2 # Ratings: 0
Version: Visual FoxPro 5 Category: General VFP Topics
Date: Saturday, April 05, 2003 8:48:02 AM         
   


Is your invoice number field numeric or is it character?

If numeric do this:

INDEX ON dtoc(date,1)+str(Inv. No.) tag mytag

If character do this

INDEX ON dtoc(date,1)+Inv. No. Tag mytag

Benny


> Dear ALL
>
> I have a table in which i store the invoice data as follows :
>
> Inv No. Date
>
> The Invoice no. has two series running parallel like the following example (both for different kind of products) :
>
> 101 2nd April
> 102 2nd April
> 1001 2nd April
> 103 2nd April
> 1002 2nd April
> 1003 3rd April
> 104 4th April
> 105 4th April
> 106 4th April
> 1004 5th April
> ... and so on
>
>
>
> If i index only on date field, sometimes the invoice nos. go up and down. I want to index in such a way that it should index date first and then inv no. .
>
> The invno field is of character type.
>
> Thanks in Advance
>
>
> Sudhir
>
>
>
>
>


COMPLETE THREAD

INDEX ON DATE + INVOICE NO. Posted by sudhir uppal @ 4/5/2003 8:35:02 AM
RE: INDEX ON DATE + INVOICE NO. Posted by Benny Thomas @ 4/5/2003 8:48:02 AM
RE: PADL function replaces spaces with zeroes Posted by Rene Relucio @ 4/5/2003 11:14:39 AM
RE: PADL function replaces spaces with zeroes Posted by Allan Cerrudo @ 4/5/2003 12:01:17 PM
Thankyou very much RE: INDEX ON DATE + INVOICE NO. Posted by sudhir uppal @ 4/5/2003 3:16:13 PM