Re: Why doesn't forms 4.0 relation work?
Date: 1995/09/11
Message-ID: <VHAUSWUR.43.3053DFF5_at_Materna.DE>#1/1
In article <42q83v$dn4_at_butch.lmsc.lockheed.com> e247523_at_l10a.decnet.lockheed.com (D. Register) writes:
>From: e247523_at_l10a.decnet.lockheed.com (D. Register)
>Subject: Why doesn't forms 4.0 relation work?
>Date: 8 Sep 1995 20:12:47 GMT
>After looking through more than 600 postings, I still haven't found any
>that can help me. I am using Forms 4.0 and am trying to make a
>relatively simple form with one parent table and several child tables.
>I tried entering data from a generated form and the records were stored
>(verified using SQLDBA) in each of the tables but when I do a query,
>only the parent table information shows. I can look at the relation
>and see that the keys are tied together. Does anyone have any
>suggestions?
>Damon
Is the datatype of the key in the database which ties parent and child of type
'CHAR(>1)'?
Forms only knows a type CHAR on the client and doesn't take care of the
different datatypes CHAR and VARCHAR2 in the database. It may be the problem.
It is solved if you change it to VARCHAR2 in the database.
Good luck
Volker
Received on Mon Sep 11 1995 - 00:00:00 CEST