>>>>>>Yes, this looks like will work. Especially I like it since I don't have to list all fields but do all (*). Thank you very much.
>>>>>>
>>>>>
>>>>>Listing all fields is better than do such extra processing.
>>>>>
>>>>
>>>>Could you please explain why?
>>>
>>>You list all the fields in the INSERT command and do a single insert operation. Listing all fields is a best practice, select * is only valid when you do it in the command window.
>>
>>Thank you.
>Naomi is correct on better to leave out fixing with special code.
>But it might be possible (have NOT tested!) that the insert (select *) would work correctly if the relevant CA properties for updating/getting values are set properly - the "false" PK could be painless. As long as now child records are involved, it might be an easier model, altough such an approach could bite you later if the same classes are used in a fwk manner with child records ;-)
>
>regards
>
>thomas
Thank you, Thomas.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
