Mike Slinn wrote: > > > I want to join two tables into a view. Each table has a LONG column. > When I SELECT from the view, the first LONG is blank. If I > change one of > the LONGs to a VARCHAR, it works fine. How can I get around > this problem? > > CREATE TABLE prima ( > oid INTEGER, > CONSTRAINT prima_pk PRIMARY KEY(oid), > val long DEFAULT '') > // > CREATE TABLE sec1 ( > oid INTEGER DEFAULT SERIAL, > CONSTRAINT sec1_pk PRIMARY KEY(oid), > CONSTRAINT sec1_fk FOREIGN KEY(oid) REFERENCES prima(oid) ON DELETE > CASCADE, > val long DEFAULT '') > // > CREATE VIEW V2 (OID, val, VAL1) AS > SELECT P.OID, p.val, S1.VAL > FROM PRIMA P, SEC1 S1 > WHERE P.OID = S1.OID > WITH CHECK OPTION > // > INSERT INTO v2 (oid, val, val1) VALUES (1, 'prima a', 'sec1 a') > // > INSERT INTO v2 (oid, val, val1) VALUES (2, 'prima b', 'sec1 b') > // > INSERT INTO v2 (oid, val, val1) VALUES (3, 'prima c', 'sec1 c') > // > select * from v2
The select is not the problem. Inserting long-columns via an updatable JOIN-view does not work. --> do the inserts of the long-columns into the primary tables, not in the joinview. And we will try to fix the bug as soon as possible. Elke SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
