OraFAQ Forum: Forms

Home » Developer & Programmer » Forms » help me (oracle 10g,window xp)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

help me [message #492392]

Sun, 30 January 2011 22:43

helloworld_28
Messages: 60
Registered: October 2010

Member

hi,

iam in my pratices , i have two block if you type deptno number ,it should show the emp detail in emp block , ihave done that i have problem when i write a post-query trigger for finding count of emp name in that particular department. please help me i have attach fmb part.

Attachment: count1.fmb
(Size: 96.00KB, Downloaded 962 times)

Report message to a moderator

Re: help me [message #492401 is a reply to message #492392]

Mon, 31 January 2011 00:08

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I can't open your form with my Forms version. Could you post POST-QUERY trigger and, above all, explain WHAT problem you have?

Report message to a moderator

Re: help me [message #492407 is a reply to message #492401]

Mon, 31 January 2011 00:43

ranamirfan
Messages: 535
Registered: January 2006
Location: Pakistan / Saudi Arabia

Senior Member

Dear,

Quote:

Set_block_property('EMP',onetime_where,'DEPTNO='||:DEPT.DEPTNO);
GO_BLOCK('EMP');
EXECUTE_QUERY;

No Need to write this code for Execute query against DeptNo.Please see below Screenshot.
You can use Form Menu Toolbar buttons for Entry Query & Execute Query.
/forum/fa/8656/0/

Regards,
Irfan

Attachment: Execute_Query.PNG
(Size: 57.72KB, Downloaded 1216 times)

Report message to a moderator

Re: help me [message #492409 is a reply to message #492407]

Mon, 31 January 2011 00:48

ranamirfan
Messages: 535
Registered: January 2006
Location: Pakistan / Saudi Arabia

Senior Member

Second for Count you can use Calculation Summary function.Please see below screenshot.

/forum/fa/8657/0/

Regards,
Irfan

Attachment: Count.PNG
(Size: 30.76KB, Downloaded 1263 times)

Report message to a moderator

Re: help me [message #492517 is a reply to message #492407]

Mon, 31 January 2011 21:17

helloworld_28
Messages: 60
Registered: October 2010

Member

hi ranamirfan,

thank for reply , mainly i have written post_query trigger for finding count (select count(ename) from emp where deptno =number)but it is not working.

Report message to a moderator

Re: help me [message #492528 is a reply to message #492517]

Tue, 01 February 2011 00:30

ranamirfan
Messages: 535
Registered: January 2006
Location: Pakistan / Saudi Arabia

Senior Member

Dear,
Quote:

Mainly I have written post_query trigger for finding count (select count(ename) from emp where deptno =number) but it is not working.

You can achive this task using Forms Builder Property Palette as I attached screenshot in my previous post.

Regards,
Irfan

Report message to a moderator

Previous Topic:	download file from db server
Next Topic:	Project

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Sep 17 16:22:36 CDT 2024