Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
XMLUpdateGram() and memo fields
Message
From
13/08/2002 07:22:26
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
General information
Forum:
Visual FoxPro
Category:
XML, XSD
Miscellaneous
Thread ID:
00688966
Message ID:
00689038
Views:
28
>Hi Cetin,
>
>>I couldn't make it return memo fields too and it's slow. I wrote my own version instead (getnextmodified() and write tags+data).
>
>thanks for the information! But wouldn't it be a nice and easy way having a VFP function that puts all changes in an XML message in the frontend, so we can send it to a middle tier component!? With the functionality of CURSORTOXML. Encoding binary data, handling memos etc.
>
>Armin

Yes it'd be. I actually needed it in last week and tried to implement. I didn't have a memo field so I didn't bother with it. During my tests routine got very slow, I narrowed it down to XMLUpdateGram(). For around 6K records it was taking around 71 secs on my system ! I wrote a routine myself and now it runs in 1.5 secs (and I still utilized CursorToXML() modifying a bit).
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