JavaScript Editor js editor     Web development 

Main Page

Creates a cursor specified by XMLTable with the fields described by the XMLTableВ Fields collection and loads it with data from the referenced XML document.

ToCursor is supported only for XMLTable objects in the XMLAdapterВ Tables collection.

XMLTable.ToCursor( [ lAppend [, cAlias [, nCodePage ]]] )



Specifies whether to append data or records to an existing cursor specified by the cAlias parameter. The following table lists the values for lAppend.

lAppend Description

False (.F.)

(Default) Does not add fields to an existing cursor.

True. (.T.)

Adds fields to an existing cursor.


Specifies the alias for the target cursor. The value of cAlias defaults to the XMLTableAlias property, including when cAlias is an empty string ("").

Specifies a code page. The default value is zero (0).


Applies To: XMLTable Class

If the XMLFieldВ Alias property is empty, the XMLTableВ ToCursor method disregards XMLField objects and creates a cursor that does not include any fields specified by those XMLField objects.

The nCodePage parameter must exist in the list of supported code pages. If nCodePage is zero (0) and the UseCodePage property is False (.F), the current default code page is used. For more information, see Code Pages Supported by Visual FoxPro and the UseCodePage Property.

When you use ToCursor to append data, Visual FoxPro adds an empty row if no XMLField object name matches any cursor column.

When mapping binary fields to Character data types, Visual FoxPro fills any remaining white space with 0x00 characters (CHR(0) or zeros) after decoding.

If the RespectNesting property of the XMLAdapter is True (.T.), the node must be an immediate child for the outer table's node. If the table is not nested, the node must be an immediate child for the XMLAdapter's node.

The ToCursor method fails if XMLAdapter.XMLNameIsXPath property is True (.T.) and XMLAdapter.IsDiffgram is True (.T.).

See Also

JavaScript Editor js editor     Web development