Hi Chris,
Are you creating the index on the source table or on the view itself? What is index key expression?
>
>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
--sb--