Problem in Code field

Business Central/NAV Technical Forum
1

hi friends

i am trasfering values to a temparory table(Field type : varchar) from another DB (SQL 2000) my Back end also sql2000 (Feild type : varchar)

when i run that temparory table inside navision then there is a error massage saying . The temp-PO table contains a value in a code field that canot be used with microsoft business solutions Field : user id value : Dilan

Please giud me to solve this problem

regurds

satheesh

2

Hi!

In NAV the “Code”-type fields must only contain uppercase characters, so when transferring the value via SQL you should use the UPPER() function!

Regards,

Jörg

3

hi jorg

thanx i have solve that problem . according to u r advice

regards

satheesh