Displaying the UPDATE, mySql

Thread View: borland.public.kylix.database.sqlservers

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by Dumboo Fri, 31 Oct 2003 18:14

#179

Author: Dumboo
Date: Fri, 31 Oct 2003 18:14

22 lines
1557 bytes

hi there
i m having a MySQL table, where there are, n-number of clients connected to
it,
who are updating and modifying the table, i have used, dbExpress -
SQLConnection, SQLClientDataSet, and DataSource component, on my form, and
DBGrid component to display the records

the problem i m facing is, that the changes maded by any one of the client
is not visible to the other clients, i.e they r not displayed on the DBGrid
component,
to display em, i have used a Timer and on its OnTimer Event i have written
following code

{
SQLClientDataSet->Active = false;
SQLClientDataSet->Active = true;
}

maybe this is not the best possible way to display it,
any suggestions ???

-Dumboo

Re: Displaying the UPDATE, mySql

#183

Author: Nikola
Date: Sat, 08 Nov 2003 22:56

29 lines
1824 bytes

"Dumboo" <dumboo@nowhere.com> wrote:
>hi there
>i m having a MySQL table, where there are, n-number of clients connected to
>it,
>who are updating and modifying the table, i have used, dbExpress -
>SQLConnection, SQLClientDataSet, and DataSource component, on my form, and
>DBGrid component to display the records
>
>the problem i m facing is, that the changes maded by any one of the client
>is not visible to the other clients, i.e they r not displayed on the DBGrid
>component,
>to display em, i have used a Timer and on its OnTimer Event i have written
>following code
>
>{
>SQLClientDataSet->Active = false;
>SQLClientDataSet->Active = true;
>}
>
>maybe this is not the best possible way to display it,
>any suggestions ???
>
>-Dumboo
>
>
>
>
      They are not displayed until you refresh DBGrid.  I think your code should do the job. But be careful not to put refresh
time to fast because you don't want to overload you app.

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads