FiveTech Software tech support forums

hi, thx for Answer This works for all datasources, viz, dbf, tdatabase, ado, fwmysql, dolphin, tmysql, postgre, arrays, etc. found out when want to use Postgre i NEED to use TPQserver / TPQquery as it is "hardcode" in Source METHOD Load( lBlank ) ...

... you are browsing in XBrowse, you can copy image from any source and paste into the cell. This works for all datasources, viz, dbf, tdatabase, ado, fwmysql, dolphin, tmysql, postgre, arrays, etc.

... you are browsing in XBrowse, you can copy image from any source and paste into the cell. This works for all datasources, viz, dbf, tdatabase, ado, fwmysql, dolphin, tmysql, postgre, arrays, etc.

... possible for use the same program code for different kinds of datasources, without changing even a single character in the source program. DBF,ADO,FWMySql,TMySql,Dolphin,PostGre, etc.

http://wiki.fivetechsoft.com/doku.php#fwmysql_support http://wiki.fivetechsoft.com/doku.php?id=fivewin_class_fwmariaconnection http://wiki.fivetechsoft.com/doku.php?id=fivewin_class_fwmariarowset http://forums.fivetechsupport.com/viewtopic.php?f=3&t=32737&start=0 http://forums.fivetechsuppor...

Muestra tu codigo para mayor claridad de lo que expones. Tambien que utilizas, si Dolphin o FWMysql/FWMariaDB Te pongo un codigo de como lo hago con dolphin oQry := oApp:oServer:Query("SELECT c.numero AS numero, cl.nombre AS nombre, "+;                  ...

nageswaragunupudi wrote:If you are using ADO for MySql, you can use FW_AdoImportFromDBF()
If you are using FWMYSQL for connecting to MySql, you can use oCn:ImportFromDBF()

Thanks

Do you have an example to use FW_AdoImportFromDBF() ?

I tried with the sample from wiki and it didn't work

If you are using ADO for MySql, you can use FW_AdoImportFromDBF()
If you are using FWMYSQL for connecting to MySql, you can use oCn:ImportFromDBF()

This is how I would do it using FWMYSQL (FWMARIADB) // purchase ordersnLastId  := oCloud:QueryResult( "select max(id) from purchaseorders" )aRows    := oLocal:Execute( "select * from purchaseorders where id > ...

... too. Anyway you are spending time for reloading the data. You spend a little more time requery totals query also and refresh the totals. With fwmysql only the modified row is refreshed. You may try \fwh\samples\maria01.prg and check the edit behavior both inline and with dialog..

... "ENUM ( 'Items', 'K.G', 'Metre', 'Litre' ) DEFAULT 'Items'" }, ;  This column allows only one of the values in the list. FWMYSQL not only supports this column type, but also uses the information to automatically build EDIT_LIST_BOX in xbrowse and datarow without any effort ...

With FWMYSQL oQry := oServer:Query( "SELECT * FROM clientes where cliente >= 10" ) oQry:SetWhere( "cliente >= 20" ) can be written as oQry := oServer:Query( "SELECT FROM clientes WHERE cliente ...

Then you can syncronizate both tables maybe ( server & local ) ?

Yes
FWMYSQL makes a lot of things very easy, if only we use its features.

ADO itself can not work with embedded MySql.
But ADO application can simultaneously work with FWMYSQL embedded MySql.

You can use ADO to connect to the remote server and use FWH to connect to a local embedded MySql on local Disk. Work with both the connections simultaneously.

Mr Nages, with TDOLPHIN every 30 seconds I use a TIMER to execute a simple SELECT (eg SET @ dummy = 0) to keep the connection active. With FWMySql this is necessary? http://forums.fivetechsupport.com/viewtopic.php?f=6&t=26207&p=144601&hilit=dummy#p144601 It is not even necessary ...