I have a table, RTTCDisabilities, in a database, that has 2 fields:

iRTTCDisabilitiesID Integer default value is generated by GetKey("RTTCDisabilities")
cDescription Character 40

There are 3 indexes on the table:
ID iRTTCDisabilitiesID (primary)
cDescription UPPER(cDescription)
_DELETED DELETED()

There are no table triggers or record validation rules.


I create an updateable view...SQL statement is:
SELECT *;
FROM rrtc!rrtcdisabilities;
ORDER BY Rrtcdisabilities.cdescription

Couldn't be simpler????

When I try to browse the view, I get the error "Error reading a property from the database. The property is ignored." and the browse then displays the three records.

I ran VALIDATE DATABASE and it showed no errors. I'm using VFP (V6.0 SP3).


I can recreate the view and it seems OK until I go into Visual Fox Express. I'm going to post a question on the F1 Tech conference also, but, since I'm also getting the error in VFP, I thought I'd check here...