tools123
11th February 2003, 02:56
Any good way to beat the 255 limit ?
The output is going to an ascii file.
I would like to see the output as one record in one row.
I am hoping some kind of delimiter might help if the layout spilled to line 2.
Baan 4 custom report.
Thanks.
gfasbender
11th February 2003, 03:14
Instead of sending data to a report, write it directly to a file using the seq.* functions.
tools123
12th February 2003, 04:35
Thanks .it works.
Got to figure out thepath for the file so written as default looks like it writes on to a path on the server on unix.
jaapzwaan
12th February 2003, 12:32
Indeed, the default seq.* functions write on the server. If you want to write on the client (PC) use the following functions:
seq.*.local (http://www.baanboard.com/programmers_manual_baanerp_help_functions_client_file_access_synopsis)
Regards,
Jaap Zwaan
tools123
13th February 2003, 21:26
I am getting the unresolved reference to seq.open.local.
I have checked path syntax and all the options.
Is there a possibility that these are not available on our system
we are on 4c4.
Thank you
NPRao
13th February 2003, 21:54
Refer to - seq.open.local() (http://www.baanboard.com/programmers_manual_baanerp_help_functions_client_file_access_seq_open_local)
Context - ttdllbw library function.
you have to use this statement in your program script -
#pragma used dll ottdllbw
or add the tools library ttdllbw in the libraries by the program script.
tools123
14th February 2003, 00:37
Thanks.
I included and the script compiled allright.
However, when I run the session, I get a bunch of messages
saying object 0 in process 16 not found.
evesely
14th February 2003, 15:42
How did you write the data to the file? If you look at the bottom of the description for the seq.open.local() (http://www.baanboard.com/programmers_manual_baanerp_help_functions_client_file_access_seq_open_local) function, it says that you cannot use the seq.*() functions with seq.*.local() functions. So, perhaps you need to use seq.write.local(). Just a guess -- I don't know if this would cause your problem.
tools123
14th February 2003, 18:01
I had noted it and all I have is seq.open.local,seq.write.local and
seq.close.local.
jaapzwaan
17th February 2003, 14:43
Note that the seq.*.local functions only work with BW.
Just checking....
Jaap Zwaan
tools123
20th February 2003, 21:46
will start working on it again.
ahulikavi
21st February 2003, 05:30
seq.open.local needs seq.write.local, we create outputfile on server using
seq.open, seq.puts ...
and then transfer file to client using server2client, invoke client app to open the transferred file delete tmp file created on server.
something like this ..
fp= SEQ.OPEN( "AP.DAT", "wt")
if fp < 1 then
message("ERROR OPENING FILE %d", fp)
endif
SEQ.PUTS( strLine, fp)
errorcd = server2client("AP.DAT", "D:\AP.CSV", false, false )
errorcd = app_start("excel.exe D:\AP.CSV","","","","")
seq.unlink("AP.DAT")
hope this helps
tools123
21st February 2003, 05:42
Thanks all for the inputs..
It is sheer coincidence I worked on the lines of seq.unlink and server2client just today.