It doesn't. That solution had a problem with the length of the file name. Thanks for trying though.
For me it appear the periods in the XML was causing the macro expansion to halt processing, then of course reporting that it couldn't find the closing bracket on the method call. Arg.
I got around the problem by passing the command and the XML string seperately, then macroing expanding the command, but referencing a variable containing the XML.
>Does this help?
>
Re: XMLTOCURSOR parser error Thread #
657038 Message #
657451>
>>I have a series of VFP commands store in the memo fields of a table. Some of these commands are method calls with XML parameters. To execute these commands, I am using macro expansion. If a command contains an XML parameter it fails with the error "Function name is missing )." I think this is because the XML contains periods which signal the end of the macro processing. Is this true, and what can be done about it.
>>
>>String that I am trying to execute is below. As you can see, there are all kinds of periods.
>>
>>
>>oRep.Device(<?xml version = "1.0" encoding="Windows-1252" standalone="yes"?>
>><VFPData xml:space="preserve">
>> <xsd:schema id="VFPData" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
>> <xsd:element name="VFPData" msdata:IsDataSet="true">
>> <xsd:complexType>
>> <xsd:choice maxOccurs="unbounded">
>> <xsd:element name="parms" minOccurs="0" maxOccurs="unbounded">
>> <xsd:complexType>
>> <xsd:sequence>
>> <xsd:element name="deptid">
>> <xsd:simpleType>
>> <xsd:restriction base="xsd:decimal">
>> <xsd:totalDigits value="7"></xsd:totalDigits>
>> <xsd:fractionDigits value="0"></xsd:fractionDigits>
>> </xsd:restriction>
>> </xsd:simpleType>
>> </xsd:element>
>> <xsd:element name="deptname">
>> <xsd:simpleType>
>> <xsd:restriction base="xsd:string">
>> <xsd:maxLength value="30"></xsd:maxLength>
>> </xsd:restriction>
>> </xsd:simpleType>
>> </xsd:element>
>> <xsd:element name="start" type="xsd:date"></xsd:element>
>> <xsd:element name="end" type="xsd:date"></xsd:element>
>> <xsd:element name="modelid">
>> <xsd:simpleType>
>> <xsd:restriction base="xsd:decimal">
>> <xsd:totalDigits value="7"></xsd:totalDigits>
>> <xsd:fractionDigits value="0"></xsd:fractionDigits>
>> </xsd:restriction>
>> </xsd:simpleType>
>> </xsd:element>
>> <xsd:element name="devtypeid">
>> <xsd:simpleType>
>> <xsd:restriction base="xsd:decimal">
>> <xsd:totalDigits value="7"></xsd:totalDigits>
>> <xsd:fractionDigits value="0"></xsd:fractionDigits>
>> </xsd:restriction>
>> </xsd:simpleType>
>> </xsd:element>
>> <xsd:element name="makerid">
>> <xsd:simpleType>
>> <xsd:restriction base="xsd:decimal">
>> <xsd:totalDigits value="7"></xsd:totalDigits>
>> <xsd:fractionDigits value="0"></xsd:fractionDigits>
>> </xsd:restriction>
>> </xsd:simpleType>
>> </xsd:element>
>> <xsd:element name="staffid">
>> <xsd:simpleType>
>> <xsd:restriction base="xsd:decimal">
>> <xsd:totalDigits value="7"></xsd:totalDigits>
>> <xsd:fractionDigits value="0"></xsd:fractionDigits>
>> </xsd:restriction>
>> </xsd:simpleType>
>> </xsd:element>
>> <xsd:element name="teamid">
>> <xsd:simpleType>
>> <xsd:restriction base="xsd:decimal">
>> <xsd:totalDigits value="7"></xsd:totalDigits>
>> <xsd:fractionDigits value="0"></xsd:fractionDigits>
>> </xsd:restriction>
>> </xsd:simpleType>
>> </xsd:element>
>> <xsd:element name="serviceid">
>> <xsd:simpleType>
>> <xsd:restriction base="xsd:decimal">
>> <xsd:totalDigits value="7"></xsd:totalDigits>
>> <xsd:fractionDigits value="0"></xsd:fractionDigits>
>> </xsd:restriction>
>> </xsd:simpleType>
>> </xsd:element>
>> <xsd:element name="group1">
>> <xsd:simpleType>
>> <xsd:restriction base="xsd:decimal">
>> <xsd:totalDigits value="7"></xsd:totalDigits>
>> <xsd:fractionDigits value="0"></xsd:fractionDigits>
>> </xsd:restriction>
>> </xsd:simpleType>
>> </xsd:element>
>> <xsd:element name="group2">
>> <xsd:simpleType>
>> <xsd:restriction base="xsd:decimal">
>> <xsd:totalDigits value="7"></xsd:totalDigits>
>> <xsd:fractionDigits value="0"></xsd:fractionDigits>
>> </xsd:restriction>
>> </xsd:simpleType>
>> </xsd:element>
>> <xsd:element name="group3">
>> <xsd:simpleType>
>> <xsd:restriction base="xsd:decimal">
>> <xsd:totalDigits value="7"></xsd:totalDigits>
>> <xsd:fractionDigits value="0"></xsd:fractionDigits>
>> </xsd:restriction>
>> </xsd:simpleType>
>> </xsd:element>
>> <xsd:element name="labourrate">
>> <xsd:simpleType>
>> <xsd:restriction base="xsd:decimal">
>> <xsd:totalDigits value="5"></xsd:totalDigits>
>> <xsd:fractionDigits value="2"></xsd:fractionDigits>
>> </xsd:restriction>
>> </xsd:simpleType>
>> </xsd:element>
>> </xsd:sequence>
>> </xsd:complexType>
>> </xsd:element>
>> </xsd:choice>
>> <xsd:anyAttribute namespace="http://www.w3.org/XML/1998/namespace" processContents="lax"></xsd:anyAttribute>
>> </xsd:complexType>
>> </xsd:element>
>> </xsd:schema>
>> <parms>
>> <deptid>41</deptid>
>> <deptname>Hemodialysis </deptname>
>> <start>1980-01-01</start>
>> <end>2003-01-01</end>
>> <modelid>0</modelid>
>> <devtypeid>0</devtypeid>
>> <makerid>0</makerid>
>> <staffid>0</staffid>
>> <teamid>0</teamid>
>> <serviceid>0</serviceid>
>> <group1>-1</group1>
>> <group2>-1</group2>
>> <group3>-1</group3>
>> <labourrate>28.00</labourrate>
>> </parms>
>></VFPData>
>>)
>>
