Recent

Author Topic: Management System Replication in MYSQL  (Read 10956 times)

gregorytecno

  • New Member
  • *
  • Posts: 12
Re: Management System Replication in MYSQL
« Reply #15 on: February 06, 2014, 05:05:47 pm »
I just did a test with VB 6.0 using Ado and a DataGrid control and throws the perfect return results. the only thing I did using ODBC in VB60, not natively and that's a disadvantage. Lazarus should be higher than VB 6.0 this aspect. That way I want to display records and know each sentence manipulate how users sequentially on each server connected to the replication using the Enterprise Management System. In this example I can see that Mysql server ID 2, added a product to the dpmovinv table. This is good to know each of the traces that has suffered a record. It would be excellent that do the job lazarus without so many problems.
« Last Edit: February 06, 2014, 05:25:52 pm by gregorytecno »

mangakissa

  • Hero Member
  • *****
  • Posts: 947
Re: Management System Replication in MYSQL
« Reply #16 on: February 06, 2014, 10:51:25 pm »
That's not true.
SHOW BINLOG EVENTs is an intern command witch will be translated to a query. Otherwise the dataseserver can not give a result back.

LibMySQL.dll gives two things back:
-  resultset
-  datadefinitionset.
With these results TSQLQuery can build a dataset with the proper fielddefinitions.

Lazarus 1.84 (32b) / FPC 3.0.4
Windows 10