Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP to VB
Message
From
28/01/2007 03:23:15
 
 
To
24/11/2006 08:39:13
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01171617
Message ID:
01189893
Views:
13
Hi Tore, Today i am upgrading in my projects. I read your reply about indexing

<>Index on alltrim(custname) && Can give different lengths for each cust_name, and is very DANGEROUS
Index on padr(alltrim(cust_name),16) && Safe, will always give keys of length 16

My question is this. If i use your advise in my indexing I get lenght 16 like
with padr or this is only for one line=16 key lenght
Use student
pack
Index On descr Tag descr
Index On code Tag code
Index On lcode+descr Tag lvldes
Index On surn Tag surn
Index On scode Tag scode
Index On lcode Tag lcode
Index On sex Tag sex
Index On fname Tag fname
Index On joind Tag joind
Index On dbirth Tag dbirth
Index On roll Tag roll
Index On tobt Tag tobt
Index On mont Tag mont
Index On ldate Tag ldate
Index On aattend Tag aattend
Index On scode+lcode+sec Tag sls
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform