Query Problem in ASP Runner

This topic is locked

Query Problem in ASP Runner	10/31/2008 10:39:00 PM
ASPRunnerPro General questions
M mccreelake author My database is designed such that I need to write SQL code in ASP Runner to pull data from different tables that needs to be updated. I wrote a query recently that linked two tables. I specified a primary key for the table and added an edit page. When I attempt to edit a record, it tells me that the primary key field "cannot be bound." Can you help? The multi-part identifier "dbo.Groups_Events.GroupEventID" could not be bound.


F	funklet 11/1/2008
	McRee, If you want to update the table from custom SQL then you must do the following. Select the base table you want to update in "Datasource Tables". In "Edit SQL" paste in the query that you are using. Make sure that only fields from the base table appear on the "Edit" or "Add" pages. It is not possible to update fields from different tables, when I say not possible I mean really quite hard which would involve custom code. It is not possible to update a view created in the database. Views can only be "Viewed", Only Tables can be "Updated" I hope this helps.