I assume by _rowid you mean the primary key. Don't update PKs. Ever. That will 
probably wreck the pk index. That will definitely wreck all foreign keys 
pointing to that pk. Updating a pk is wrong and if your schema design requires 
it, then your schema is wrong.  EOF doesn't allow you to update PKs for a very 
good reason.

On Jun 26, 2012, at 3:57 AM, Ron X wrote:

> how can I update _rowid by EOF? :-)
> 
> 2012/6/26 Johann Werner <[email protected]>
> Have a look at the ERXEOAccessUtilities class. There you have plenty of 
> helper methods if you really want to send raw SQL to the database. Why don't 
> you use EOF?
> 
> 
> Am 26.06.2012 um 12:15 schrieb Ron X:
> 
> > hi4all
> > can I use this method for update?
> >
> > i tried
> > EOUtilities.rawRowsForSQL(editingContext, "db_test", "UPDATE song " +
> >                         "SET artistId = " + concreteCurrentArtistID + " 
> > WHERE " + "artistId = " + concreteValidArtistID, null);
> >
> > but nothing changes...
> 
> 
> 
> _______________________________________________
> Do not post admin requests to the list. They will be ignored.
> Webobjects-dev mailing list      ([email protected])
> Help/Unsubscribe/Update your Subscription:
> https://lists.apple.com/mailman/options/webobjects-dev/ramseygurley%40gmail.com
> 
> This email sent to [email protected]

 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      ([email protected])
Help/Unsubscribe/Update your Subscription:
https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

This email sent to [email protected]

Reply via email to