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 30th August 2008, 07:22
shanthi.e shanthi.e is offline
Junior Member
 
Join Date: Nov 2005
Posts: 10
shanthi.e is on a distinguished road
Baan: Baan IV - DB: MS SQL - OS: WIN NT
not able to retrieve seq.gets for a file
Baan: Baan IVc4
C/S: Both

Hi all,

In this script a table dump file from PLM 8 server is uploaded in baan tables.In debugger seq.gets gives some special characters.Can any one help me on this please.
Code:
                 file.path = "\\sankalp\pdmdoc\wbsdocps.dmp" 	
                 open.ptr = seq.open(file.path,"r")
                 if open.ptr > 0 then
		  while seq.gets(pdm.rec,1024,open.ptr) >= 0
		  if lval(pdm.rec(1;3)) = 145
			then
			insert.records()
		  else
			  continue
		  endif
		endwhile
		seq.close(open.ptr)
	else
Thanks in advance.
Attached Files
File Type: zip wbsdocps.zip (80.5 KB, 30 views)

Last edited by george7a : 1st September 2008 at 09:17. Reason: adding baan code tags
Reply With Quote
  #2  
Old 1st September 2008, 09:19
george7a's Avatar
george7a george7a is offline
Guru
 
Join Date: May 2004
Location: Nazareth
Posts: 1,490
george7a is on a distinguished road
Baan: IVc, 5.0 b, 5.0 c, LN 6.1 - DB: MS SQL, Oracle - OS: Windows 2000, 2003 & UNIX
Hi

What is the type of this variable "pdm.rec"? How is it defined?

- George
__________________
_
George Abdo
NAZDAQ - Your Documents, Your Way.
Reply With Quote
  #3  
Old 1st September 2008, 11:16
shanthi.e shanthi.e is offline
Junior Member
 
Join Date: Nov 2005
Posts: 10
shanthi.e is on a distinguished road
Baan: Baan IV - DB: MS SQL - OS: WIN NT
The variable is defined as string pdm.rec(180)
Reply With Quote
  #4  
Old 1st September 2008, 13:06
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
And what are the special charachters you are referring to?
__________________
Member of Baan Board

Play the Google game and help Baanboard get better rankings. Do your part. Click here to find how.
Reply With Quote
  #5  
Old 1st September 2008, 13:13
shanthi.e shanthi.e is offline
Junior Member
 
Join Date: Nov 2005
Posts: 10
shanthi.e is on a distinguished road
Baan: Baan IV - DB: MS SQL - OS: WIN NT
hi

I just included the seq.getc$ in the script.After every character some null characters are found.How to solve this ? Is it a additional features added in the plm 8?
Is there any solution?

Code:
while seq.gets(pdm.rec,1024,open.ptr) >= 0
		|  while seq.read(pdm.rec,1024,open.ptr) >= 0
		for i = 1 to 255
			test =  seq.getc$(open.ptr)	
		endfor		
		  if lval(pdm.rec(1;3)) = curr.comp
			then
			insert.records()
		  else

Last edited by george7a : 1st September 2008 at 13:17. Reason: adding baan code tags
Reply With Quote
  #6  
Old 1st September 2008, 13:24
shanthi.e shanthi.e is offline
Junior Member
 
Join Date: Nov 2005
Posts: 10
shanthi.e is on a distinguished road
Baan: Baan IV - DB: MS SQL - OS: WIN NT
Hi en
In the debugger mode the value of pdm.rec shows 3 characters which are not available in the keyboard.Now the pdm.rec variable is defined as string of 255 characters.
Reply With Quote
  #7  
Old 1st September 2008, 14:13
sprasad sprasad is offline
Junior Member
 
Join Date: Aug 2008
Posts: 26
sprasad is on a distinguished road
Baan: Baan Ln - DB: SQL 2000 - OS: Windows 2003 server
Hi Shanti,

The file is of type .dmp. Try using text file it should solve the problem.

Regards,
Sai Prasad.
Reply With Quote
  #8  
Old 2nd September 2008, 09:08
shanthi.e shanthi.e is offline
Junior Member
 
Join Date: Nov 2005
Posts: 10
shanthi.e is on a distinguished road
Baan: Baan IV - DB: MS SQL - OS: WIN NT
hi prasad
the problem remains same.This file is created from PLM 8 server.For plm 6 version there is no problem.Its working fine.
Reply With Quote
Sponsored Links
  #9  
Old 4th September 2008, 09:57
sprasad sprasad is offline
Junior Member
 
Join Date: Aug 2008
Posts: 26
sprasad is on a distinguished road
Baan: Baan Ln - DB: SQL 2000 - OS: Windows 2003 server
Hi Shanti,

I tried with to upload the file attached by you,I too found some unknown characters.I changed the file to text format then it was successful.

Regards,
Sai Prasad.
Attached Files
File Type: txt wbsdocps.txt (1.86 MB, 23 views)
Reply With Quote
  #10  
Old 15th September 2008, 11:19
shanthi.e shanthi.e is offline
Junior Member
 
Join Date: Nov 2005
Posts: 10
shanthi.e is on a distinguished road
Baan: Baan IV - DB: MS SQL - OS: WIN NT
hi sprasad,

I was out od station.Today i seen your mail and tested the same.Its working fine.Thanks.
Reply With Quote
  #11  
Old 15th September 2008, 11:21
shanthi.e shanthi.e is offline
Junior Member
 
Join Date: Nov 2005
Posts: 10
shanthi.e is on a distinguished road
Baan: Baan IV - DB: MS SQL - OS: WIN NT
Thumbs up

hi sprasad,

I was out of station.Today i seen your mail and tested the same.Its working fine.Thanks.
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
Programming Question mr_suleyman Tools Development 37 11th November 2016 08:14
Undocumented Functions & Variables george7a Tools Development 81 30th September 2015 11:35
bshell received SIGTERM manojsharma Tools Development 11 5th June 2008 09:22
Retrieve file from other server Mike Wiggins Tools Development 2 1st October 2007 08:40
How to print Postcript in landscape orientation heliopaixao Tools Administration & Installation 8 28th July 2006 13:39


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


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