code to integer and sql migration

Cindy101
Cindy101 Member Posts: 33
edited 2009-06-22 in NAV/Navision Classic Client
Hello,

I've run into an issue and am unsure how to solve it. I've migrated an upgraded database to sqlserver but I have a problem with the Customer."No." field. The ordering is way off, I'm sure this is a code[20] to varchar(20) issue but I don't know how to resolve it (I thought this conversion would happen automagically). I've made sure that the table contains only integer compatible values but how I don't know how to switch it to int?

The issue comes up because of some funky ordering - for example

Customer No.
1001
10001
10002
...
9001
90001

Thanks for any help you can provide!

Answers

  • kriki
    kriki Member, Moderator Posts: 9,121
    You can put the field property "SQL Data Type" to variant. But this means that you should do it for ALL fields in which a customer no. can be put. And some of those fields can also contain vendor nos...

    Better would be to rename the customer nos.
    e.g.
    C01000
    C10000
    C10001
    ...
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

Categories