Message
From
26/09/2006 04:48:53
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01157163
Message ID:
01157177
Views:
32
Why not simply use cursortoxml?
SELECT cursorfinal
CursorToXML('cursorfinal','yourxmlfile.xml',1,512)
>Hello tore,
>
>
>SELECT  PADL( ALLTRIM( Tempx.cnosecretariat) ,7 , "0" ) AS 'cnosecretariat',;
>  TRANSFORM( Tempx.iemployeid , "@L 9999999" ) AS 'iemployeid',;
>  Tempx.ddate,;
>  Tempx.iplanpauseid,;
>  SurSalaire,;
>  PADL( TRANSFORM( INT( SUM( totheure ) * 100 )), 4  , "0" ) AS 'TotHo' ,;
>  MAX( Planpause.cnom ) AS 'cnomPlanpause',;
>  MAX( PADL( Planpause.cnomsecsocial , 4 , "0" ) ) AS 'cnomsecsocial',;
>  SPACE(4) AS cSdCode ,;
>  MAX( IIF( ISNULL( D.djour ) , .F. , .T. )) AS 'jf',;
>  MAX( Planpause.lnuit ) AS 'lnuit',;
>  MAX( 'K' ) AS 'cType',;
>  PADL( ALLTRIM( ls_numdossier ) ,7 , "0" ) AS 'cSdNummer';
>  FROM Tempx ;
>  INNER JOIN Planpause	ON  Tempx.iplanpauseid = Planpause.iid ;
>  INNER JOIN Securit ON  Securit.itelephoneid = Tempx.itelephoneid ;
>  LEFT JOIN DatesFiltred D ON D.djour = Tempx.ddate ;
>  GROUP BY 1,2,3,4,5 READWRITE INTO CURSOR CursorFinal
>
>SELECT cursorfinal
>
>*-- Transforme éventuellement un code de centralisation
>*-- en fonction d'un sursalaire. Ex : 0010 devient 0011 le samedi.
>UPDATE cursorfinal SET cSdCode = THIS.cSdCodeFind()
>
>SET SAFETY OFF
>
>clocToExport = "c:\"
>cNameToExport = "ExportSd.txt"
>THIS.cNameToExport = clocToExport  + cNameToExport
>*-- 08/2006 Le nom du fichier est à modifier ?
>COPY TO ( THIS.cNameToExport )  TYPE SDF FIELDS ;
>  cSdNummer,;
>  cnosecretariat ,;
>  cType,;
>  ddate,;
>  cSdCode,;
>  TotHo
>
>
>
>This file is on http://www.Amline.be/Ng/ExportSd.txt
>
>
>>>Hi all,
>>>
>>>i want to transform a txt file to xlm file.
>>>is ' t possible ?
>>>I search a sample...( with xlmadapter if possible ...)
>>>
>>>Thankin advance for the answer...
>>>
>>>bernhart
>>
>>What is the contents of the txt like, is it plain text or some sort of tables?
Previous
Next
Reply
Map
View