Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Can't get beyond error in View
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00677775
Message ID:
00677841
Views:
17
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
Map
View

Click here to load this message in the networking platform