G'day Dave,
The most major `gotcha` I have experienced is the inability to
turn CASCADE off using the documented method. This was
in 6.1. I have not yet tried to do it with 6.5++ on that database.
A simple workaround is an unload all then rebuild after manually
editing the file.
At 10:26 10/07/01 -0400, you wrote:
>In a transition from an old system to a new one most of the client records
>were carried over, however, some escaped. Now I have some system-assigned
>ID numbers that should be a previously existing number.
>
>After rereading Bill Downall's page on cascading updates and deletes I agree
>this is not a feature I'd want on full-time, but can I ALTER TABLE to add
>cascade, perform the updates, then ALTER TABLE again to drop cascade?
>
>(I know I can, I guess the question is whether I should).
>
>If this would work what are the other considerations? For instance, I'd
>only perform this with MULTI OFF.
>
>If the greater issue is changing a client ID number what other strategies
>are there? Given the PK/FK relationships based on this number we _could_
>create a 2nd client record with the correct ID, then reassign the FK tables,
>but that's pretty labor intensive and relies upon a record duplication which
>is another layer of management detail to correct.
>
>tia
>
>Dave Ebert
>[EMAIL PROTECTED]
Warmest regards,
Tom Grimshaw
coy: Just For You Software
tel: 612 9552 3311
fax: 612 9566 2164
mobile: 0414 675 903
post: PO Box 470 Glebe NSW 2037 Australia
street: 3/66 Wentworth Park Rd Glebe NSW 2037
email: [EMAIL PROTECTED]
web: www.just4usoftware.com.au
This email and any files transmitted with it are confidential to the
intended recipient and may be privileged. If you have received this email
inadvertently or you are not the intended recipient, you may not
disseminate, distribute, copy or in any way rely on it. Further, you should
notify the sender immediately and delete the email from your computer.
Whilst we have taken precautions to alert us to the presence of computer
viruses, we cannot guarantee that this email and any files transmitted with
it are free from such viruses.
