Alex wrote:Please specify scripts to create your CLASSPROD2 and CLASSPROD3 tables with links.
CREATE TABLE CLASSPROD2
(
CODECLASSPROD2 VARCHAR2(3) NOT NULL,
CODECLASSPROD1 VARCHAR2(2),
LIBCLASSPROD2 VARCHAR2(30)
);
CREATE INDEX CLASSPROD2_FK1 ON CLASSPROD2(LIBCLASSPROD2)
TABLESPACE INDX;
CREATE INDEX CLASSPROD2_FK2 ON CLASSPROD2(CODECLASSPROD1)
TABLESPACE INDX;
CREATE UNIQUE INDEX CLASSPROD2_PK ON CLASSPROD2(CODECLASSPROD2)
TABLESPACE INDX;
CREATE TABLE CLASSPROD3
(
CODECLASSPROD3 VARCHAR2(4) NOT NULL,
CODECLASSPROD2 VARCHAR2(3),
LIBCLASSPROD3 VARCHAR2(30));
CREATE INDEX CLASSPROD3_FK1 ON CLASSPROD3(LIBCLASSPROD3) TABLESPACE INDX;
CREATE INDEX CLASSPROD3_FK2 ON CLASSPROD3(CODECLASSPROD2) TABLESPACE INDX;
CREATE UNIQUE INDEX CLASSPROD3_PK ON CLASSPROD3(CODECLASSPROD3) TABLESPACE INDX;
INSERT INTO RB_TABLE
VALUES
('CLASSPROD2', 'CLASSPROD2');
INSERT INTO RB_TABLE
VALUES
('CLASSPROD3', 'CLASSPROD3');
INSERT INTO RB_FIELD ( TABLE_NAME, FIELD_NAME, FIELD_ALIAS, DATATYPE, SELECTABLE, SEARCHABLE,
SORTABLE, AUTOSEARCH, MANDATORY ) VALUES (
'CLASSPROD2', 'CODECLASSPROD2', 'Codeclassprod2', 'dtString', NULL, 'T', 'T', 'F'
, 'F');
INSERT INTO RB_FIELD ( TABLE_NAME, FIELD_NAME, FIELD_ALIAS, DATATYPE, SELECTABLE, SEARCHABLE,
SORTABLE, AUTOSEARCH, MANDATORY ) VALUES (
'CLASSPROD2', 'CODECLASSPROD1', 'Codeclassprod1', 'dtString', NULL, 'T', 'T', 'F'
, 'F');
INSERT INTO RB_FIELD ( TABLE_NAME, FIELD_NAME, FIELD_ALIAS, DATATYPE, SELECTABLE, SEARCHABLE,
SORTABLE, AUTOSEARCH, MANDATORY ) VALUES (
'CLASSPROD2', 'LIBCLASSPROD2', 'Libclassprod2', 'dtString', NULL, 'T', 'T', 'F', 'F');
COMMIT;
INSERT INTO RB_FIELD ( TABLE_NAME, FIELD_NAME, FIELD_ALIAS, DATATYPE, SELECTABLE, SEARCHABLE,
SORTABLE, AUTOSEARCH, MANDATORY ) VALUES (
'CLASSPROD3', 'CODECLASSPROD3', 'Codeclassprod3', 'dtString', NULL, 'T', 'T', 'F'
, 'F');
INSERT INTO RB_FIELD ( TABLE_NAME, FIELD_NAME, FIELD_ALIAS, DATATYPE, SELECTABLE, SEARCHABLE,
SORTABLE, AUTOSEARCH, MANDATORY ) VALUES (
'CLASSPROD3', 'CODECLASSPROD2', 'Codeclassprod2', 'dtString', NULL, 'T', 'T', 'F'
, 'F');
INSERT INTO RB_FIELD ( TABLE_NAME, FIELD_NAME, FIELD_ALIAS, DATATYPE, SELECTABLE, SEARCHABLE,
SORTABLE, AUTOSEARCH, MANDATORY ) VALUES (
'CLASSPROD3', 'LIBCLASSPROD3', 'Libclassprod3', 'dtString', NULL, 'T', 'T', 'F', 'F');
COMMIT;
INSERT INTO RB_JOIN ( TABLE_NAME1, TABLE_NAME2, JOIN_TYPE, FIELD_NAMES1, OPERATORS,
FIELD_NAMES2 ) VALUES (
'CLASSPROD3', 'CLASSPROD2', 'dajtInner', 'CODECLASSPROD2', '=', 'CODECLASSPROD2');
COMMIT;
