--- In ib-support@y..., jvanderreest@y... wrote:

> Hi Guys,
>
> Could someone help me with a constraints issue?
>
> We are converting an existing FoxPro application to Delphi 5/6 and
> are trying to use Interbase for persistence. Foxpro doesn't provide
> any low level constraint mechanism, but we would like to use the
> constraints available in IB/FB. The problem we have is that we have
> existing data that violates the constraints we wish to put in place.
> Primarily we would like to create 'Foreign Keys' on specific columns
> to ensure that any NEW data entered is 'valid' but any existing data
> is ignored for historical reasons. <...>
>
>
> If not, do you have any other suggestions? Fixing the data first is
> not an option at this stage.

Do you have (or could you create, perhaps as part of loading the old
data?) any way to distinguish between the data that came from FoxPro
and the NEW data? (A flag, a date value, a hunch ...?)

db