Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Is there a change in behaivour in VFP9 and set relations
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01258261
Message ID:
01258277
Views:
11
>Hi Michael,
>
>- try set SET TABLEVALIDATE TO 0
>- check COLLATE of all indexes if equal to VFP COLLATE
>- check CODE PAGE of tables if equal to VFP Code Page
>- if you use function in index expression, like as STR() change to STR(n,length) - key must has fixed length

STR(n) is fixed length - 10 characters. There is a bug in VFP9 RTM that incorrrectly treats it as variable length. It has been fixed in SP1.
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform