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

Report message to a moderator

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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Feb 01 22:42:29 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.