Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
XMLAdapter
Message
From
10/09/2018 07:01:56
 
 
To
10/09/2018 05:48:43
Luis Santos
Biglevel-Soluções Informáticas, Lda
Portugal
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 10
Network:
Windows Server 2012 R2
Database:
MS SQL Server
Application:
Desktop
Miscellaneous
Thread ID:
01661917
Message ID:
01661924
Views:
58
Likes (1)
Luís

You can remove the fields between the last .AddTableSchema() and the ToXML() method calls.

In your case, that would be
LOCAL XMLChild AS XMLTable

m.XMLChild = m.oAdapter.Tables(STRCONV("TaxasIVA", 12))
m.XMLChild.Fields.Remove(STRCONV("fno", 12))

m.XMLChild = m.oAdapter.Tables(STRCONV("Linhas", 12))
m.XMLChild.Fields.Remove(STRCONV("fno", 12))
>Hello Antonio,
>
>Thanks for your reply.
>When you say:
>You may remove the unwanted columns from the Fields collection of the respective item in the Tables collection. They won't be generated by ToXML().
>
>Where exactly i remove the unwanted columns, i cannot remove them because i need them on SET RELATION.
>This is on oAdapter.AddTableSchema('LINHAS') where i can define what fields i want ?
>
>Could you give based on my code, where i must remove them ?
>
>Best regards,
>Luis
----------------------------------
António Tavares Lopes
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform