FiveTech Software tech support forums

Thanks for your suggestion and interest, I'm thinking on it...

Exact!!!!

You anticipate correctly my next question , I heard that ado with dbfs doesn´t work very well, I don´t know if that is correct.

My personal advice is to use ADO straight away to make the applications robust, fast and to take advantage of all features of ADO directly. Using RDD may seem to be easier way of migration, but better invest time on using ADO classes directly. It is worth the effort. This is only my personal opinion...

Yes I had success with smaller tables, I will be making some tests too and share results. It is okay if you are testing the functions for academic interest. But if you have an immediate professional need to import large tables from MySql to DBF or other formats, ADO may not be the way. Mostly these...

Yes I had success with smaller tables, I will be making some tests too and share results. It is okay if you are testing the functions for academic interest. But if you have an immediate professional need to import large tables from MySql to DBF or other formats, ADO may not be the way. Mostly these...

Yes I did'nt have problems with smaller tables, I will study adofuncs.prg and make other tests

Thanks a lot for your answer Mr. Rao.

1)Is there a limit of rows for a recordset using this functions or a limit to export to dbf files, because I tried to export 700.000 records from a mysql table to a dbf file .and. it returns this error There is no such limit in the documentation. I can not answer unless I test myself. I'll test thi...

Mr. Rao, It is interesting the study of FWH ADO functions, I start to study them because of this post, and I'd like to make you some questions. 1)Is there a limit of rows for a recordset using this functions or a limit to export to dbf files, because I tried to export 700.000 records from a mysql ta...

If we want to export from TDbOdbcDirect, this loop can be tried   if ( oExcel := ExcelObj() ) == nil      MsgAlert( "Excel Not Installed" )      return nil   endif  ...

Fasted way to export to excel #include "fivewin.ch"function Main()   local oCn, oRs   oCn   := FW_OpenAdoConnection( "c:\fwh\samples\xbrtest.mdb" ) // MS Access// oCn   := FW_OpenAdoConnection( "c:\fwh\samples\" ) // DBase I...

Armando, gracias

Amigos del foro: un pequeño aporte para las personas que utilizan la clase TdboDBCDirect por una necesidad puntual, he incorporado un nuevo metodo a esta clase, lo cual me permite llevar una consulta SQL en forma directa a excel, sin pasar por una tabla DBF temporal, ...

... characters in alias: TEMP-1608431171 Stack Calls =========== Called from: => DBUSEAREA( 0 ) Called from: .\source\classes\TDBODBCD.PRG => TDBODBCDIRECT:OPEN( 312 ) Called from: utile1.prg => UTILE1V1( 93 ) Called from: utile1.prg => UTILE1( 65 ) Called from: saplnk.prg => (b)BUILDMENU( ...

Ese no es el problema,

Funciona en un dialogo y/o un entorno sdi.

El metodo open es para la clase tdbodbcdirect, y yo estoy usando tdbodbc.

el metodo open si la memoria no me falla mete el resultado del query en una tabla dbf/cdx lo que la hace sumamente lenta con tablas grandes.

Saludos.

... ODBC 5.1 Driver};Server=localhost;Database=myDataBase; User=myUsername;Password=myPassword;Option=3;" * Enhancement: Class TDbOdbc and TDbOdbcDirect are made compatible with XBrowse. These objects can be browsed like any other object like TDataBase, etc. * New: Class TMeterEx, similar ...

... PRIMARY KEY" },; { "phone", "C", 15, 0,"" },; { "age", "C", 3, 0,"" } } ) oodbca:=TdbOdbcDirect():new("SELECT * FROM TEST",oodbc) oodbca:AddNew() oodbca:fieldput(1,"tester 123") oodbca:Update() oodbc:end() return ...