Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cursors and Indexes
Message
 
To
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:
01000467
Views:
17
Thanks... I thought that would probably be the answer, but I couldn't find it quickly enough in the help files.....

Much appreciated!!!

>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?
Tommy Tillman A+ NetWork+ MCP
Previous
Reply
Map
View

Click here to load this message in the networking platform