Hi Harold,
We bring in up to 4 megs of XML for UI controls (e.g. grids) and up to 16 megs for reports. Actually, 16 megs is the limit for a memory variable.
Trick is:
[1] Set PreserveWhiteSpace = .T. when executing the XMLAdapter LoadXML and ToXML methods.
[2] Set FormattedOutput = .F. when executing the XMLAdapter ToXML method.
[3] Make sure the client box has at least one gig of memory.
Also, you may want memo fields wrapped in CDATA to circumvent parsing errors for invalid XML characters (e.g. &,<,> etc)
>Hello
>
>I am using XMLTOCURSOR to import records...The command works fine up to about 30k records and then hangs the machine after that... Are there some practical upper limits to the number of records that can be imported via XMLTOCURSOR()???
>
>Thanks!
>Harold
- Jeff