What does the XML record mean?

Post Reply
User avatar
dutch
Posts: 1570
Joined: Fri Oct 07, 2005 5:56 pm
Location: Thailand
Been thanked: 1 time

What does the XML record mean?

Post by dutch »

Dear All,

I would like to know XML record and how to write it.

Best regards,
Dutch
User avatar
Enrico Maria Giordano
Posts: 8777
Joined: Thu Oct 06, 2005 8:17 pm
Location: Roma - Italia
Has thanked: 1 time
Been thanked: 8 times
Contact:

Re: What does the XML record mean?

Post by Enrico Maria Giordano »

This is an easy way:

Code: Select all | Expand

#define adOpenForwardOnly 0#define adOpenKeyset      1#define adOpenDynamic     2#define adOpenStatic      3#define adLockReadOnly        1#define adLockPessimistic     2#define adLockOptimistic      3#define adLockBatchOptimistic 4#define adPersistXML 1FUNCTION MAIN()    LOCAL oRs := CREATEOBJECT( "ADODB.Recordset" )    FERASE( "TEST.XML" )    oRs:Open( "SELECT * FROM Test", "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:\xharbour; Extended Properties=DBASE III", adOpenForwardOnly, adLockReadOnly )    oRs:Save( "TEST.XML", adPersistXML )    oRs:Close()    RETURN NIL


EMG
User avatar
James Bott
Posts: 4840
Joined: Fri Nov 18, 2005 4:52 pm
Location: San Diego, California, USA
Contact:

Post by James Bott »

Enrico,

Is this reading a Jet database or a DBF?

Is this for xHarbour only or will it run under Harbour also?

James
User avatar
James Bott
Posts: 4840
Joined: Fri Nov 18, 2005 4:52 pm
Location: San Diego, California, USA
Contact:

Post by James Bott »

Dutch,

There is a DBF to XML conversion program written in Clipper on my website (see button below).

James
User avatar
Enrico Maria Giordano
Posts: 8777
Joined: Thu Oct 06, 2005 8:17 pm
Location: Roma - Italia
Has thanked: 1 time
Been thanked: 8 times
Contact:

Post by Enrico Maria Giordano »

James Bott wrote:Enrico,

Is this reading a Jet database or a DBF?


A DBF.

James Bott wrote:Is this for xHarbour only or will it run under Harbour also?


Also for Harbour but you will need to link hbole.lib and use TOleAuto():New() instead of CREATEOBJECT().

EMG
User avatar
dutch
Posts: 1570
Joined: Fri Oct 07, 2005 5:56 pm
Location: Thailand
Been thanked: 1 time

Thanks a lot

Post by dutch »

Dear Enrico & James,

Thanks a lot and I will try it.

Best regards,
Dutch
Post Reply