Viewing database changes in multi-user system using VB

[123jon]

I am new to MySQL and VB6. This is my situation, I am creating a multi-user application with VB screens as the interface and MySQL as the database.

My problem is VB reads the MySQL database using SQLs (Cursors), so individual users will not see new records that are added because each user is reading the copy of their cursor/sql.

I would like each user to see new records that are added when they are browsing through the records on their screens. That is, I would like dynamic updates of each users screen, once new records are added to the table.

Is this possible using VB6 and MySQL? If so, could you show me how to create the database connection and recordset. Thank you.

 

[LazyMe]

I do not know what MySQL is, but is it supports a Dynamic cursor, your users will see additions made by other users. However, using such a cursor will be lead to loss in performance.
Greetings,
Rick

 

[CCLINT]

>using such a cursor will be lead to loss in performance.

Very true, and very much (overhead and performance loss).

I would settle for placing a lightening bolt on the toolbar and letting the user refresh the data.
When the icon is clicked, requery the recordset using the Requery method.
[/b][/i][/u]_{*******************************************************
General remarks:
If this post contains any suggestions for the use or distribution of code, components or files of any sort, it is still your responsibility to assure that you have the proper license and distribution rights to do so!}

 

[123jon]

Thank you all for your response.
For info on MySql see:

http://www.mysql.com