View previous topic :: View next topic
|
Author |
Message |
kavikesav
New User
Joined: 22 Mar 2007 Posts: 21 Location: chennai
|
|
|
|
I have code like
IF &ACCT = THEN +
SET &ACCT = &SUBSTR(1:18, )
but when i give a input as FHGFSFK---GHK--100
it is throwing me a error
IF FHGFSFK---GHK--100 = THEN
THIS STATEMENT HAS AN EXPRESSION WITH A CHARACTER DATA ITEM USED NUMERICALLY
***
any idea about it????
can anybody help me out?????? |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Please post more of your code using copy/paste.
Is this
Quote: |
IF FHGFSFK---GHK--100 = THEN |
really in the code? |
|
Back to top |
|
|
kavikesav
New User
Joined: 22 Mar 2007 Posts: 21 Location: chennai
|
|
|
|
in the panel i am receiving the input as fhfgk----&ahgfskg and i am checking in the code that whether it is blank or not..... for that only it is showing me error.....i am unable to give input with any special characters like @ - & * what can i do for that ???? my input data is having some special characters ... |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
&str(FHGFSFK---GHK--100 ) |
|
Back to top |
|
|
kavikesav
New User
Joined: 22 Mar 2007 Posts: 21 Location: chennai
|
|
|
|
in the panel i am getting FHGFSFK---GHK--100 as input using a variable &acct
then in the program i m checking as
if &acct = then
say key is not ok
else
&file=&acct
while executing the code it is throwing me the error as
IF FHGFSFK---GHK--100 = THEN
THIS STATEMENT HAS AN EXPRESSION WITH A CHARACTER DATA ITEM USED NUMERICALLY
what can be done to get the input with hyphens and ambersons in the panel |
|
Back to top |
|
|
kavikesav
New User
Joined: 22 Mar 2007 Posts: 21 Location: chennai
|
|
|
|
can anybody reply to mine |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Did you try what was suggested?
Quote: |
&str(FHGFSFK---GHK--100 ) |
If not, do so - if you did and still have problems, post the problem you see.
If it works, it is good to let the forum know and then others may learn. |
|
Back to top |
|
|
kavikesav
New User
Joined: 22 Mar 2007 Posts: 21 Location: chennai
|
|
|
|
ya it is accepting if the hyphens are there but when & is used it is not accepting the data ex:if the input is like abcd&efgh--101 then it is stored as abcd--101..... |
|
Back to top |
|
|
|