Another way to get around the issue without relying on the schema is to append
the data to an existing pre-defined cursor, like this:
Local lcXML
lcXML = "012"
Create Cursor curTest(a N(1), b N(1), c N(1))
XMLToCursor(lcXML, "curTest", 8192)
Browse
Paul Newton
-Origin
Further, I believe that, by default, 0 and 1 are treated as Boolean.
Laurie
On 21 July 2016 at 12:01, Laurie Alvey wrote:
> When you issue the CursortoXML() use this:
>
> CursorToXML("curSource","lcXML", 1, 0, 0, "1")
>
> The final parameter creat
Many, many thanks Laurie
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Laurie Alvey
Sent: 21 July 2016 12:02
To: profoxt...@leafe.com
Subject: Re: XMLToCursor converting numeric values to logical fields
When you issue the CursortoXML() use this
When you issue the CursortoXML() use this:
CursorToXML("curSource","lcXML", 1, 0, 0, "1")
The final parameter creates an inline schema so that XMLtoCursor knows what
the column types are.
Laurie
On 21 July 2016 at 11:50, Paul Newton wrote:
> Hi all
>
&g
Hi all
I came across some unusual behaviour with XMLToCursor which the following code
clearly demonstrates:
Local lcXML
Create Cursor curSource (A N(1), B N(1), C N(1))
Insert Into curSource Values(0,1,2)
CursorToXML("curSource","lcXML")
Browse Nowait
XMLToCursor(lcXML
On Wed, Apr 27, 2011 at 4:50 PM, Paul McNett wrote:
> On 4/27/11 11:56 AM, Stephen Russell wrote:
>> Putting all that content into a grid, double it.
>
> Hmm. Dabo's dGrid is virtual, which means it only ever knows about the rows
> currently
> being displayed. So if you can see 20 rows and 10 col
Have no way of knowing, but I wonder if VFP grids aren't, behind the
scenes, the same way.
Mike
> On 4/27/11 11:56 AM, Stephen Russell wrote:
>> Putting all that content into a grid, double it.
> Hmm. Dabo's dGrid is virtual, which means it only ever knows about the rows
> currently
> being dis
On 4/27/11 11:56 AM, Stephen Russell wrote:
> Putting all that content into a grid, double it.
Hmm. Dabo's dGrid is virtual, which means it only ever knows about the rows
currently
being displayed. So if you can see 20 rows and 10 columns, you'll get the same
performance whether your dataset ha
On 4/27/2011 3:10 PM, Richard Kaye wrote:
> (In Ed's honor, I decided to bottom post this particular reply despite having
> recently seen him top post for the first time ever...)
He's slipping.
___
Post Messages to: ProFox@leafe.com
Subscription Mai
-Original Message-
On Wed, Apr 27, 2011 at 1:30 PM, Richard Kaye wrote:
> According to my text editor:
>
> The physical file on disk is 44,689,441 bytes.
> It has 4,656,096 "words".
> It has 1,772,884 lines.
> The data structure in the XML has 6 elements per record; nothing very
> complic
or:
>
> The physical file on disk is 44,689,441 bytes.
> It has 4,656,096 "words".
> It has 1,772,884 lines.
> The data structure in the XML has 6 elements per record; nothing very
> complicated.
>
> After getting my XMLTOCURSOR syntax worked out, (see the very sophis
s".
It has 1,772,884 lines.
The data structure in the XML has 6 elements per record; nothing very
complicated.
After getting my XMLTOCURSOR syntax worked out, (see the very sophisticated
benchmark code sample below; the names have been redacted to protect the
innocent...), VFP 9 SP2 took
Thanks Brian, I'll see my client today and try your suggestion.
Rafael
- Original Message -
From: Brian Abbott
To: [EMAIL PROTECTED]
Sent: Monday, November 19, 2007 6:56 AM
Subject: Re: xmltocursor blues
Rafael
You don't need a schema. Create a table with
Rafael
You don't need a schema. Create a table with the fields as you want
them then use the 8192 flag in XMLTOCURSOR. Like this:
CREATE CURSOR RCT_Rec (timex T, uid I)
TRY
nRecs = XMLToCursor(tcPayload,"RCT_Rec",8192)
CATCH TO oErr
ENDTRY
(BTW it's probably
, 2007 7:39 PM
Subject: xmltocursor blues
I am receiving data from handheld data collector machines in the form of XML
files. One of the applications in the device is to scan the shelf where the
items are, then the item barcode and finally enter the quantities found there.
I use XMLTOCURSOR
Thanks for the information. However, what about questions 1 and 2 ?
Rafael
- Original Message -
From: MB Software Solutions
To: [EMAIL PROTECTED]
Sent: Thursday, November 15, 2007 7:52 PM
Subject: Re: xmltocursor blues
Rafael Copquin wrote:
> 3) the handheld devi
Rafael Copquin wrote:
> 3) the handheld devices operate with Windows Mobile. Is it possible
> to run a VFP app in them? Thus far, I had to have them programmed in C# by
> someone else, loosing the corresponding fee income and what is worse, the
> total control over the program, since the other
I am receiving data from handheld data collector machines in the form of XML
files. One of the applications in the device is to scan the shelf where the
items are, then the item barcode and finally enter the quantities found there.
I use XMLTOCURSOR to read the data and a workable cursor is
Thank you Wayne
Rafael
- Original Message -
From: Wayne Sobers
To: [EMAIL PROTECTED]
Sent: Monday, June 11, 2007 10:52 AM
Subject: Re: xmltocursor
Depending on the XML organisation, the XML adapter class can load and
create multiple cursors from a single XML file
You may find that the functionality in VFP to read XML can't handle
very deeply nested schemas.
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/ma
I see, well I work weird hours too.
Take care
Rafael
- Original Message -
From: Bill Arnold
To: [EMAIL PROTECTED]
Sent: Saturday, June 09, 2007 9:58 AM
Subject: RE: xmltocursor
> Yes, that certainly can help. I'll read it and see what I can
> do. Than
> Yes, that certainly can help. I'll read it and see what I can
> do. Thank you again.
>
> BTW, because of the time difference I assume you are in Europe.
> Great Britain, perhaps?
I just work weird hours, in New York City :)
Bill
> Rafael
_
7:13 AM
Subject: RE: xmltocursor
Rafael, sorry I haven't done more with XML to know. As mentioned, it
turned out that I could do the limited amount of work I needed to do at
the time using VFP commands to parse and build small XML files.
I just did a little searching and came a
Rafael, sorry I haven't done more with XML to know. As mentioned, it
turned out that I could do the limited amount of work I needed to do at
the time using VFP commands to parse and build small XML files.
I just did a little searching and came across this article, which might
be what you're looki
with 'cXML'
the above is then read with XMLTOCURSOR, in myform, as follows:
**init event
lparameter tcXML
xmltocursor(tcXML,'mycursor',4)
How can I use the XMLAdapter class to read the xml file, so as not to use
the dom example you so kindly provided?
Any others can help me?
Rafael,
The MSXML parser might be what you want. Below I've pasted a prg I had
found a while back to test with (but then switched to using VFP commands
for the limited case I needed to work with).
For the current version of the parser, search the MS website for MSXML.
Bill
* This
Copquin
To: [EMAIL PROTECTED]
Sent: Saturday, June 09, 2007 4:24 AM
Subject: xmltocursor
I need to import data from a handheld device into vfp tables.
Here is an example of what I am getting:
7798121754621
001
7798121754621
I need to import data from a handheld device into vfp tables.
Here is an example of what I am getting:
7798121754621
001
7798121754621
144
7798121754621
288
0
However, with XMLTOCURSOR I get an error and
Now I'm seeing what is being the problem
1
Starr
There isn't an fname. Works that way in VFP 9 SP 1 also.
Tracy
> -Original Message-
> From: David Crooks
> Sent: Wednesday, October 18, 2006 5:00 PM
>
>
> On Wednesday, October 18, 2006 4:09 PM Tracy Pearson wrote:
>
> >I tested this code
On Wednesday, October 18, 2006 4:09 PM Tracy Pearson wrote:
>I tested this code in VFP 7, crTest has .NULL. values, crTest2 does
not,
>crTest3 has .NULL. values
Thank you for the example code! Unfortunately, I need the XML file to
have the fields that are NULL in VFP. Which I understand that t
= SYS(2015)
SELECT crTest
CURSORTOXML(0, lcFile, 3, 512)
XMLTOCURSOR(lcFile, "crTest2", 512)
ERASE FORCEEXT(lcFile, "xml")
SELECT crTest
CURSORTOXML(0, lcFile, 3, 512, 0, "1")
XMLTOCURSOR(lcFile, "crTest3", 512)
ERASE FORCEEXT(lcFile, "xml&qu
On Wednesday, October 18, 2006 10:19 AM Hal Kaplan wrote:
>IIRC, 7 was the first release to embrace XML. I remember trying to do
what you described when it
>first came out. After spending an hour with no luck, I gave up.
>I think it does not work and I don't know if 8 or 9 are any better, but
I
On Wednesday, October 18, 2006 10:25 AM Tracy Pearson wrote:
>Are you sure the file being created has XML data in it?
Yes, I just created the file with the CursorToXML and now I want to go
back to create another cursor from the XML.
David L. Crooks
___
minutes to XMLToCursor. (17k rows of 1 integer field)
Try this command:
CursorToXML("cursor", lcxmlfile, 3, 512, 0, "1")
"cursor" is the work area name you want to export to XML
lcxmlfile is the variable holding the filename
3 is for RAW format
512 is use lcxml
=> -Original Message-
=> From: [EMAIL PROTECTED]
=> [mailto:[EMAIL PROTECTED] On Behalf Of David Crooks
=> Sent: Wednesday, October 18, 2006 09:47
=> To: ProFox Email List
=> Subject: VFP7: XMLToCursor
=>
=> I am using Cursortoxml(0, lcxmlfile, 1, 512) to creat
I am using Cursortoxml(0, lcxmlfile, 1, 512) to create a XML file. Now
I want to create a cursor from that XML file and
XMLTOCURSOR(GETFILE(),'XMLCurosr') is failing with XML parse error. Any
ideas? TIA!
David L Crooks
___
Post Messages
36 matches
Mail list logo
