Just create the table first in IB/FB without the constraints (check, foreign key, primary key), etc, and then transfer your FoxPro data to this table, and after that, create the table constraint. The only caveat is, you won't be able to edit the data that violates the constraint.

On Tue, Jun 19, 2001 at 08:13:59AM -0000, jvanderreest@... 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. MS-SQL Server provides the key
> words 'NO CHECK' when declaring constraints, which allows current
> data to be ignored when porting from another database engine. Is
> something similar available in interbase?
>
>
> If not, do you have any other suggestions? Fixing the data first is
> not an option at this stage.
>
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>