Baanboard.com

Baanboard.com (http://www.baanboard.com/baanboard/index.php)
-   Miscellaneous (http://www.baanboard.com/baanboard/forumdisplay.php?f=9)
-   -   Text Manager for Item Notes (http://www.baanboard.com/baanboard/showthread.php?t=69500)

giodan 1st December 2016 15:00

Text Manager for Item Notes
 
Hi all.
I need to know where i could find the BAAN code for text Manager beacuse I'll rewrite this code with c#.
Thanks all in advance

bhushanchanda 1st December 2016 16:05

Hi,

What are you looking to achieve? Baan stores the text's in a table tttxt010. Text manager is an inbuilt toolbar. You might need to call Baan DLL to insert the text using C#

giodan 2nd December 2016 14:59

Dear bhushanchanda thanks for your reply.
I'm recoding an ERP solution based on 4GL. The firm uses BAAN for every processes. Now I'm rewriting Goods Receipts in ASP .NET MVC and I'll need to read and write Notes for Quality Check process.
This notes will be visible as in my new software as in BAAN.
For this purpose I must write/read only tttxt010 table??

bhushanchanda 2nd December 2016 15:18

What you can do is, write a DLL in Baan which returns a text and then call it using C# code. There are several examples of how to call Baan DLL from external programs. Here's one example of calling from ASP.NET C#.

giodan 5th December 2016 10:40

Just another question...Where is defined the index t_ctxt of the notes table??

bhushanchanda 5th December 2016 11:11

Can you explain what do you mean by index t_ctxt of the notes table?

The table tttxt010 stores the text data. You can use function text.to.buf() for converting the text to a string and then return the text as a DLL output. Now, call the DLL from your external program.

giodan 6th December 2016 13:20

I don't use external DLL for text handling.
The field t_ctxt in tttxt010 table is a sequence number and i want to know what's the table handles this sequence

bdittmar 15th December 2016 14:11

tttxt010
 
Quote:

Originally Posted by giodan (Post 200134)
I don't use external DLL for text handling.
The field t_ctxt in tttxt010 table is a sequence number and i want to know what's the table handles this sequence

Hello,
the table tt txt 010 stores the textlines .
field tttxt010.ctext is the textnumber
field tttxt010.clan stores the text language
field tttxt010.seqe is the text line number
field tttxt010.text stores the text (string 240)

Example:
the item text in tcibd001 (Item master) is stored as text number in field tcibd001.txta.
This text, for example, consists of 6 lines
The text exists in language "2" (English)
Therefore in tttxt010 are 6 records
Code:

textnumber
language
line = 1
1st textline

textnumber
language
line = 2
2nd textline

textnumber
language
line = 3
3rd textline
.....................................

a.s.o.

I suggest to avoid using external applications without application logic !

Regards

mark_h 19th December 2016 14:53

As bernd suggests there is not a table that handles that - as far as I know it is an internal functional from baan. As it writes the text it just assigns the next consecutive number for the next line of text.


All times are GMT +2. The time now is 12:53.


vB.Sponsors
©2001-2017 - Baanboard.com - Baanforums.com