topic-40032

Posts: 883

Joined: Tue Oct 11, 2005 11:57 AM

MARIADB Export Rowset
Posted: Tue Feb 23, 2021 11:10 PM

Hi fivewinners

Is there a metod in Mariadb to export a row set to a txt file.
Just like Tdolphin with...

  oQry:=cSvr:Query(&quot;select * from datos&quot;)
  oExp:=oQry:Export( EXP_TEXT, &quot;C:\XXXXX\EXPORT&quot; )
  oExp:Start()
  oExp:Close()

or something like that.

Thanks in advance

;-) Ji,ji,ji... buena la cosa... "all you need is code"

http://www.xdata.cl - Desarrollo Inteligente
----------
Asus TUF F15, 32GB Ram, 2 * 1 TB NVME M.2, GTX 1650

nageswaragunupudi

Posts: 10733

Joined: Sun Nov 19, 2006 05:22 AM

Re: MARIADB Export Rowset
Posted: Wed Feb 24, 2021 12:00 PM

Please try

Code (fw): Select all Collapse

cText := oCn:SqlToText( cSql )
MEMOWRIT( cFile, cText )

Regards

G. N. Rao.

Hyderabad, India

Adolfo

Posts: 883

Joined: Tue Oct 11, 2005 11:57 AM

Re: MARIADB Export Rowset
Posted: Thu Feb 25, 2021 11:47 AM

Thanks..
Works great...

;-) Ji,ji,ji... buena la cosa... "all you need is code"

http://www.xdata.cl - Desarrollo Inteligente
----------
Asus TUF F15, 32GB Ram, 2 * 1 TB NVME M.2, GTX 1650

MOISES

Posts: 838

Joined: Wed Aug 22, 2007 10:09 AM

Re: MARIADB Export Rowset
Posted: Thu Feb 25, 2021 06:03 PM

Mr. Rao,

Can we please have this SqlToText for ADO?

Thank you

Saludos / Regards,

FWH 20.04, Harbour 3.2.0 dev (r1909261630) y BCC 7.40

nageswaragunupudi

Posts: 10733

Joined: Sun Nov 19, 2006 05:22 AM

Re: MARIADB Export Rowset
Posted: Thu Feb 25, 2021 10:57 PM

Please try

Code (fw): Select all Collapse

cText := ""
AEval( RsGetRows( oRs ), { |a| cText += ( FW_ArrayAsList( a, Chr(9) ) + CRLF ) } )
MEMOWRIT( cFile, cText )

Regards

G. N. Rao.

Hyderabad, India

MOISES

Posts: 838

Joined: Wed Aug 22, 2007 10:09 AM

Re: MARIADB Export Rowset
Posted: Fri Feb 26, 2021 01:24 AM

Yes, it works correctly, it exports the rows.

But what I would really need would be the backup() method for ADO, to save in a txt file the content of the database in SQL mode INSERT INTO CITIES( CODE, CITY ) VALUES ( "1", "Madrid") ...

Would it be possible please?

Saludos / Regards,

FWH 20.04, Harbour 3.2.0 dev (r1909261630) y BCC 7.40

MOISES

Posts: 838

Joined: Wed Aug 22, 2007 10:09 AM

Re: MARIADB Export Rowset
Posted: Sat Jul 16, 2022 08:59 AM

Hi,

Is there any progress?

Thank you. Best regards

Saludos / Regards,

FWH 20.04, Harbour 3.2.0 dev (r1909261630) y BCC 7.40

nageswaragunupudi

Posts: 10733

Joined: Sun Nov 19, 2006 05:22 AM

Re: MARIADB Export Rowset
Posted: Sat Jul 16, 2022 03:05 PM

For small and medium size tables, please try:

Code (fw): Select all Collapse

   //BACKUP
   MEMOWRIT( cBackupFile, FW_ValToExp( RsGetRows( oRs ) ) )


   // RESTORE

   //1. Create the new table with same column specs and same column order

   aData := &( MEMOREAD( cBackUpFile ) )
   for each aRow in aData
      oCn:Execute( "INSERT INTO NEWTABLE VALUES " + FW_ValToSql( aRow ) )
   next

Regards

G. N. Rao.

Hyderabad, India

MOISES

Posts: 838

Joined: Wed Aug 22, 2007 10:09 AM

Re: MARIADB Export Rowset
Posted: Thu Jul 21, 2022 08:55 AM

Thank you very much, I have replaced memwrite and memoread by hb_, which are supposed to be faster.

But there is a problem: if the order of the fields in the table is not the same, then it fails, because the INSERT does not indicate the field.

Is it possible to include the field in the INSERT? Thank you.

Saludos / Regards,

FWH 20.04, Harbour 3.2.0 dev (r1909261630) y BCC 7.40

MOISES

Posts: 838

Joined: Wed Aug 22, 2007 10:09 AM

Re: MARIADB Export Rowset
Posted: Tue Jul 26, 2022 10:09 AM

Up!

Saludos / Regards,

FWH 20.04, Harbour 3.2.0 dev (r1909261630) y BCC 7.40

MOISES

Posts: 838

Joined: Wed Aug 22, 2007 10:09 AM

Re: MARIADB Export Rowset
Posted: Wed Aug 03, 2022 10:57 AM

Up! Thnks

Saludos / Regards,

FWH 20.04, Harbour 3.2.0 dev (r1909261630) y BCC 7.40

FiveTech Support Forums

Continue the discussion