Baanboard.com

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

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
35%
Installation Wizard into new VRC
42%
Manual into existing VRC
3%
Manual into new VRC
19%
Total votes: 31

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 6th December 2016, 02:26
showstuff11 showstuff11 is offline
Junior Member
 
Join Date: Mar 2015
Posts: 22
showstuff11 is on a distinguished road
Baan: fp3 - DB: sql server 2008 r2 - OS: windows 7
How to add the remarks in an uploading code
Baan: ERP LN 6.1 FP3
C/S: Both

i have an uploading that requires to put a text/remarks on header and or lines
i can't figure out how to code this one since base on the table tdpur400 or tdpur401 or any table that has text/remarks ... the remarks is just numbers

any help will be appreciated

thanks
Reply With Quote
  #2  
Old 6th December 2016, 09:35
JaapJD's Avatar
JaapJD JaapJD is offline
Guru
 
Join Date: Sep 2002
Location: Netherlands
Posts: 728
JaapJD will become famous soon enoughJaapJD will become famous soon enough
Baan: BaanIV, BaanERP, ERP LN 6.1 - DB: Oracle, SQL Server - OS: Unix, Windows
What tool are you using to upload the data?
Reply With Quote
Sponsored Links
  #3  
Old 6th December 2016, 10:34
pillai.ganesh's Avatar
pillai.ganesh pillai.ganesh is offline
Senior Member
 
Join Date: Apr 2011
Location: United Arab Emirates
Posts: 105
pillai.ganesh is on a distinguished road
Baan: ERP LN 6.1 - DB: Oracle, SQL, Informix - OS: Windows
In LN every text stored in the database has a text number. A text field that is included in a database table is referenced in the table by its text number. The text itself, its key words, and so on, are stored in a separate table.

You can try these functions-
text.to.buf - This stores the text of a specified text field in a two-dimensional string array.
text.write - This adds a new text to the text manager and assigns a new text number to the text.
Reply With Quote
  #4  
Old 7th December 2016, 01:52
showstuff11 showstuff11 is offline
Junior Member
 
Join Date: Mar 2015
Posts: 22
showstuff11 is on a distinguished road
Baan: fp3 - DB: sql server 2008 r2 - OS: windows 7
Sir, i created a session for uploading via text files
Reply With Quote
  #5  
Old 7th December 2016, 01:58
showstuff11 showstuff11 is offline
Junior Member
 
Join Date: Mar 2015
Posts: 22
showstuff11 is on a distinguished road
Baan: fp3 - DB: sql server 2008 r2 - OS: windows 7
Quote:
Originally Posted by pillai.ganesh View Post
In LN every text stored in the database has a text number. A text field that is included in a database table is referenced in the table by its text number. The text itself, its key words, and so on, are stored in a separate table.

You can try these functions-
text.to.buf - This stores the text of a specified text field in a two-dimensional string array.
text.write - This adds a new text to the text manager and assigns a new text number to the text.
how will i use that? or how to use that? can you direct me to some notes or tutorials on how to use it please? or can you show me how would i code it

thanks for the reply
Reply With Quote
  #6  
Old 7th December 2016, 12:54
pillai.ganesh's Avatar
pillai.ganesh pillai.ganesh is offline
Senior Member
 
Join Date: Apr 2011
Location: United Arab Emirates
Posts: 105
pillai.ganesh is on a distinguished road
Baan: ERP LN 6.1 - DB: Oracle, SQL, Informix - OS: Windows
Code:
<declaration of variabls>
	string.scan(record.line,"%s|%s|%s",orderno,position,text)
	|* Code to read the file.
	<some code>
	|* Code to create a temp file and store the text in it
	temp.file.name = creat.tmp.file$(bse.tmp.dir$())
	temp.file.name = strip$(temp.file.name)
	open.ret1 = seq.open(temp.file.name,"w")
	seq.puts(text,open.ret1)
	seq.close(open.ret1)

	|* Code to update table with the text stored in temp file
	db.retry.point()
	select tdxxx901.*
	from tdxxx901 for update
	where tdxxx901.orno = :orderno
	and tdxxx901.pono = :position
	selectdo
	ret2  = text.write("tdxxx901.txta","2","tdxxx901.txta","","","","","",temp.file.name)
	ret2 = db.update(ttdxxx901,db.retry)  
	commit.transaction()
	endselect
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
unable to add code through QKey VishalMistry Tools Development 4 19th July 2016 12:44
Add 9 spaces before item code anandpr1989 Tools Development 3 12th August 2015 07:13
how to add computed field in a form without soucrce code ncgjiju Tools Development 7 26th August 2005 14:07
add description with a code?? jatin_sanghi Tools Development 1 31st January 2005 15:05


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


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