-
1. Re: Update a table and then insert in another table
Marcio Dantas Mar 18, 2011 4:51 PM (in response to Luiz Soares)Do you really have to control the ID generation?
What you're doing is really similar to a database sequence or auto-increment ID..
-
2. Re: Update a table and then insert in another table
Luiz Soares Mar 21, 2011 1:56 PM (in response to Luiz Soares)I know, but this is how they created here. I have to control the ID generation.
My problem now is how to insert the value that I updated into the new object. For that only field.
Example: I created the object and now I'm going to insert it in the Control Table. I've already updated the SEQ Table to control the last value. Now I have to get this value from the LASTVALUE field that is in the SEQ table, put it in the referenced field of the control object and insert it with all the other fields that this control object has.
-
3. Re: Update a table and then insert in another table
Roger Mori Mar 21, 2011 2:10 PM (in response to Luiz Soares)Hi Luiz:
The semantics of GenerationType.TABLE fits your requirement.
Roger.
-
4. Re: Update a table and then insert in another table
Luiz Soares Mar 21, 2011 4:45 PM (in response to Luiz Soares)Really Helpful! Thank you!
Now I have another doubt. And if I have a compositeID. How do I use the GenerationType.Table?
I'm searching but until now I have found nothing.