Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Bug? Index Transform(numfld) tag numa
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Bug? Index Transform(numfld) tag numa
Miscellaneous
Thread ID:
00774473
Message ID:
00774473
Views:
44
I seem to have a problem.
Create Cursor IndexBug (numfld n(4))
Insert Into IndexBug Values (350)
Insert Into IndexBug Values (250)
Insert Into IndexBug Values (650)
Insert Into IndexBug Values (6300)
ViewContents("Original Contents")
Index On Transform(numfld) tag numflda
Set Order To 1
ViewContents("TransForm(numfld)-Expected Order")
Delete Tag All
Index On numfld tag numfld
Index On Transform(numfld) tag numflda
Set Order To 2
ViewContents("With 2 indexes-The order isn't correct")
Reindex
ViewContents("ReIndexed-Short is before long")

Use In IndexBug

Procedure ViewContents (cHeader)
Select IndexBug
cMessage = ""
Scan All
   cMessage = cMessage + Transform(numfld) + Chr(13)
EndScan
MessageBox(cMessage,0,cHeader)
EndProc
How far off am I? I can reproduce this affect in VFP6SP5 and VFP8.

Tracy
Tracy
Next
Reply
Map
View

Click here to load this message in the networking platform