Re: rawRows for UPDATE
Re: rawRows for UPDATE
- Subject: Re: rawRows for UPDATE
- From: Ramsey Gurley <email@hidden>
- Date: Tue, 26 Jun 2012 07:43:50 -0700
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@hidden>
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@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden