General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only