ODBC and field's length

Mct
Mct Member Posts: 30
edited 2010-05-03 in NAV/Navision Classic Client
Hello,

I have a visual basic application that works with 2.6 NODBC. Now my soft must run with Nav 6.0 (Not SQL version) and his ODBC.

My problem is the following, when i do a query if i have a field which is a 10 length code, my variable keeps space for example "25681 " instead of "25681" with the 2.6 ODBC.

So i wanna know if an ODBC parameter or tip can help me to avoid change every query in my soft ...

Comments

  • IsakssonMi
    IsakssonMi Member Posts: 77
    I've been there, I don't remember clearly but I guess the Nav uses e-ascii 250 so try replace it (alt-0250) by "".
    The 8 bit differs from different codepages, but I think this one is pretty universal.

    I guess this only occurs on CODE-fields with fixed sizes.
  • Mct
    Mct Member Posts: 30
    Thx you for your answer but i don't understand what you mean ...

    I need to replace something by "" but i don't understand what i have to change.

    And why are you talking about Alt 0250 (which is ú character)?

Categories