Web Development

Question

Gravatar
0 Votes
Locked

left join in Oracle Forms

By john.a.wills ·
I have a form with a header or key block and a detail block with personal information coming from table spbpers and aid information coming from table rjrsear. In the detail block I have query data source name: SPBPERS left join RJRSEAR on RJRSEAR_PIDM = SPBPERS_PIDM and RJRSEAR_AIDY_CODE = :keyblck_aidy_code
.I have WHERE clause:
SPBPERS_PIDM = :keyblck.pidm
. When I do next-block to the block on the form I get the messages FRM-40505 Oracle error: unable to perform query and ORA-01008 not all variables bound, with the query shown having the colon still before the keyblck_aidy_code and 3 extra conditions ANDed into the WHERE clause.

When I use a constant for the keyblck_aidy_code I get good results for a student who has aid (rjrsear) data but a message that the query retrieved nothing for the student who has no aid data.

How should I compose my Query Data Source Name?

I get good results for both students in SQL*Plus.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

gravatar
Collapse -

partial resolution

by john.a.wills In reply to left join in Oracle Forms

In the NextBlk trigger leading to this block I construct the query source entry, using the variable which Forms could not bind. I still have problems with the LEFT JOIN acting like an INNER JOIN, but I will detail those in another Question.

Back to Web Development Forum

Start or search

Related Discussions

Related Forums