Hello,

i have one custom table, one of it field has a domain text.

i want to populate data into this table from sql table.

i tried using exchange scheme but text field is not getting updated or generating text numbers.

any help will be appreciated.

Thanks
Jay

It can be done with exchange, but I no longer have an example of what was done to be done to actually create the text and update the field in the table. You might be able to search the forum and find an example. Now a days I would write a program to read in the text I wanted. Then I would write a temporary file with the text, then use text.write(or text.rewrite) function to write the text back into the table.

thanks mark.

Found the Solution.

to import textfield below is the syntax ->
Ascii file :
field1|
{\{txta 2
field2(put actual text here)
}\}

txta is a baan field name
2 is language code
{\{ starting clause
}\} ending clause
| is a seperator

Thanks
Jay

Note my answer is for baan IV so may not apply for you.

You only need the {\{....}\} if you are doing multi line text. If the text string you wish to import is a single line you can just format it the same as the other fields in your import batch. If the field you are populating is a text field you can either import literal text as a string or a text number of a pre-existing text. This is controlled by the table relations setting in your import batch.

Can we append Text to existing Text through Exchange Multi-line option.
Means We already have text in for the Item, we want to add or append to the existing text. How do we do it?

Thanks

Jay

Can we append Text to existing Text through Exchange Multi-line option.
Means We already have text in for the Item, we want to add or append to the existing text. How do we do it?

Thanks

Jay

Yes, you can.
On form 3 of session tuxch0122s000 (maintain field relations, import) you have a yes/no field for append. If you say "no" it will overwrite any existing text, "yes" will append it.

Thanks Gary.
Got it.