Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cursors and Indexes
Message
From
31/03/2005 16:54:51
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01000464
Message ID:
01000465
Views:
25
This message has been marked as the solution to the initial question of the thread.
All indexes created on a cursor will be flushed with the cursor when it is closed.

HTH

>I have this code....
>Create Cursor TMPTRACER (cKey C(7),norder N(2),  cType C(1), ctable C(12),
   cAction C(30),loaddate D(8), loadtime C(5), deldate D(8),deltime C(5), cDateInfo C(20), cDetl C(250),
   cdetl2 C(250), corigin C(35), cdest C(35), manifest C(8),custno C(10), Driver C(5), tractor C(6), 
   trailer C(15),mextra M,cDispatcher C(3),lExpanded L, shipper C(10), consignee C(10), ldblclicked L)
>Index On Iif(cType="T","Z","A")+cKey + Padl(norder,3,'0')  Tag T
>The cursor will be deleted automatically by FoxPro when I USE the workarea that TmpTracer is in....
>
>But what will happen to the Index? Will it also be automatically erased too?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform