>>>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.
Erik Moore
Clientelligence