Refresh QDataTable

[jacek]

I simultaneously run both the project 's GUI and after making changes in the database from one GUI in one project it doesnt get showed in the GUI of another project.

Can you see those changes if you connect to the database using a SQL console?

[shamik]

Can you see those changes if you connect to the database using a SQL console?

what do you mean by this SQL console? how to start it??

[jacek]

what do you mean by this SQL console? how to start it??

It's a program that allows you to issue SQL queries to the database server. AFAIR MySQL calls it "mysql".

[shamik]

i opened the console and typed mysql
then mysql prompt appeared. do you mean this as mysql console??

now i typed the select query on that particular table. now the table is shown on the console.
keeping that open, i ran the exe of the project through which i want to change the database content. i made the changes from its GUI. but the sql table in the console showed the same result (it is obvious). to see the changes i have to write the query in the console again. then i can see the changes.

this is the case with the original project too. the qdatatable widget doesnt reflect the changes as it should be. but whenever i hide it and show other dialog and then again i hide the second dialog and show the original dialog with qdatatable widget then i can see the changes. (hiding and showing is implemented with the help of necessary functions inside the code like show(), hide() ).


if u call opening mysql from console which gives u mysql prompt like this-->
mysql>

then it is obvious that it wil show the changes in the database only if u write the query again after changing it from the GUI.

if u r talking of any other MYSQL console then please tell me how to open it and how to work on it. i'll try on that also.

[jacek]

but whenever i hide it and show other dialog and then again i hide the second dialog and show the original dialog with qdatatable widget then i can see the changes. (hiding and showing is implemented with the help of necessary functions inside the code like show(), hide() ).

Can you see the changes if you keep that QDataTable shown for more than 5 seconds (i.e. long enough for the timer to emit the signal)?

[shamik]

no.

no changes are seen in the qdatatable no matter howlong i keep the timer going on

[sunil.thaha]

It might be possible that the changes you make to the database from the client are not commited !!

So, You can try comitting the changes to database.
One more thing, Hope you are setting the interval as 3000 for 3 Sec

[shamik]

i have treid commiting the database after every record change but still it isnt working. the timer time can b anything, may be 3, 5, 7 sec etc. that is not a problem.
after the database is changed the timer may go on to even ticking 40 times still there is no change in the QDataTable.

even if the QDataTable is kept shown for say 5 mins then also there is no change in it. i.e. the updated values are not shown.

is there anything that v m missing ? i donno why does this simple one takes too much of time.
please help me

[jacek]

Can you see the changes if you update your database using the console (i.e. "mysql" program)?

[shamik]

No
cant see the changes in the QDataTable even if i change the database from mysql prompt :
mysql>

i dont understand what is the problems.??

[jacek]

Do you start any transactions before reading data from the database?

[shamik]

i dont use any trasactions
just start mysql and start reading data or execute the exe which does the same.

no complex things are done with mysql. just reading and writing the data. no transactions are used. no committing is done either.

this i think is an exceptional case of mine.