garlapati
7th April 2009, 14:24
I have enum domain with french character.the table convert to DD was sucessful & data also got created.

i am using this domin in some script as below.

oncase value:
case tppdm.tcli.Propriétaire:statment
case tppdm.tcli.Expéditeur :statment
case tppdm.tcli.Equipement :statment

when i try to compile scirpt i get error as below

Error SQL: Unknown column 'tppdm.tcli.propri'
Error SQL: syntax error:'étaire' not expected

has any one got ideas, what should be done.

thanks for the help to rectify.

Regards
Sunil.G

_Ralph_
7th April 2009, 17:04
Special characters can not be successful compiled. If you pay attention you wont find then on the ASCII table.

I suggest you to rebuild the domain without the special chars..

garlapati
7th April 2009, 18:34
we dont have any problem on table part & convert to DD. only in script its not being recognized.
On client system we are able to compile it sucesfully.no problems at all. on our local sytem we have this problem.
Does it related with fonts (ISO 8XXXX) problem?

please suggest to solve issue.

Regards
Sunil.G

zardoz
7th April 2009, 19:23
There is no need to use french words in the enum constant definition, it is much better to use english words so everyone can understand it.
Of course, you can/must use french descriptions in the interface for the users, so why do you complicate your life in this way?

garlapati
9th April 2009, 12:55
the problem is not with creating new domain & using it. the domain is already created by user & being used at lot of scripts, thats the problem. If the script is compiled on customer server its working fine. if the script is being compiled on our devlopemnt server its giving error. we need to migrate the scripts for customer. So we need to migrate & compile on our local server. but this is giving error.

has any one faced this situation.

Regards
Sunil.G