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
37%
Installation Wizard into new VRC
39%
Manual into existing VRC
3%
Manual into new VRC
21%
Total votes: 38

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #16  
Old 18th January 2006, 14:51
en@frrom en@frrom is offline
Guru
 
Join Date: Aug 2003
Location: Belgium
Posts: 1,219
en@frrom will become famous soon enough
Baan: B50B - DB: Oracle 8.0 - OS: Win2k AS
Joedi, terrific!! Works perfectly! Thanks a lot!
Reply With Quote
  #17  
Old 9th May 2017, 09:11
patelhemansh990's Avatar
patelhemansh990 patelhemansh990 is offline
Newbie
 
Join Date: Oct 2013
Location: Surat
Posts: 2
patelhemansh990 is on a distinguished road
Baan: ERP LN FP7 and FP9 - DB: SQL - OS: Windows 7
Solution

We can also use TEXT function of Excel using 3GL program. Here is the code...

In Excel :
=======
=TEXT(1234,"0000000")

In LN :
=======
aloc = 31
chr$(061) & "text" & chr$(040) & str$(aloc) & chr$(044) & chr$(034) & "000" & chr$(034) & chr$(041) & " " &

Try this it will definitely work.
Reply With Quote
  #18  
Old 9th May 2017, 11:06
bhushanchanda's Avatar
bhushanchanda bhushanchanda is offline
Guru
 
Join Date: Sep 2012
Location: India
Posts: 2,322
bhushanchanda has a spectacular aura aboutbhushanchanda has a spectacular aura aboutbhushanchanda has a spectacular aura about
Baan: LN FP 1-9, 10.4, a little bit of Baan IV - DB: SQL Server 2008, Oracle - OS: Windows Server 2008 R2, Unix
Just this works fine as well -

Code:
test.f = "=" & chr$(34) & field.f & chr$(34)

You can write the variable to your CSV. That's it. Excel will handle the rest.
__________________
Regards,

Bhushan

Unless you try to do something beyond what you have already mastered, you will never grow!
Reply With Quote
Sponsored Links
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


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


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