title: Sql XML to Delphi
body: <p>Good morning , for those who is still morning .. </p>
  
  <p>I got a project to do and i have the following : 
  I got a <code>SQL TABLE</code> with 4 columns , lets call them <code>C1,C2,C3,C4</code> ,this columns have some data that i need to Delphi and from here i need to call a C# function with this parameters ex : <code>SQL TABLE XML -&gt; DELPHI -&gt; C#function(c1,c2,c3,c4)</code></p>
  
  <p>I don't know how to parse the XML to Delphi....</p>
  
  <pre><code>SELECT * FROM ExportModelMacheta FOR XML AUTO
  </code></pre>
  
  <p>I use this but i don't know what i should do after , i have the xml in a new sql window but how i'm suppose to parse it . Should i use a <code>TXMLDOCUMENT</code> ?  but this have the parameters to get only a File Path , so how i'm suppose to give him the <code>xml</code> ? I was thinking that i should make a query in Delphi in which i would call this select and save the everything in a string , then look in that string for what i want and extract them , but is a lot of work to do and i guess there should be a better way to achieve this .
  It would be easy if i would have a file to give the path but i was told that i need to make everything from sql...</p>
  
  <p>This is the xml code that i should get in delphi in order to call my c# function</p>
  
  <pre><code>&lt;ExportModelMacheta Macheta="ufImportProduesPrioritateXContactare" NumeColoana="IdArticol" TipDeDate="string" Pozitie="1" FromatMacheta="xls" /&gt;
  &lt;ExportModelMacheta Macheta="ufImportProduesPrioritateXContactare" NumeColoana="Prioritate" TipDeDate="string" Pozitie="2" FromatMacheta="xls" /&gt;
  &lt;ExportModelMacheta Macheta="ufImportExcelCaracteristiciUtilizatorXContactare" NumeColoana="IdUtilizator" TipDeDate="string" Pozitie="1" FromatMacheta="xls" /&gt;
  &lt;ExportModelMacheta Macheta="ufImportExcelCaracteristiciUtilizatorXContactare" NumeColoana="IdLocatie" TipDeDate="string" Pozitie="2" FromatMacheta="xls" /&gt;
  &lt;ExportModelMacheta Macheta="ufImportExcelCaracteristiciUtilizatorXContactare" NumeColoana="TipUtilizator" TipDeDate="string" Pozitie="3" FromatMacheta="xls" /&gt;
  </code></pre>