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.
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.