Yes. Ever used that approach? Did it work for you?
Sorry, no I've not ever tried it myself. I try to limit myself to
simple integer PKs (except in extreme circumstances like when dealing
with legacy system, which in my case stored procedures we're
practical anyway).
Yes, they are generating IDs relative to a relationship. Nothing
very complex though, the stored procedure only does the following:
I assumed that was the case, but just wanted to verify.
Sorry I couldn't help further, but I don't really understand why that
technique didn't work for you. Unless, stored procedures are somehow
broken in the latest version of WO. I can't imagine that's true though.
On May 14, 2007, at 3:14 PM, Florijan Stamenkovic wrote:
Hi Robert,
1. Is this the technique you are using to trigger your stored
procedures:
http://developer.apple.com/documentation/WebObjects/UsingEOModeler/
6WorkingWithEntities/chapter_6_section_5.html#//apple_ref/doc/uid/
TP30001018-CH206-BABGBCJE
Yes. Ever used that approach? Did it work for you?
2. Are your stored procedures doing something more complex than
assigning a simple incrementing integer primary key? I'm only
asking in case you are unaware that OpenBase provides a plug-in
for supporting native primary key generation. You can specify the
OpenBasePKPlugIn in your connection dictionary, and include the
OpenBasePKPlugin framework in your project. Doing so will
eliminate the need for the EO_PK_TABLE and have OpenBase provided
PKs natively to EOF.
Yes, they are generating IDs relative to a relationship. Nothing
very complex though, the stored procedure only does the following:
Statement s = connection.createStatement();
s.executeUpdate("UPDATE PUNCH_ITEM p1 SET UNIQUE_NUMBER =
(SELECT MAX(UNIQUE_NUMBER) FROM "+
"PUNCH_ITEM p2 WHERE p1.STRUCTURE_ITEM_ID =
p2.STRUCTURE_ITEM_ID) + 1 WHERE UNIQUE_NUMBER = NULL");
return null;
Flor
--
Robert Walker
[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:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to [EMAIL PROTECTED]
