SQLite Forum

Update Table Columns in SQLite in CoreData for iOS
Login
Hello,

I have no business trying to do anything in SQLite (Mac). I don’t even know if I should work through Terminal or XCode, but we are in a pandemic and the Developer for my iPhone app has not responded in over a month.

My problem is I need to completely update several columns in one of the “Tables” (entities?) in the CoreData.sqlite file of my iOS app. This is information that is permanent to each app version, downloaded once for that version, and is not impacted or interacted with by the user.

I might manage that outside of XCode, but I am wary of CoreData and can see that, even though the structure and field names of previous CoreData files is always the same, the metadata of past CoreData files is always different.

I know what I would so with my trusty Access 2000:

UPDATE Table_UPDATING, Table_2B_UPDATED SET Table_2B_UPDATED.[1] = [Table_UPDATING].[ONE], Table_2B_UPDATED.[2] = [Table_UPDATING].[TWO];

But, the XCode interface is daunting and I’m not even sure if it is best done through XCode.

Any good Samaritans who have a great idea?

Thanks