| Want to display record on non database item [message #566545] |
Mon, 17 September 2012 07:08  |
 |
glmjoy
Messages: 187
Registered: September 2011
Location: KR
|
Senior Member |
|
|
I want to display my query select * from Clinical_Chart_CCHPI in non database item which is 1000 Char. I want to display that query when my forms execute.
below is the test case.
Create table Clinical_Chart (Chart_Number Char(12),MR_NO Char(13));
Create table Clinical_Chart_CCHPI (Chart_Number Char(12),serial_number number,Date Date, Remarks Varchar(1000));
--------------------------
insert into Clinical_Chart(1,1);
insert into Clinical_Chart_CCHPI (1,1,01-JAN-2012,'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAaaaaaaaaaaaaaa');
insert into Clinical_Chart_CCHPI (1,2,02-JAN-2012,'BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBbbbbbbbbbbbbbbbbbbb');
insert into Clinical_Chart_CCHPI (1,2,03-JAN-2012,'CCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCcccccccc');
commit;
I have use my query in When_New_Form_Instance
my query is below
Declare
Lv_Sql Varchar2(5000);
Begin
lv_sql := 'Select* From CLINICAL_CHART_CCHPI';
SET_BLOCK_PROPERTY('BLOCK6',QUERY_DATA_SOURCE_name, lv_sql);
GO_BLOCK('CLINICAL_CHART');
clear_block;
execute_query;
End;
I have taken one non database block and my item Test which is non-database too. But no result is coming i have attached JPEG file too.
Thanking in Advance
GLMJOY
-
Attachment: test.JPG
(Size: 44.98KB, Downloaded 682 times)
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
