Migrating to SQL - Changing SQL data type

mart1n0
mart1n0 Member Posts: 123
edited 2007-03-02 in SQL General
I'm trying to migrate a Native Navision 3.7 to SQL option, I stick to 3.7. I used the migrate.fob and the documentation says to open the form Code Field Information.

I opened this form and want to change the SQL Data Type for some of the rows as indicated in the documentation only I cannot change the type, it stays put to varchar. If I click on the drop down I see integer too but I cannot select it.

Any idea what I missed or forgot to do?

Comments

  • DenSter
    DenSter Member Posts: 8,307
    You can change the SQL Server datatype of code fields with a property. It would be in the property page, not in the datatype dropdown list.

    What exactly do you want to do?
    Daniel Rimmelzwaan
    RIS Plus, LLC
  • mart1n0
    mart1n0 Member Posts: 123
    Ok, I'll have a look if this is possible somewhere, as the guide seems to suggest you should be able to change it on the dropdown of the form itself.
  • DenSter
    DenSter Member Posts: 8,307
    I guess that depends on what form you're talking about :-k

    Steps:
    - Click 'design' when your cursor is on your table in the object designer
    - Move your cursor to the code field you are talking about
    - Open the properties page (Shift+F4)
    - The "SQL Data Type" property is the 4th one from the bottom.

    You can set it to VarChar, Integer or Variant. It might not let you change it to certain values depending on the data that is in your table. If you have a non-numerical value in any of the records, it is not going to let you set it to integer for instance. Read F1 help for more information.
    Daniel Rimmelzwaan
    RIS Plus, LLC
  • kriki
    kriki Member, Moderator Posts: 9,121
    [Topic moved from Navision forum to SQL General forum]
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

Categories