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 .
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 .