Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 170
  • Last Modified:

filter data block

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
NiceMan331
Asked:
NiceMan331
  • 4
  • 2
1 Solution
 
HuaMinChenBusiness AnalystCommented:
Can you instead create database block by putting the current table name to that block, and retry? thanks
0
 
NiceMan331Author Commented:
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
 
HuaMinChenBusiness AnalystCommented:
To shift it to tabular database block. thanks
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
NiceMan331Author Commented:
sorry , i didn't understand
can please do more explanation
0
 
NiceMan331Author Commented:
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
 
NiceMan331Author Commented:
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

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now