>I was playing around with XMLUPDATEGRAM():
>
>>SELECT cust_id, price, isnew;
> FROM Customers;
> INTO CURSOR New_Customers READWRITE
>
>CURSORSETPROP("Buffering", 5, "Customers")
>
>REPLACE Price WITH (Price * 1.083)
>
>cXMLUpdg = XMLUPDATEGRAM("Customers")
>? cXMLUpdg
>>
>which produced:
>
>><?xml version = "1.0" encoding="Windows-1252" standalone="yes"?>
><root xmlns:updg="urn:schemas-microsoft-com:xml-updategram">
> <updg:sync/>
></root>
>
>
>I don't see any data changes.Try the following:
OPEN DATABASE (_samples + "data\testdata")
Use testdata!customer
CURSORSETPROP("Buffering",5,ALIAS())
Insert into customer (cust_id,Company) values ("ZXZX","ZXZX & Co")
STRTOFILE(XMLUPDATEGRAM("customer"), "c:\temp\custupdgram.xml")
DECLARE INTEGER ShellExecute IN SHELL32.DLL ;
INTEGER nWinHandle, STRING cOperation, STRING cFileName,;
STRING cParameters, STRING cDirectory, LONG nShowWindow
? ShellExecute(0,"Open","custupdgram.xml","","c:\temp\",0)
