[SOLVED] To Button "Commit", I would like to add functionallity
"refresh".
lazarus / 16-Databases

----------------------------------------------------------------------
Elmug · 2012-06-27 10:39

Hi everyone,

I have a button called "Commit" which does:
   SQLQuery1.ApplyUpdates;
   SQLTransaction1.CommitRetaining;  

and would like it to also do a REFRESH, same as what the Navigator-
refresh does, so I can hide the Navigators' refresh, and so the Commit
button does the refresh at once.

How to do it?

Also, where to find document on using methods of the Navigator
component?

Thanks!

----------------------------------------------------------------------
ludob · 2012-06-27 11:31

DBNavigator is just calling Refresh on the dataset. So do a
Code: [Select]SQLQuery1.Refresh;

----------------------------------------------------------------------
Elmug · 2012-06-27 20:22

Quote from: ludob on June 27, 2012, 01:31:38 pmDBNavigator is just
calling Refresh on the dataset. So do a
Code: [Select]SQLQuery1.Refresh;
Thank you very much, ludob.

That surely will do it.

Would you please kindly provide a link to where one can study about
the SQLQuery.Refresh method, and also about the methods that the the
other Navigator buttons call, or can call?

Thanks again!

----------------------------------------------------------------------
BigChimp · 2012-06-28 05:50

Elmug: good idea that your'e asking for documentation to help you find
things.

Regarding links: have a look in the wiki; search on sqlquery.... or
perhaps on refresh.

If you can't find documentation there, it could be in the FPC
documentation (see the links indicated).

If it isn't there, you can have a look through the source code....
where you could just as easily have found what ludob told you about it
just calling .Refresh...

See here:
http://wiki.lazarus.freepascal.org/Lazarus_Faq#What_is_the_correct_way
_to_ask_questions_in_the_forum.3F
for more details...

----------------------------------------------------------------------
Elmug · 2012-06-28 20:36

Quote from: BigChimp on June 28, 2012, 07:50:19 amElmug: good idea
that your'e asking for documentation to help you find things.

Regarding links: have a look in the wiki; search on sqlquery.... or
perhaps on refresh.

If you can't find documentation there, it could be in the FPC
documentation (see the links indicated).

If it isn't there, you can have a look through the source code....
where you could just as easily have found what ludob told you about it
just calling .Refresh...

See here:
http://wiki.lazarus.freepascal.org/Lazarus_Faq#What_is_the_correct_way
_to_ask_questions_in_the_forum.3F
for more details...

Thank you, BigChimp!