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:
ADO XML
Miscellaneous
Thread ID:
00521221
Message ID:
00521221
Views:
47
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,
- Erik Niese-Petersen

Crazy Dane in USA.
Next
Reply
Map
View

Click here to load this message in the networking platform