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
NiceMan331Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

HuaMin ChenProblem resolverCommented:
Can you instead create database block by putting the current table name to that block, and retry? thanks
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 ?
HuaMin ChenProblem resolverCommented:
To shift it to tabular database block. thanks
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.