Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Tools Development

User login

Frontpage Sponsor

Main

Poll
How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
18%
200 - 500 GB
28%
500 - 800 GB
3%
800 - 1200 GB
7%
1200 - 1500 GB
7%
1500 - 2000 GB
13%
> 2000 GB
24%
Total votes: 71

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 19th July 2019, 15:28
willian.ueno willian.ueno is offline
Newbie
 
Join Date: May 2016
Posts: 1
willian.ueno is on a distinguished road
Baan: FP7 - DB: oracle - OS: windows
text.write number of characters limitation

Hi,
I am try to save a tmp file with more than 10000 characters but It just saving 4080 characters, I am using the standard function text.write.

text.write("tdvvr036.tret.o", language$, "", "", "", "",
tgroup.o, editopt.o,
l.file.temp.o)

The text group is set to maximum number of columns and lines.

How can I solve this problem?

Tks.
Reply With Quote
  #2  
Old 19th July 2019, 19:29
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 7,320
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
Is the text.write returning the correct number of lines? I know sometimes I had to use seq.flush on file before I closed it. That is what popped into mind when I read this.
__________________
Mark

GO Cards!
My latest mantra - make sure you have latest stpapi patches and the latest session object. If on LN then please explore the option of using DAL2 functionality.

Shared Solutions for Baan systems provided free by Baan Board.
Play the Google game and help Baanboard get better rankings. Do your part. Click here to find how.
Reply With Quote
Sponsored Links
  #3  
Old 19th July 2019, 19:35
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 7,320
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
Please do not post duplicate threads. Pick a forum - post there and if you want it moved you can ask a moderator. Sometimes will we move them where we think best.
__________________
Mark

GO Cards!
My latest mantra - make sure you have latest stpapi patches and the latest session object. If on LN then please explore the option of using DAL2 functionality.

Shared Solutions for Baan systems provided free by Baan Board.
Play the Google game and help Baanboard get better rankings. Do your part. Click here to find how.
Reply With Quote
  #4  
Old 19th July 2019, 21:36
willian.ueno willian.ueno is offline
Newbie
 
Join Date: May 2016
Posts: 1
willian.ueno is on a distinguished road
Baan: FP7 - DB: oracle - OS: windows
Quote:
Originally Posted by mark_h View Post
Is the text.write returning the correct number of lines? I know sometimes I had to use seq.flush on file before I closed it. That is what popped into mind when I read this.
Mark, one more information, in this tmp file we are working with XML structure.

We had The same problem using seq.flush.

Tks.
Reply With Quote
  #5  
Old 22nd July 2019, 14:03
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 7,320
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
Well one of the things I did at one point was use text to buff instead of text.write. So I would put the text into a buffer and process it. Basically like this - since this was part of our conversion to oracle, I am not sure if the first time I ran into a issue was with the text truncating or note. Been a couple of years since I wrote the extract code.

Code:
	ret = text.to.buf("tiitm001.txta","2",900,buf)
	if ret > 0 then
		t.numrecs = ret
	else
		return
	endif
	for i = 1 to t.numrecs
		ret = seq.puts(buf(1,i), output.itm)
	endfor
	rc = seq.flush(output.itm)
	rc = seq.close(output.itm)
__________________
Mark

GO Cards!
My latest mantra - make sure you have latest stpapi patches and the latest session object. If on LN then please explore the option of using DAL2 functionality.

Shared Solutions for Baan systems provided free by Baan Board.
Play the Google game and help Baanboard get better rankings. Do your part. Click here to find how.
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
text.write does not return new text number ahulikavi Tools Development 10 4th September 2017 11:03
Programming Question mr_suleyman Tools Development 37 11th November 2016 08:14
Retrieve data from tdinv750 Drikus70 Operating Systems & Databases 2 9th September 2009 09:23
Audit file structure baan_user Tools Development 8 4th May 2007 14:32


All times are GMT +2. The time now is 04:28.


©2001-2018 - Baanboard.com - Baanforums.com