mjpedreira1
15th October 2009, 19:13
Hello,

I have to insert a long text, with white lines, tabs, etc. What is the best type in Baan for these fields. What is the maximum length in Baan for a field like this?

Thanks,

María

_Ralph_
15th October 2009, 19:26
I could not understand what you're trying to do.

But if you what a field with a big capacity of characters you can create a new domain with 999 positions for example.

mjpedreira1
15th October 2009, 20:03
I need to insert a field with a length of 3000 characters from a extern database. After I insert this field, I have to read it and create a field text in a record.

999 is not enough ¿?

Thanks,

María

Juergen
16th October 2009, 09:37
If I understand correctly you want to import text to a text field. Why do you want first to insert the text to a field?

Regards,
Juergen

mjpedreira1
16th October 2009, 10:44
I create a text from a .NET application with a SQL Server database. The text could be big.
I need to mantain a Baan customize table with this information about texts. With this temporary table I will do the integration between .NET and Baan.
Finally I need to read the records and then populate text fields in the correct Baan Project tables.

Juergen
16th October 2009, 11:04
Check this thread http://www.baanboard.com/baanboard/showthread.php?t=24569&highlight=string+lenght

regards,
Juergen

mjpedreira1
16th October 2009, 11:40
What is the Baan domain for a 2 dimension string like this one?

string edi.record(100, 50)

mark_h
16th October 2009, 15:49
Not sure I understand if you are looking for a domain like tcitem(baan domain) I would not worry about it. Declaring something as string is the same as using a baan domain - and you can always add external on it. Or you can always create your own domain - I have never done a two dimensional array. So I am not positive I understand your question.