Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Can I append and copy at the same time?
Message
From
10/02/2011 04:12:29
 
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP1
Miscellaneous
Thread ID:
01499518
Message ID:
01499557
Views:
41
>>>>>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform