Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ADO XML
Message
General information
Forum:
Visual FoxPro
Category:
West Wind Web Connection
Title:
Miscellaneous
Thread ID:
00521221
Message ID:
00521471
Views:
19
Open the file in IE to see if you get the expected result or if you get an error message too. SP5 required MDAC 2.5 (or was it 2.6?) so it's not the ADO version.

Of course the saved file needs to be ADO XML saved through .Save lcFile, 1 (adPersistXML), it sure looks like it.

>Sitting and playing around with the free class wwXML.vcx from www.west-wind.com
>
> The idea is to create some ADO XML files which needs to be uploaded to a web site and then have a ASP script to read these into recordsets and do some processing.
>
> Well. I wanted to test the created XML files, so I did following
>
rs = createobject("ADODB.Recordset")
>rs.open(lcFile)   && lcFile is ofcoz a string with file name and path
>
>This works and it creates a recordset find and got the correct record count. Well. Now I wanted to print out some values
>
? rs.fields(9).value
>And I get result: 4.759980546957460E+19
>
>What the? I look in XML file: Data line for first record
>
<z:row tpakey='1234567890  ' erkey='301' data_type='125' eekey='13360' op_key='1516' plan_key='143' clm_key='48942' clm_beg='2000/01/15' clm_end='2000/01/15' clm_amt='85.00' clm_unpaid='0.00' clm_ptod='85.00' clm_remark='Dentist                                      ' />
>
>
>It should had been 85.00!
>
>I try field value 10, and get another wild E+xx number (For a zero value!!). And on field value 11 I get following error
>OLE IDispatch exception code 0 from Microsoft Cursor Engine: Multiple-step operation generated errors. Check each status value...
>
>
>Is ADO screwing up in VFP? (using VFP6 SP5 on a Win98 machine)
>
>Going to try to load the XML file in through ASP and see how it reacts when I get a chance.
>
>TIA,
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform