Home » Developer & Programmer » Forms » Same Query Gives different result in Same database
Same Query Gives different result in Same database [message #221280] Mon, 26 February 2007 03:06 Go to next message
parthaspaul
Messages: 9
Registered: December 2006
Location: KOLKATA
Junior Member

Hi All!

I've used the following code in my form :


select count(*) into cnt from md_person_dept a, mm_login_user b
where a.PERSON_CODE =b.person_code and user_id=:global.user_id
and a.txt_project_id=b.txt_project_id
and a.txt_project_id=:global.g_proj_code_ca_bkup_presla
;


----------------
This piece of code is in new-form-instance trigger.
When the form is running it fetches into cnt 0 value whether I excute the query in TOAD it shows 54 .

The most interesting thing is that when I write the query as
select count(*) into cnt from md_person_dept a, mm_login_user b
where a.PERSON_CODE =b.person_code
and a.txt_project_id=b.txt_project_id
and a.txt_project_id=:global.g_proj_code_ca_bkup_presla
and user_id=:global.user_id
;


Then in form runtime and TOAD both it fetches 54 count.

Please tell me why it happens??

Urgent ly please.

Thanks.

Partha Sarathi Paul.
Re: Same Query Gives different result in Same database [message #225384 is a reply to message #221280] Mon, 19 March 2007 19:05 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have you solved your problem?

Does this code exist before or after the sign-on code that you have in the When-New-Form-Instance trigger?

David
Previous Topic: Insert image Internal Error
Next Topic: how to run form runtime at dos
Goto Forum:
  


Current Time: Wed Dec 07 10:58:55 CST 2016

Total time taken to generate the page: 0.10152 seconds