TMyTable. Post not showing up for next user

[Michael Britt]

I am new to MYSQL coming from Advantage Database Server.

I have created a simple 1 form application with a MYDAC connection component and a MYDAC TMyTable.

If USER1 edits a field by MyTable.Edit...Then they change a value and click save which calls MyTable.Post it works fine.

But when USER2 opens the application they don't see the change that USER1 made. They see the default value.

In Advantage Database as soon as a user makes a change to a table it is immediately reflected in the database so all other users see the change.

The only way i have found around this is before calling MyTable.Edit i first call MyTable.Refresh. Is this the most efficient way to do this?

Thanks in advance.