Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Update Indexes
Message
 
To
22/09/2007 02:09:35
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01256064
Message ID:
01256075
Views:
13
>Dear Experts
>
>I create index file as
>
>clear
>close all
>SET SAFETY OFF
>mydbc='TABLES\account.dbc'
>if !dbused("MyDbc")
>open database fullpath(mydbc)
>validate database recover noconsole
>set database to &mydbc
>use vouchers
>index on dtos(date) + str(vou_no, 5) + padr(alltrim(vou_type), 20) tag voucher2
>index on dtos(date) tag voucher3
>Endif
>
>Now I want to perform following TWO tasks
>
>1-Remove all index files
>2-Create index files again
>
>I use dbc with tables
>
>What will be the best method to do this?
>
>Please help


Check ATAGINFO function in help.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform