>>Thank you. I may have to do a big project of converting the database container to an XML file. Even though my customers (most of them) are using SQL DB, the SFQUERY relies on the database container to load the information of all fields in the database (for read only). And sometimes a customer would get the message "cannot read such-and-such file" (dbf). I started a thread on this error not so long ago. So, if I convert the VFP database container to an XML, then I would need to hack the SFQUERY to call the XML instead of the VFP database container. And in this case, the read of DBF would be completely eliminated. This is a rather big project; so I will leave it for a "slow" period.
>
>Test first. I had dismal experience with big xml files, the speed of parsing is falling at least squarely with size, to a point when it just can't be done. Now as with any other speed/size issue, YMMV; I'm just reporting that I've met issues with big xml files.
Thank you for the warning.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
