At 11:18 AM 30-08-01 +0000, you wrote:

>Hi List.
>
>Using, for the first time the new Extract DDL feature, of IB_SQL
>I have got the follow error:
>
>"LocateAssociatedField - TIB_DDL_Table_Constraint(GARE.INTEG_101 ->
>CERIFICAZIONE_ISO) not found.
>ParseMetadata - Error while locating or parsing."
>
>Could someone point me to a source of documentation or better tell me
>how to delete that constraint?

Tony,
To start with, I would want to go into the browser (click on the spectacles icon) and look up the constraints on table GARE. If you don't find a constraint named INTEG_101, find out as much as you can about the CERIFICAZION_ISO column (is there a "T" missing in there?)

Also, checking the monitor to see what system table query caused the error might reveal something useful.

You can also check on the 'System Inf' checkbox in the Browser to see the system tables. Select RDB$CHECK_CONSTRAINTS and display the data to see if you can find out any more about INTEG_101 in there.

To delete a constraint, you do
ALTER TABLE GARE DROP CONSTRAINT INTEG_101;

But you might not be able to drop a system-generated constraint. Until you know what it is, you shouldn't try.

Helen

All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________