Solved

filter data block

Posted on 2014-10-11
6
162 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

 

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

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.

732 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