Jochen0911
New Member
Hello,
tried to create dataset, write-xml and read it again. But it doesn´t work. Perhaps, it´s a simple thing, but i don´t see it.
I have 2 TT. ttAuftrag and ttAufPos.
ttAuftrag
field lfdnr as int xml-node-type 'HIDDEN':U
field firma like v_belegkopf.firma xml-node-type 'HIDDEN':U
field kunde like v_belegkopf.kunde xml-node-type 'ATTRIBUTE':U xml-node-name 'Kundennummer':U
field web_bestellnr as char format 'x(30)':U xml-node-name 'WEB_Bestellnummer':U
field bestellreferenz as char format 'x(30)':U xml-node-name 'Bestellreferenz':U
field auftragsart like v_belegkopf.auftragsart xml-node-name 'Auftragsart':U
field lieferadresse as char xml-node-name 'Lieferadresse':U
field rechnungsadresse as char xml-node-name 'Rechnungsadresse':U
field empfaenger like v_belegkopf.empfaenger xml-node-name 'Empfänger':U
field frachtkosten as dec format 'zzz,zz9.99-':U xml-node-name 'Frachtkosten':U
field bemerkung as char format 'x(60)':U xml-node-name 'Bemerkung':U
field payment1 as char format 'x(124)':U xml-node-name 'Payment1':U
field payment2 as char format 'x(124)':U xml-node-name 'Payment2':U
field payment3 as char format 'x(124)':U xml-node-name 'Payment3':U
field payment4 as char format 'x(124)':U xml-node-name 'Payment4':U
field belegnummer like v_belegkopf.belegnummer xml-node-name 'PA_Belegnummer':U
ttAufPos
field lfdnr as int xml-node-type 'HIDDEN':U
field firma like v_belegkopf.firma xml-node-type 'HIDDEN':U
field web_bestellnr as char format 'x(30)':U xml-node-name 'WEB_Bestellnummer':U
field positionsnr as char format 'x(20)':U xml-node-name 'Positionsnummer':U
field artikel like v_belegpos.artikel xml-node-name 'Teilenummer':U
field menge like v_belegpos.menge xml-node-name 'Menge':U
field preis like v_belegpos.einzelpreis xml-node-name 'Preis':U
Dataset
define dataset {&ppDatasetName}
xml-node-name 'AUFTRAG':U
for ttAuftrag{&ippPostfix},ttAufPos{&ippPostfix}
data-relation drAuftrag
for ttAuftrag{&ippPostfix},ttAufPos{&ippPostfix}
relation-fields (web_bestellnr,web_bestellnr)
nested.
I created sample data, called fill-dataset and called write-xml. That works. Auftrag_Beispiel_20171112_15_19_38.zip
Now i wanted to read XML to get Dataset info.
lvh_ds = dataset dsauftrag:handle.
lvl_ret = lvh_ds:read-xml('file':U,lvc_datei_akt,?,?,false) no-error.
That works, but i have only the positions
for each ttauftrag:
message '1'.
end.
for each ttaufpos:
message '1'.
end.
ttauftrag is empty. No message. ttaufpos i get my positions. So, what´s going wrong?
tried to create dataset, write-xml and read it again. But it doesn´t work. Perhaps, it´s a simple thing, but i don´t see it.
I have 2 TT. ttAuftrag and ttAufPos.
ttAuftrag
field lfdnr as int xml-node-type 'HIDDEN':U
field firma like v_belegkopf.firma xml-node-type 'HIDDEN':U
field kunde like v_belegkopf.kunde xml-node-type 'ATTRIBUTE':U xml-node-name 'Kundennummer':U
field web_bestellnr as char format 'x(30)':U xml-node-name 'WEB_Bestellnummer':U
field bestellreferenz as char format 'x(30)':U xml-node-name 'Bestellreferenz':U
field auftragsart like v_belegkopf.auftragsart xml-node-name 'Auftragsart':U
field lieferadresse as char xml-node-name 'Lieferadresse':U
field rechnungsadresse as char xml-node-name 'Rechnungsadresse':U
field empfaenger like v_belegkopf.empfaenger xml-node-name 'Empfänger':U
field frachtkosten as dec format 'zzz,zz9.99-':U xml-node-name 'Frachtkosten':U
field bemerkung as char format 'x(60)':U xml-node-name 'Bemerkung':U
field payment1 as char format 'x(124)':U xml-node-name 'Payment1':U
field payment2 as char format 'x(124)':U xml-node-name 'Payment2':U
field payment3 as char format 'x(124)':U xml-node-name 'Payment3':U
field payment4 as char format 'x(124)':U xml-node-name 'Payment4':U
field belegnummer like v_belegkopf.belegnummer xml-node-name 'PA_Belegnummer':U
ttAufPos
field lfdnr as int xml-node-type 'HIDDEN':U
field firma like v_belegkopf.firma xml-node-type 'HIDDEN':U
field web_bestellnr as char format 'x(30)':U xml-node-name 'WEB_Bestellnummer':U
field positionsnr as char format 'x(20)':U xml-node-name 'Positionsnummer':U
field artikel like v_belegpos.artikel xml-node-name 'Teilenummer':U
field menge like v_belegpos.menge xml-node-name 'Menge':U
field preis like v_belegpos.einzelpreis xml-node-name 'Preis':U
Dataset
define dataset {&ppDatasetName}
xml-node-name 'AUFTRAG':U
for ttAuftrag{&ippPostfix},ttAufPos{&ippPostfix}
data-relation drAuftrag
for ttAuftrag{&ippPostfix},ttAufPos{&ippPostfix}
relation-fields (web_bestellnr,web_bestellnr)
nested.
I created sample data, called fill-dataset and called write-xml. That works. Auftrag_Beispiel_20171112_15_19_38.zip
Now i wanted to read XML to get Dataset info.
lvh_ds = dataset dsauftrag:handle.
lvl_ret = lvh_ds:read-xml('file':U,lvc_datei_akt,?,?,false) no-error.
That works, but i have only the positions
for each ttauftrag:
message '1'.
end.
for each ttaufpos:
message '1'.
end.
ttauftrag is empty. No message. ttaufpos i get my positions. So, what´s going wrong?