davenon
16th December 2009, 18:11
A new blog entry has been added:

We were baaN Users on Unix and Oracle. We migrate to Windows and SQL server. ^Problem with files format

We create, in a report script files with code like below:
        IF code.login = "davenon" THEN
  idfac = seq.open(FICFACDV,"w")
 ELSE
  idfac = seq.open(FICFAC,"w")
        endif
 IF idfac < 1 THEN
  |*Ouverture rapport impossible
  mess("spsls4404055.1",1,FICFAC)
 endif
and write with :
  mntbrut  = sprintf$("%@9999999,99@",( -1 * transport.forfait))
  enrcpt = "VTE" & CSV
   & dat6factur & CSV & nopiece & CSV
   & tdsls045.ttyp & SLASH & nofactur & CSV
   & "708" & nucompte708.SAGE & CSV
   & "" & CSV
         & facturavoir & nofactur & " " & raisocpt & CSV
   & "" & CSV
   & "" & CSV
   & mntbrut & CSV
   & mntbrut & CSV
   & "0,00"
         retour = seq.puts(enrcpt,idcpt)
Now , we are using in Windows and SQL server environnement. The files created with this code are in format Unix and we need to convert  them in Windows Format.
How can we obtain files in windows format ?
Thanks to all. I'm sure to obtain a good respons by you 
Daniel VENON .

dhowells
18th December 2009, 21:20
use a 't' with the 'w' on your seq.open. We just had the same problem.

idfac = seq.open(FICFACDV,"wt")

sushil
19th December 2009, 16:39
post your queries / problem in Forum section not in blogs - to get solution from members.