Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Hi Cecil.
Are you using View Editor to edit your views? If not, you really should (or Eview). It looks like you have "Send Updates" enabled on the "projects" table. In this case, you need to tell which field in your "projects" table is the key field and set it to update.
HTH
Dan
>I cannot understand what it is I am doing wrong here. The below text repesents the precise error I am receiving. I am using a parameterized local view to capture records based on the following:
>
>This.cProject_No = ThisForm.cmdFrom.Value && Get the value for the parameter for the lcoal view.
>=ReQuery("V_ArchiveProjects2HstProj") && Execute the local view.
>
>This is the parameter in the local view:
>Projects.Project_NO = ?ThisForm.cProject_No
>
>Here's the error I keep getting:
>================================
>"No key columns are specified for the update table 'projects'.
>Use the KeyFieldList property of the cursor."
>
>Any ideas as to what I am doing wrong? I can't even quit FoxPro without CTL-ALT-DEL and ending the task.
>
>Cecil
Précédent
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