Re: [SOLVED] how to insert records in database in the order of insertion to EC

2009-11-02 Thread Shravan Kumar. M
1, 2009 5:55:25 PM > Subject: Re: how to insert records in database in the order of insertion to EC > > Or if you want the order of the PKs to be the same order as your insertion > into the EC, you can try calling > > eo.primaryKeyInTransaction(or sth like that) > &g

Re: [SOLVED] how to insert records in database in the order of insertion to EC

2009-11-02 Thread Patrick Middleton
http://www.mail-archive.com/ webobjects-dev@lists.apple.com/msg25975.html From: Kieran Kelleher To: Shravan Kumar. M Cc: Chuck Hill ; WO Dev Group d...@lists.apple.com> Sent: Sun, November 1, 2009 5:55:25 PM Subject: Re: how to insert records in database in the order of insertion to EC O

Re: [SOLVED] how to insert records in database in the order of insertion to EC

2009-11-01 Thread David Avendasora
On Nov 1, 2009, at 8:22 AM, Shravan Kumar. M wrote: clearly order "matters" to you, which means that ordering is "real data" and should be represented in your db explicitly, not achieved with trickery. +1 PKs and FKs are artifacts of the DB, not data. One of the banes of my current job

Re: [SOLVED] how to insert records in database in the order of insertion to EC

2009-11-01 Thread Shravan Kumar. M
, 2009 6:39:32 PM Subject: Re: [SOLVED] how to insert records in database in the order of insertion to EC 100% with chuck here ... the database is an unordered set. don't depend on this. don't play pk tricks. if you want a specific order, add a field that represents this specific orde

Re: [SOLVED] how to insert records in database in the order of insertion to EC

2009-11-01 Thread Mike Schrag
d to DB. Thanks again Chuck for your insight!!! From: Chuck Hill To: Shravan Kumar. M Cc: WO Dev Group Sent: Sun, November 1, 2009 9:34:31 AM Subject: Re: how to insert records in database in the order of insertion to EC On Oct 31, 2009, at 8:46 PM, Shravan Kumar. M wrote: > Thanks so m

Re: [SOLVED] how to insert records in database in the order of insertion to EC

2009-11-01 Thread Shravan Kumar. M
e.com/msg25975.html From: Kieran Kelleher To: Shravan Kumar. M Cc: Chuck Hill ; WO Dev Group Sent: Sun, November 1, 2009 5:55:25 PM Subject: Re: how to insert records in database in the order of insertion to EC Or if you want the order of the PKs to be the same ord

Re: how to insert records in database in the order of insertion to EC

2009-11-01 Thread Kieran Kelleher
: Shravan Kumar. M Cc: WO Dev Group Sent: Sun, November 1, 2009 9:34:31 AM Subject: Re: how to insert records in database in the order of insertion to EC On Oct 31, 2009, at 8:46 PM, Shravan Kumar. M wrote: > Thanks so much for your quick response Chuck. > > We use Frontbase. I have no

Re: how to insert records in database in the order of insertion to EC

2009-10-31 Thread Shravan Kumar. M
gt; From: Chuck Hill > To: Shravan Kumar. M > Cc: WO Dev Group > Sent: Sun, November 1, 2009 8:49:54 AM > Subject: Re: how to insert records in database in the order of insertion to EC > > > On Oct 31, 2009, at 6:57 PM, Shravan Kumar. M wrote: > > > Hi Group,

Re: how to insert records in database in the order of insertion to EC

2009-10-31 Thread Chuck Hill
ubject: Re: how to insert records in database in the order of insertion to EC On Oct 31, 2009, at 6:57 PM, Shravan Kumar. M wrote: > Hi Group, > > Could any one please advise me how can I insert records in database in a specific order or as per the order of insertion of objects to

Re: how to insert records in database in the order of insertion to EC

2009-10-31 Thread Shravan Kumar. M
me" field would solve this issue!!! From: "Chan Yeow Heong, Jerome" To: Shravan Kumar. M Sent: Sun, November 1, 2009 8:46:39 AM Subject: Re: how to insert records in database in the order of insertion to EC Do a save after each insert? Add in

Re: how to insert records in database in the order of insertion to EC

2009-10-31 Thread Shravan Kumar. M
rtOrder" field to my table would fix this issue. Thank You, Shravan Kumar. M From: Chuck Hill To: Shravan Kumar. M Cc: WO Dev Group Sent: Sun, November 1, 2009 8:49:54 AM Subject: Re: how to insert records in database in the order of insertion to EC On

Re: how to insert records in database in the order of insertion to EC

2009-10-31 Thread Chuck Hill
On Oct 31, 2009, at 6:57 PM, Shravan Kumar. M wrote: Hi Group, Could any one please advise me how can I insert records in database in a specific order or as per the order of insertion of objects to EditingContext AFAIK, you can't. The order of insertion is not tracked. for eg: I hav

how to insert records in database in the order of insertion to EC

2009-10-31 Thread Shravan Kumar. M
Hi Group, Could any one please advise me how can I insert records in database in a specific order or as per the order of insertion of objects to EditingContext for eg: I have inserted objects to EC in the following order: A1, A2, A3, A4, A5 (and then saved the EC once - editingContext.saveChan