Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using TTOC in an index
Message
From
28/07/2008 22:49:01
Chris Sund
Silhouette Solutions
Utah, United States
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01318068
Message ID:
01334769
Views:
11
Sergey,

I'm getting the same error, and rather then creating a new thread I thought I would interject my problem into this thread. My error seems to be caused when requerying my view. I beleive the cause is from my datetime field. It wasn't until I added an index to this field that I started to recieve the error. Here's the error code. Do you have any suggestions? I decided to remove the index, but maybe there is a better way.

ERROR: 2199
METHOD: requeryview
PROGRAM: VPMDataHandler or ProDataHandler
MESSAGE: Error building key for index "c:\docume~1\ken\locals~1\temp\00004cgp006d.cdx" tag "List7".
CODE: SELECT Stxproperty.*, Counties.cname, Counties.caddress AS caddress_c, Counties.caddress2, Counties.ccity AS ccity_b, Counties.cstate AS cstate_c, Counties.czip AS czip_b, Counties.ctreasurer, Counties.ctreasurer_email, Counties.cphone AS cphone_b, Counties.cfax, Counties.nassignment_cost, Counties.cclerk_recorder, Counties.cclerk_phone, Counties.clerk_fax, Counties.cclerk_email, Counties.cnewspaper, Counties.cnews_address, Counties.cnews_city, Counties.cnews_state, Counties.cnews_zip, Counties.cnews_phone, Counties.cnews_fax, Counties.cnews_email, Counties.cpublication_day, Counties.cad_deadline, Counties.cnews_cost, Counties.ctitle_company, Counties.ctitle_phone, Counties.ccounty_website, Counties.ccounty_taxsite FROM atlp!stxproperty LEFT OUTER JOIN atlp!counties ON Stxproperty.ccounty_fk = Counties.ccounty_pk ORDER BY Stxproperty.datetime DESC into cursor Viewcalv96
LINE: 149
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform