Andy, Looks fine to me. Just exactly what were you expecting? Records two and three get updated and are shown to be so in the XML.
Dave Crozier -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Andy Davies Sent: 01 March 2007 14:31 To: [email protected] Subject: Re: Updating a table for another table looking at this I wondered about xmlupdategram() - which I hadn't used so I had a play - I didn't get quite the results I expected - try this cose and see if the browse is what you expect: drop table xgramtst CREATE TABLE xgramtst(key I, txt c(25)) INSERT INTO xgramtst values(1,'one') INSERT INTO xgramtst values(2,'two') INSERT INTO xgramtst values(3,'tree') SET MULTILOCKS ON CURSORSETPROP("Buffering",5) CURSORSETPROP("keyfieldlist",'key') UPDATE xgramtst SET txt='three' WHERE key = 3 UPDATE xgramtst SET txt='Two' WHERE key = 2 ?XMLUPDATEGRAM() =TABLEREVERT() BROWSE Andrew Davies MBCS CITP - AndyD 8-)# ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. Please contact [EMAIL PROTECTED] with any queries. ********************************************************************** [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
