foreign and primary key do not match?

alex E

Delphi Developer

Thu, 23 May 2002 03:00:00 GMT

foreign and primary key do not match?

I have been restructuring and editing a table, and when I went to pack it
and save it ...
it gave me this error?

foreign and primary key do not match

Any ideas how to fix this..

Thanks

Alex

Delphi Developer

Fri, 24 May 2002 03:00:00 GMT

Re:foreign and primary key do not match?

Follow up:

I am using to the Database desktop to restructure this?

I am trying to change the primary key from an autoincrement to an integer...

But it gives me the following error....

foreign and primary key do not match

any ideas how to fix this..

Thanks

Alex

Quote

alex

Delphi Developer

Fri, 24 May 2002 03:00:00 GMT

Re:foreign and primary key do not match?

Finally ....it works...........

I did not have referential integrity on this table.....but the following
fixed it...

Created new table (copy structure , only primary key and secondary indexes)_
Add records from table(not working)...
Saved and Packed ....and everything works.....
Not exactly sure what happened....

Thanks

Alex E.

Brian Bushay TeamB <BBus...@Nmpls.com> wrote in message
news:385488da.50407149@floyd...

Quote

> >I am using to the Database desktop to restructure this?

> >I am trying to change the primary key from an autoincrement to an
integer...

> >But it gives me the following error....

> >foreign and primary key do not match

> >any ideas how to fix this..

> Remove referential integrity links before you restructure the table.

> --
> Brian Bushay (TeamB)
> Bbus...@NMPLS.com

Brian Bushay Tea

Delphi Developer

Sat, 25 May 2002 03:00:00 GMT

Re:foreign and primary key do not match?

Quote

>I am using to the Database desktop to restructure this?

>I am trying to change the primary key from an autoincrement to an integer...

>But it gives me the following error....

>foreign and primary key do not match

>any ideas how to fix this..

Remove referential integrity links before you restructure the table.

--
Brian Bushay (TeamB)
Bbus...@NMPLS.com

Other Threads

1. Foreign and primary key do not match

2. Foreign and primary key do not match

3. Primary key or not primary key.........

4. primary and foreign keys

5. MSSQL, D3C/S: Primary --> Foreign Keys

6. How to update primary and foreign keys in referenced tables

7. sql triggers primary and foreign keys HELP

8. MSSQL: Cascade Updating a Primary Key on Foreign Tables

9. Cascade Updating a Primary Key on Foreign Tables

10. Field as both Primary and Foreign Key