General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
> 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
What is the exact expression of the new index tag?
-Stefan
>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
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