Home » Developer & Programmer » Forms » FRM-40105:UNABLE TO RESOLVE REFERENCE TO ITEM
FRM-40105:UNABLE TO RESOLVE REFERENCE TO ITEM [message #172322] Tue, 16 May 2006 01:05 Go to next message
ramanajv1968
Messages: 168
Registered: December 2005
Location: HYDERABAD
Senior Member

Hi ,

I created a login screen that allows users to input a username and password. If the password is inserted and is correct they move onto another canvas if not then it brings up an alerts stating that the password is wrong or username.

for that i wrote the following code,

select 'x' into :global.dummy
from users
where user_name = :users.user_name
and user_password = :users.user_password;

message('Username and password are correct ');
go_item('ADMIN_CANVAS')

exception
when no_data_found then
message('Username and/or password are incorrect');
raise form_trigger_failure;

WHEN I PRESS THE BUTTON ,IT IS GIVING THE FOLLOWING ERROR,

FRM-40105:UNABLE TO RESOLVE REFERENCE TO ITEM ADMIN_CANVAS.

But, i created ADMIN_CANVAS in canvas even though i am getting the error.

Please help me.

Thanks ,
ramana
Re: FRM-40105:UNABLE TO RESOLVE REFERENCE TO ITEM [message #172335 is a reply to message #172322] Tue, 16 May 2006 01:49 Go to previous message
gacki
Messages: 33
Registered: May 2006
Location: Dueren, NRW, Germany
Member
With go_item you navigate to an item on a block. So you need to specify the blockname and itemname, not a canvasname:
go_item('<block>.<item>')

Gerald
Previous Topic: Send Value to a Form from a Report
Next Topic: Set Format_mask for a variable
Goto Forum:
  


Current Time: Wed Oct 22 10:40:29 CDT 2014

Total time taken to generate the page: 0.08900 seconds