Rafael Copquin wrote on 2015-03-04:
> Scenario:
>
> Windows 7 Professional with SQL Server 2008 Express R2. Houses a VFP9
> app using SQL Server as back end. The machine is _not_ a dedicated
server.
>
> Two Windows 7 home basic, connecting to the SQL Server via ODBC.
>
> The app works perfectly from the W7 Prof machine. However, when trying
> to _save_ from any of the Home Basic boxes I get this error:
>
> Error number: 2110
>
> Error message: XML analysis error: the value,type or number of arguments
> is not valid for the function.
> "original" XML node = <original>-1.005,00</original>
> Error line: _________________________________________________________
> create cursor curapagar from array
> _XMLFieldsArray_EDA1D57E_139B_4889_8432_EEBFCBBCA07A_
>
> The actual lines of code are:
>
> ** called form init event
>
> lparameters tcXML
>
> Local oXML
>
> oXML=CreateObject('XmlAdapter')
> oXML.LoadXML(tcXML)
>
> oXML.Tables.Item(1).ToCursor() && contains curApagar cursor
>
> I guess this has to do with the fact that I am passing a cursor from a
> calling form to a called form as XML
>
> ** calling form XML creation method
> local oXML,cXML oXML = CreateObject("XMLAdapter")
> oXML.addtableschema('curApagar') oXML.ToXML("cXML")
> do form form2 with cXML
>
> Shoud I install something special in the Home Basic machines?
>
> A MDAC version perhaps?
>
> BTW, the app exe resides in each PC and is absolutely the same in all of
> them.
>
> Rafael Copquin
>
Rafael,
The only suspect I see right off is the Regional settings may be different
across the machines.
What line has the actual error? Is it happening on the same machine that the
XML is being created?
Tracy Pearson
PowerChurch Software
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/[email protected]
** 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.
