Migrating to SQL - Changing SQL data type

mart1n0

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?

DenSter

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?

mart1n0

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

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.

kriki

[Topic moved from Navision forum to SQL General forum]