OraFAQ Forum: Forms » declare message for @ is not type in email address (merged 2)

Home » Developer & Programmer » Forms » declare message for @ is not type in email address (merged 2) (Froms 6i)

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

declare message for @ is not type in email address (merged 2) [message #528310]

Mon, 24 October 2011 04:21

qaiserjavid
Messages: 25
Registered: May 2011
Location: Pakistan

Junior Member

dear friends;
i want a help please guide me
i want if user is not type the @ in email text box than from show the message
"check your email address"
but i cant do that
please check my code
emailaddress is my column name in table.

declare
ok_flag number :=0;
begin
ok_flag :=instr('emailaddress','@');
if
ok_flag < 1 then
message('invalid email');
else
message('thanks');
end if;
end;

Report message to a moderator

Re: declare message for @ is not type in email address (merged 2) [message #528315 is a reply to message #528310]

Mon, 24 October 2011 04:38

cookiemonster
Messages: 13975
Registered: September 2008
Location: Rainy Manchester

Senior Member

1) Please read and follow How to use [code] tags and make your code easier to read?
2) This:

'emailaddress'

Is not a column, or a form item. It's a text string. And it doesn't contain @.
To refer to forms items in code you need to put a colon in front of it. And not put it in quotes. And supply the block name.
So:

ok_flag :=instr(:<name of data block>.emailaddress,'@');

Report message to a moderator

Re: declare message for @ is not type in email address (merged 2) [message #529712 is a reply to message #528310]

Wed, 02 November 2011 10:58

qaiserjavid
Messages: 25
Registered: May 2011
Location: Pakistan

Junior Member

dear admin;
i have tried this code but it does not work please give other code if u have.
please one more code
i want to generate bar code but i don't know how can i do.

Report message to a moderator

Re: declare message for @ is not type in email address (merged 2) [message #529718 is a reply to message #529712]

Wed, 02 November 2011 11:43

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

Senior Member
Account Moderator

Quote:

i have tried this code but it does not work

Please, post code you have tried. Explain what happened (provide details about error message(s), if possible).

Report message to a moderator

Re: declare message for @ is not type in email address (merged 2) [message #529880 is a reply to message #529718]

Thu, 03 November 2011 08:49

qaiserjavid
Messages: 25
Registered: May 2011
Location: Pakistan

Junior Member

ok_flag number :=0;
begin
ok_flag :=instr(:Records.emailaddress,'@');
if
ok_flag < 1 then
message('invalid email');
else
message('thanks');
end if;
end;

Here records is data block name and emailaddress is column name.
when i execute this code it does not work.
show no error at run time.

Report message to a moderator

Re: declare message for @ is not type in email address (merged 2) [message #529882 is a reply to message #529880]

Thu, 03 November 2011 08:52

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

Senior Member
Account Moderator

What was the input?

Report message to a moderator

Re: declare message for @ is not type in email address (merged 2) [message #529887 is a reply to message #529882]

Thu, 03 November 2011 09:05

cookiemonster
Messages: 13975
Registered: September 2008
Location: Rainy Manchester

Senior Member

And what trigger is the code in?

Report message to a moderator

Re: declare message for @ is not type in email address (merged 2) [message #529888 is a reply to message #529882]

Thu, 03 November 2011 09:05

qaiserjavid
Messages: 25
Registered: May 2011
Location: Pakistan

Junior Member

i want to put email address of employees
for example
Qaiser@yahoo.com
i want if user is not typing @ in text field then show error message
'your email address is not valid please retype your email address'

else message 'welcome'

Report message to a moderator

Re: declare message for @ is not type in email address (merged 2) [message #529889 is a reply to message #529888]

Thu, 03 November 2011 09:10

cookiemonster
Messages: 13975
Registered: September 2008
Location: Rainy Manchester

Senior Member

That code will do that (you've coded different message text mind).
What trigger is the code in?

Report message to a moderator

Previous Topic:	Problem with fetching data
Next Topic:	How to add exception in given below query

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 23 03:23:03 CST 2026