2. ASPRunnerPro General questions
  3. PROBLEM EDITING VIEWS version 3.2
This topic is locked

PROBLEM EDITING VIEWS version 3.2

 		5/12/2005 19:03:25
ASPRunnerPro General questions
O
 ORIONSYS author

Im testing the new verision 3.2 and I came across the following problem
I have a view on my SQL databese that involves 2 difrent tables, when I use that view and try to edit it it returns the following error
Microsoft Cursor Engine error '80004005'
Insufficient key column information for updating or refreshing.
/vacantes/viaticos/conta/prueba asp/VISTA_CONTA_PROCESADOS_edit.asp, line 525
When I use version 3.1 with exactly the same view and edit records I have no problem.
Can anyone help
Thanks
Sergey Kornilov admin 5/13/2005

Hi,
please send your ASP files along with SQL script that creates tables and views to support@xlinesoft.com for investigation.
jmisson 6/12/2005

Hi,
Just seeing if there was a solution to this problem as I am getting the same error. I have the _add pages set up exactly as the _edit pages. The _add pages work fine, but not so the _edit pages. It appears to be a problem with nearly if not all my _edit pages.
Many thanks
Sergey Kornilov admin 6/14/2005

Julie,
please zip and send to support@xlinesoft.com all files from ASPRunnerPro output folder with subfolders along with project file and your sample database. I'll find what's wrong running it on my test box.
500247 6/14/2005

I cannot manage to edit a simple access query (just with table data plus totals) in ASPPro3.2 .

The solution I came up with is an entry table with no subtotals, and a results list made just to view all fields with totals and subtotals...is there a better way to get over that?

Thanks,

Robert
Sergey Kornilov admin 6/15/2005

Robert,
can you post your query here?