Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
XmlUpdategram and memo fields
Message
General information
Forum:
Visual FoxPro
Category:
XML, XSD
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01200939
Message ID:
01200993
Views:
18
Check help for XMLUPDATEGRAM() Function. It shows how to handle memo fields.

>I am puzzled. I am getting nice results using XMLUPDATEGRAM() with five tables in a database, except I can't get any of my memo fields to show up (they do get changed).
>
>My test table, 'MemoTable', has an index field 'ID', an identifier 'Who', an autoincrementing integer field 'Autokey', and a line of memo fields, e.g. 'Comments', 'Info', 'History'.
>
>Syntax:
>
>
>CURSORSETPROP("Keyfieldlist", "Autokey", "MemoTable")
>... updates ...
>cSomeTextVar = XMLUPDATEGRAM("MemoTable")
>
>
>This is the sort of thing I get:
>
>
><updg:before>
>	<memotable>
>		<id>1TD1CBQNJ</id>
>		<who>J Smith</who>
>		<autokey>10897</autokey>
>	</memotable>
></updg:before>
><updg:after>
>	<memotable>
>		<id>1TD1CBQNJ</id>
>		<who>J Smith</who>
>		<autokey>10897</autokey>
>	</memotable>
></updg:after>
>
>
>The fixed fields are shown - but there are no changes to them, and there is no sign of the memo fields I've changed.
>??
>
>John Burton
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform