MARIADB Export Rowset

[Adolfo]

Hi fivewinners

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

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

or something like that.

Thanks in advance

[nageswaragunupudi]

Please try

Code: Select all

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

[Adolfo]

Thanks..
Works great...

[MOISES]

Mr. Rao,

Can we please have this SqlToText for ADO?

Thank you

[nageswaragunupudi]

Please try

Code: Select all

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

[MOISES]

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?