Re: Totally stuck with Forms6i ('reverse ON-POPULATE-DETAILS')

Volkmar,

I would try running the query in sqlplus (without the INTO clause) and seeing what kinds of error messages you get.

Matt.

vrw wrote:
>
> Hi everyone,
>
> First of all Merry Xmas, secondly:
> I have no clue how to achieve the following in Oracle's Forms designer:
> I have three tables in my underlying DB, they are:
>
> --------------- -----------------
> | Transcription| | V_Tape |
> --------------- -----------------
> \ /
> \ /
> /|\ /|\
> ----------------
> | A_Tape |
> ----------------
>
> (I truly hope this ASCII 'art' came over ok on your screens... In essence
> A_Tape is the link entity between Transcription and V_Tape.)
> When I now design my form, and the auto-code-generator fills in the details
> for A_Tape automatically (there is a parent table to Transcription, but none
> to V_Tape), but doesn't fill in the details for V_Tape. I guess it doesn't
> go 'up' the hierarchy ? So I have tried various things to display the
> corrent V_Tapes in V_Tape after A_Tape has been populated through
> Transcription, but to no avail. Forms always complains that it either cannot
> execute the query or it throws an exception.
> The fields in the tables are:
> primary keys are *tablename*_no (i.e. Transcription_no, etc.)
> and the blocks on my form are called V_Tape, A_Tape and Transcription.
>
> I have tried something like
>
> SELECT A_Tape.VTape_no
> INTO :V_Tape.VTape_no
> FROM A_Tape,V_Tape
> WHERE A_Tape.VTape_no = V_Tape.VTape_no;
>
> Is this anything like I should have ?
>
> Please help... I'd appreciate it very much.
>
> Regards,
>
> Volkmar
Received on Wed Dec 26 2001 - 22:44:09 CET