Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Getting XML from SQL Server
Message
From
24/09/2003 07:58:36
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
23/09/2003 21:15:36
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00831714
Message ID:
00831783
Views:
18
>Hi Folks,
>
>I have written a SQL server SP that returns XML. How do I get this XML into a file from VFP.
>
>I am of course calling the SP and it is returning XML in memo fields. I tried to scan through all the records and just append the contents of each record togther.
>
>However, I am not getting the correct XML. it looks like it is being truncated of something. I have SET MEMOWIDTH to 8192, it was better but still did work.
>
>Any suggestions would be appreciated.
>
>Thanks,
>BOb

"returning XML in memo fields" ? A stored procedure would return a single row with a single field. Am I missing something here ?
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform