General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
Previous
Next
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