>>>>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.
>
>Why are you using the FOR XML clause at all if you just want a cursor?
>
>If you want to use the FOR XML clause from VFP to get XML back from SQL Server, you should use the ADO Command object.
I had actually expected that it would just return one big memo with the whole text of the XML in one record that I could just write out.
As I spend most of my time with VFP, ADO is not usually the first thing to pop into my mind.
Bill Mittenzwey