data type in navision that can hold more than 250 characters

jks

I want to store a text containing more than 250 characters in navision database.

How can i do that?

Thanks for any help.

jks

Can i add one field of type bigtext in a table of navision database?

Thanks for any help

saikiran

Hi JKS,

What exactly do you need Bigtext (rather the field) for? You can always use BigText, because it is used to store even huge documents. But it has its own drawbacks, like you cannot show what is stored in the BigText in a message window.
So, think before you use it.

jks

Hi,

In my excel sheet i have one field containing a text having >250 characters. I want to transfer that text from excel to sql server(i.e. in one table of navision database). What should be the datatype of the field in navision table that can hold such a big text?


How to do this?

Please help.

jks

Can i use the BLOB field?
How can i transfer my data from excel to blob field?
In which trigger should i write my c/al code to do this?


Please help.

micheldogger

Consider for yourself what the use is of that text, is it one line in your excel sheet that contains more then 250 characters, or a lot? If your customer needs to fill a lot of text like comments, you maybe can make use of the navision Comment-functionality.