Hello Francisco, Elke wrote :
> Francisco Morosini wrote: > > > 2- When i try to make a ref. integrity between 2 tables : > > table 1 c00 with > > NAME DATATYPE DIM CODE KEY NOTNULL DEFAULT UNIQUE > > IID Fixed 10,0 x x SERIAL(1) > > > > and the table L00 with > > > > NAME DATATYPE DIM CODE KEY NOTNULL DEFAULT UNIQUE > > CIID Fixed 10,0 x x SERIAL(1) > > > > then in the ref. integrity dialog of alter table of L00 i create: > > FOREIGN KEY NAME REFERENCING COLUMNS REFERENCE ON DELETE COMMENT > > minombre CIID DBA.C00->IID > > > > i obtain: > > Unexpected Error: > > Module: SqlStudio.RefIntegrityDefinitionControl > > Function: loadColumnTypes > > Error No: 9 > > Error: The SubIndex is out of the interval > > > > later: > > Wrong Column Length > > The datatype and length of referencing and referenced > > columns must be the > > same > > (...) > It seems a little bit strange what you are trying to do. (...) > With error No 9 I hope, another guy has any idea. yeah, this is a reproducable and obvious bug in SQLStudio's foreign key definition control. It occurs when one tries to define a FK referencing a 'Fixed(n,m)' column. It is _not_ related to your attempt to set 'Serial(1)' as a Default Value (which should succeed, AFAIK). Will be fixed in the next release. regards Markus Stausberg SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
