Home » Developer & Programmer » Forms » how get selected data at opening time
- how get selected data at opening time [message #159472] Sun, 19 February 2006 23:53 Go to next message
mfa786
Messages: 210
Registered: February 2006
Location: karachi
Senior Member

i am Muhammad fahim Aamir from pakistan i use oracle form can you give me some idea

i have many year account data i need when my user use application that use only current year data i have year table
yearid
yeartitle

this yearid i pass as fk in all table

but how pass this my query in execute query or fatch only selected record form my other table

please send me any idea or sample

Thanking you

Muhammad Fahim Aamir

Report message to a moderator

- Re: how get selected data at opening time [message #159482 is a reply to message #159472] Mon, 20 February 2006 00:34 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
In when-new-form-instance trigger get the 'year' from your table into a control block item, for example, ':ctrl.year'. Then use the following code:
Code: [Select all] [Show/ hide]
set_block_property('your_blk',default_where,'year = :ctrl.year');
go_block('your_blk');
execute_query;
David

Report message to a moderator

Previous Topic: Controlling the resolution of the screens
Next Topic: error on connect sqlserver
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Mar 08 04:21:57 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.