At 26/06/2002 11:16 AM, you wrote:

>How do you implement referential integrity in Firebird after having updated
>from Paradox to Firebird?

Look at the information for Foreign Key contraint. That's what you are
looking for.

>I have fields that are related to ID fields in other tables, but the
>referential integrity is not in place for these fields which are really
>foreign keys. How can I make it know that these are foreign keys?

Refer to the DDL statement ALTER TABLE {...} ADD CONSTRAINT REFERENCES
{...} documentation for the information that you are seeking.


Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.accramed.ca)