Hi,

can you help me please?


I am inserting text from a file. I insert directly in tables tttxt001, tttxt002 and tttxt010 and all is correct, but when I see the text from the session, the text changes and lines and aligment chage too.

example:

File:

3A13031100210500;5;DOCUMENTACION APLICABLE:
Plano: 135-02662
Rev.: A (hoja 2)
LP.: 135-02662-003
Rev.: A
************************************************
NORMAS APLICABLES:
PCA-00-019 PROC.IDENTIFICACION.
PCA-00-025 PROC.INSPEC. FINAL.
PCA-00-027 INST.GENER.SUBCONTR.
NE03-051 CHAFLANES Y REBABAS.
NE01-103 IDENTIF. Y MARCAJE.
NE03-73 GEOMETRIC DIMENSIONING AN TOLERANCING.
NE03-080 GENERAL TOLERANCES FOR SHEET OR EXTRUDED PARTS.
NE40-143 APLIC. EPOXY PRIMER.
NE40-006 CHEMICAL CONVERSION ON ALUMINIUM.
NE03-076 ALUMINUN PARTS-FORMING AND STRAIGHTENING.
NE40-160 APLIC. POLYURETHANE ENAMEL.

And in table tttxt010: first i can see the same in each line. 19 lines

But when i open text in the session tccal0101m00, i see:

DOCUMENTACION APLICABLE:
Plano: 135-02662
Rev.: A (hoja 2)
LP.: 135-02662-003
Rev.: A

and when I close the text window , the records in table changes like:

there are only 7 lines in tttxt010.

What i can do?

From what I could gather from your description, it is difficult to say where exactly something is going wrong -- it could be the way you are inserting in the tables or the way the text is viewed/updated from tccal0101m00.

However, as far as is possible, you should avoid inserting text directly into Tools text tables. Baan has simple and easy-to-use functions like text.write() to write text into tables from a file. If you look at the syntax of text.write(), you will see how simple it will be to call the function to write your text form the file to the tables. And it will take care of writing to related text tables on its own. Only thing is you have to handle your transaction - commit it at the right place.

Hope this helps.

NVP

I've successfully been able to insert text from a file for an item. I am however having issues with alignment. Has anyone been able to have the text display correctly by using this? This is what I've done in testing - I found text on an item that I want my new text to look like, it is several lines. I've copied the text from the t_text field, where it is just one record and all the text is in one t_text field, and pasted into my file. So it's just one record in my file. I am able insert the text but when I go to the item and look at the text it isn't lined up at all like the original. any ideas?

-nikkiz