×
Discuss about Archiving, Close of Business, Delivery Setup, Security Management System, Global Processing etc…
wrong Alphanumeric char
- ppnartey
- Topic Author
- Offline
- Junior Member
-
Less
More
- Posts: 30
- Thank you received: 0
15 years 2 months ago #3700
by ppnartey
wrong Alphanumeric char was created by ppnartey
Hello
the EMAIL field in our system does not accept the _(underscore character), but the Local Table definition for the field appears fine. Any assistance on how we can fix this would be much appreciated.
thnx
the EMAIL field in our system does not accept the _(underscore character), but the Local Table definition for the field appears fine. Any assistance on how we can fix this would be much appreciated.
thnx
Please Log in or Create an account to join the conversation.
- bala_gates
- Offline
- Premium Member
-
Less
More
- Posts: 152
- Thank you received: 0
15 years 2 months ago #3704
by bala_gates
Replied by bala_gates on topic Re:wrong Alphanumeric char
SET "ANY" IN CHAR TYPE OF YOUR LOCAL FIELD AND TRY
Please Log in or Create an account to join the conversation.
- ppnartey
- Topic Author
- Offline
- Junior Member
-
Less
More
- Posts: 30
- Thank you received: 0
15 years 2 months ago #3707
by ppnartey
Replied by ppnartey on topic Re:wrong Alphanumeric char
yes the char field is set to A but still does not allow it.
thnx
thnx
Please Log in or Create an account to join the conversation.
- bala_gates
- Offline
- Premium Member
-
Less
More
- Posts: 152
- Thank you received: 0
15 years 2 months ago #3716
by bala_gates
Replied by bala_gates on topic Re:wrong Alphanumeric char
Hello Friend
I am telling you to put "ANY" and not "A". If you drill down that field you will be seeing "ANY".
I am telling you to put "ANY" and not "A". If you drill down that field you will be seeing "ANY".
Please Log in or Create an account to join the conversation.
- ppnartey
- Topic Author
- Offline
- Junior Member
-
Less
More
- Posts: 30
- Thank you received: 0
15 years 2 months ago #3717
by ppnartey
Replied by ppnartey on topic Re:wrong Alphanumeric char
well there is no 'ANY' in the drill down just A, AA, AAA and others. we use g13 on jbase4.1 if it matters.
thnx
thnx
Please Log in or Create an account to join the conversation.
- bala_gates
- Offline
- Premium Member
-
Less
More
- Posts: 152
- Thank you received: 0
15 years 2 months ago #3718
by bala_gates
Replied by bala_gates on topic Re:wrong Alphanumeric char
i am looking in r8 and sending solution to you. It is better if you say in which version you are working when you are initiating this subject. It will be easy for the helpers to see that version if available with them.
Please Log in or Create an account to join the conversation.
- ppnartey
- Topic Author
- Offline
- Junior Member
-
Less
More
- Posts: 30
- Thank you received: 0
15 years 2 months ago #3728
by ppnartey
Replied by ppnartey on topic Re:wrong Alphanumeric char
we are using g13 on jbase4.1 on windows server 2003. thnx
Please Log in or Create an account to join the conversation.
- thisisavin
- Offline
- Premium Member
-
Less
More
- Posts: 84
- Thank you received: 1
15 years 2 months ago #3730
by thisisavin
Replied by thisisavin on topic Re:wrong Alphanumeric char
hi,
Did you try inputting the value ANY in the field CHAR.TYPE for that field in LOCAL.TABLE? Try defining the CHAR.TYPE as TEXT and check that too.
regards
dj
Did you try inputting the value ANY in the field CHAR.TYPE for that field in LOCAL.TABLE? Try defining the CHAR.TYPE as TEXT and check that too.
regards
dj
Please Log in or Create an account to join the conversation.
- concern
-
- Offline
- Premium Member
-
- R20 | TAFJ | ORACLE
Less
More
- Posts: 89
- Thank you received: 4
15 years 1 month ago #3850
by concern
Replied by concern on topic Re:wrong Alphanumeric char
if all fails then include the "_" character in the tables
ASCII.VAL.TABLE
ASCII.VALUES
ASCII.VAL.TABLE
ASCII.VALUES
Please Log in or Create an account to join the conversation.
Time to create page: 0.093 seconds