Do I think this is something that ought to go into EOF proper? Not really. But the original poster was looking for a way to automatically fix his PK sequences and so I'm giving him the outline of how he could do this. He may decide (and I would if I were him) that ultimately it's cheaper to remind yourself to update the PK sequence if you make changes outside of EOF.
I can't agree more (and i'm the original poster!!). I have no problem at all with EOF's PK handling in general. It's just really annoying that on the odd occasion when you get something slightly out of synch it bites you really hard. My original post was merely querying why EOF can't just fix itself, although it seems to have triggered a useful debate on the merits of how it currently operates :-)
Anyway, the simplest "bodge-it-fix" i have come up with is to drop the contents of the EO_PK_TABLE every time an app starts up. Then you get a one-time-per-table hit when you first insert a record, following which everything runs smoothly.
Simon _______________________________________________
Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [EMAIL PROTECTED]
