Solved

filter data block

Posted on 2014-10-11
6
160 Views
Last Modified: 2014-10-17
hi
i have tabular form based on database table
i want to filter records based on many criteria

i started with one column like this :

i created no database block , create non database item name it : t_date  
i created one push button , i set the when button press like this
 
SET_BLOCK_PROPERTY('gen_ledgers',DEFAULT_WHERE ,to_date(:genral.t_date)); 
  execute_query; 

Open in new window

but when i select a date into t_date then i pressed the button , it return error , enable to perform a uqery
0
Comment
Question by:NiceMan331
  • 4
  • 2
6 Comments
 
LVL 10

Expert Comment

by:HuaMinChen
ID: 40374539
Can you instead create database block by putting the current table name to that block, and retry? thanks
0
 

Author Comment

by:NiceMan331
ID: 40374553
you mean instead of creating the non_database block , i create another database block ?
or to shift the non_database items to the tabular database block ?
0
 
LVL 10

Expert Comment

by:HuaMinChen
ID: 40374629
To shift it to tabular database block. thanks
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

Author Comment

by:NiceMan331
ID: 40374642
sorry , i didn't understand
can please do more explanation
0
 

Accepted Solution

by:
NiceMan331 earned 0 total points
ID: 40374950
i got the solution
i had mistake in the trigger
the correct  code is like this

declare
	x varchar2(1000); 
begin

	X := 'Acc_no = 21210';
	X := X || '  AND   ' || 'doc_date > = ' || chr(39) ||to_char(:gen_ledgers.F_date, 'dd-mm-yyyy')|| chr(39);
	x := X || '  AND   ' || 'doc_date < = ' || chr(39) ||to_char(:gen_ledgers.t_date, 'dd-mm-yyyy')|| chr(39);

   SET_BLOCK_PROPERTY('gen_ledgers',DEFAULT_WHERE ,x);
 
   execute_query; 
 
   end;

Open in new window

0
 

Author Closing Comment

by:NiceMan331
ID: 40386236
i got no useful answer
then i search the web , i found the answer in another site
if you like to not accept my answer , i have no problem to delete the question
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…

861 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question