>>I seem to always get truncated lines when I try a select for XML statement with VFP6. I noticed that it works just fine with VFP7 though. It is not really time to be putting out production code in VFP7 yet, so I was wondering if anyone had found a way to get it to work with VFP6.
>
>How are you submitting the request, and how are you getting the results?
lnSQLH = SQLC('SQL DSN','uid','pwd')
=SQLE(lnSQLH,'SELECT * from Northwind.dbo.customers for XML AUTO,ELEMENTS','curResult')
* I have also tried raw and without elements.
* The curResults table comes back populated with many columns, but the columns don't seem to be long enough. There is text missing from the right of each column.
* When I do the same thing in VFP7 beta, I still get many rows, but they are in memos and nothing is missing.
Bill Mittenzwey