Home » Developer & Programmer » Forms » block based on two tables
block based on two tables [message #81680] Tue, 11 March 2003 08:09 Go to next message
kim
Messages: 116
Registered: December 2001
Senior Member
hello,
i am trying to create a block based on two tables. i made one block and then under the property "Query Data Source Name" put in course,history. In my code i entered...

set_block_property ('hdr',DEFAULT_WHERE,
'tr_history.courseid(+) = tr_course.courseid
and tr_history.rccode(+) = :key.rccode
and tr_course.cat1code = :key.cat1');
set_block_property('hdr',ORDER_BY,'tr_course.course_desc');
execute_query;

this is not working... what did i miss? thanks.

Report message to a moderator

Re: block based on two tables [message #81688 is a reply to message #81680] Tue, 11 March 2003 12:04 Go to previous message
magnetic
Messages: 324
Registered: January 2003
Senior Member
and tr_history.rccode(+) = :key.rccode
means
and 1=1
and null=1
wich results nothing
try to run it without the (+) mentions

Report message to a moderator

Previous Topic: setting record colors
Next Topic: avoiding an ora-01422 error
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jun 28 23:19:06 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.