Can I create an application Client/Server ?

[whitespirit]

Hello everybody,

I need to create a Client / Server application, with 50 connections on the same table MySQL at the same time. I use the ODBC's components (TTable), and the information on every other TTables is not refreshed after entity is created, modified, removed or delete.

The user can see all information when starting his session until he close it. But he is not able to see any modification done by other users while running his session.

How can I resolve this problem with the Data Access Components for MySQL ? What do i need ?

Thanks.

[Antaeus]

MyDAC provides automatic data updates. You just need to place correspondent components onto the form, link them, assign connection settings and a table name.
However, for complicated cases (joins, stored procedures returning datasets, etc.) you will need to provide some additional settings to support data editing. You can take a look at MyDAC demo projects for example.