General information
Category:
Coding, syntax & commands
Environment versions
Network:
Windows 2008 Server
Hello Gregory
Thanks for your reply, but you know i am new to use this kind of code to poduce XML.
the fields linediscount and linetax are alias for the same table FI (lines of invoice)
Also, i need to use SET RELATION to join the 3 cursors to create parent, chield 1 and chield 2. The primary key for the table header FT is ftstamp, that is also save on each line for the same invoice.
My actual code is:
Select ft.ftstamp,fdata, fno,no, nome, morada,local,codpost from ft order by ft.fno into cursor Documento where ft.fno = 121005551
Select fi.fistamp,fi.ftstamp, fno,ref,design,qtt, epv,etiliquido,usr4 AS 'Codpautal',codigo from fi order by fi.fno into cursor Linhas where fi.fno = 121005551
index on ftstamp tag ftstamp
Select fi.fistamp ,fi.ftstamp, fi.desconto from fi order by fi.fno into cursor LinhasDesconto where fi.fno = 121005551
index on fistamp tag fistamp
brow
SELECT Documento
SET RELATION TO ftstamp INTO Linhas ADDITIVE
SELECT Linhas
SET RELATION TO fistamp INTO linhasDesconto ADDITIVE
what i need to do, for each cursor is to passed for my XML only some fields, for example :
for DOCUMENT fields: fdata,fno,no, nome,morada local codpost
for Linhas fields: ref, design, qtt, epv etiliquidoCodpautal, codigo
for LinhasDesconto fields : desconto
I dont know how can do that, because all the fields for each cursor appear on my XML file.
I think that is because i use fi.ftstamp and fi.fistamp on SET TELATION to create come kind of join.
Please can you help me about this question.
Many thanks again Gregory
Best regards
Luis Santos
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only