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)
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,
- Erik Niese-Petersen
Crazy Dane in USA.