NetTalk Central

Author Topic: Xfiles hard to get right value from dictionary  (Read 1931 times)

joep

  • Newbie
  • *
  • Posts: 48
    • View Profile
    • Email
Xfiles hard to get right value from dictionary
« on: May 18, 2018, 05:36:36 AM »
Hi There,

I'm using Xfiles to make me a table summary of the dictionary.
To do so I make an export of the dictionary.
This is a piece of that dictionary output.

   <Table Guid="{07975131-522f-43f1-992f-48d3ae016a18}" Ident="9" Name="Alg201" Description="Beheerders" Prefix="Alg201" Driver="MSSQL" Owner="!Glo:ConnectString" Path="!GFN:Alg201" Thread="true" Bindable="true">
      <Audit CreateUser="Administrator" CreateDate="25 JUN 2012" CreateTime="12:01:56PM" CreateVersionNumber="1" ModifiedUser="Administrator" ModifiedDate="16 MAY 2018" ModifiedTime=" 1:14:19PM" ModifiedVersionNumber="1"/>
      <Field Guid="{f352d24a-ecb6-4e3d-af9e-bb2b8f054f3c}" Ident="98" Name="BehCode" Description="Code beheerder" DataType="LONG" Size="4" ScreenPicture="@N6_" ScreenPrompt="Code:" ReportHeading="Code" Message="Code beheerder" ReportControl=" STRING(@N6_),USE(Alg201:BehCode)">
         <WindowControl>
            <Line Text=" PROMPT(&apos;Code:&apos;),USE(?Alg201:BehCode:Prompt)"/>
            <Line Text=" ENTRY(@N6_),USE(Alg201:BehCode),MSG(&apos;Code beheerder&apos;),REQ"/>
         </WindowControl>
         <Audit CreateUser="Administrator" CreateDate="25 JUN 2012" CreateTime="12:01:56PM" CreateVersionNumber="1" ModifiedUser="Administrator" ModifiedDate="18 JUN 2015" ModifiedTime=" 4:46:11PM" ModifiedVersionNumber="1"/>
         <Validity Check="NONZERO"/>
      </Field>
      <Field Guid="{35ae3c1d-26d4-4e71-bc29-23109131b07d}" Ident="99" Name="Naam" Description="Naam beheerder" DataType="CSTRING" Size="41" ScreenPicture="@s40" ScreenPrompt="Naam  beheerder:" ReportHeading="Beheerder" Message="Naam beheerder" ReportControl=" STRING(@s40),USE(Alg201:Naam)">
         <WindowControl>
            <Line Text=" PROMPT(&apos;Naam  beheerder:&apos;),USE(?Alg201:Naam:Prompt)"/>
            <Line Text=" ENTRY(@s40),USE(Alg201:Naam),MSG(&apos;Naam beheerder&apos;),REQ"/>
         </WindowControl>
         <Audit CreateUser="Administrator" CreateDate="25 JUN 2012" CreateTime="12:01:56PM" CreateVersionNumber="1" ModifiedUser="Administrator" ModifiedVersionNumber="1"/>
         <Validity Check="NONZERO"/>
      </Field>

From this file I want ident,name,description,prefix from the first row where tag is <table Guid=.
So it loads prefix en ident from this first row because they only exists there, but name and description are used several times and I only get to see the last name and description.
This is the command :

XmlTable.load(TableDict,lFileName,'','Table')
Hope someone can help me.

Joep