THESE FORUMS ARE NOW FROZEN
Please choose "Forums" from the Main menu of www.entityspaces.net to get to our new forums.

Error if Editing Employees Territories

rated by 0 users
This post has 2 Replies | 1 Follower

Top 50 Contributor
Posts 60
johnhbarrett Posted: 04-24-2009 9:37 PM

1. Run thge on line demo

2. select any record

3. edit the territoy record for that person simply by selection a different on in the territory ddl

get an "invalid Sql message or similar... 

Top 10 Contributor
Posts 1,675

Thx for the heads-up. We probably should not have told the Admin Grid template to generate an "Edit" page for it, as there is nothing to edit.

EntitySpaces does not allow changing/updating a primary key field. The Northwind EmployeeTeritories table is a simple cross-reference for a Many-to Many. All the fields in it are part of the primary key. You can only delete a EmployeeTerritory record (dissociate a Territory), or add one (associate).

David Neal Parsons
www.entityspaces.net

Top 50 Contributor
Posts 60

No problem. i'm thinking of renewing my license after a spell away from the world of ES (using LINQ-To-NHibernate).  

I must say, i'm very impressed with the progress your team has made - i'll certainly be recommending this product at the next opportunity.

Is there any thoughts around the xaml space? 

Cheers, John 

Page 1 of 1 (3 items) | RSS
Copyright © 2005 - 2009, EntitySpaces, LLC