Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Error reading a property from the database
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...
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement