Im stumpted on this one...

I have a table like this....

id identity(1,1), field1 char(10) PK field2 int PK

I need to update field1 using the id field. (I dont know the value of field2)

Entity entity = new Entity(); entity.field1 = "Something"; IRelationPredicateBucket filter = new RelationPredicateBucket(); filter.PredicateExpression.Add(PredicateFactory.CompareValue(EntityFieldIndex.id, ComparisonOperator.Equal, 1)); adapter.UpdateEntitiesDirectly(entity, filter);

Whats wrong with this? Im not getting and error or an update...

Thanks Matt

is there any data with an ID of 1 in your table?

No just one row with an id of 2....

Exactly, you are updating using (WHERE ID = 1) And there is no row having the ID = 1.

So there is no row getting updated.

Hehe sorry, but i was just using the "1" as an example. I traced the value and ID = 2. So im still stumped why this isnt working.

-Matt

I don't believe you can update a field that is part of a primary key. What is the error that you are receiving.

Im not recieving any error. Just nothing happens... I dont see why you can't update a field that is part of a primary key? It seems like this is common practice no?

Take a look at this thread and see if implementing the solution in the last post helps. http://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=630