How to handle the dbnavigator?

Hi Folks,

Using this procedure > TForm1.dbNavClick(Sender: TObject; Button: TNavigatorButton);
begin

How Can I differentiate which button is clicked a working sample would be great ;)

Regards,

Peter
PeterdeBAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
2266180Connect With a Mentor Commented:
the button clicked is in Button: TNavigatorButton

you use it like:

case button of
  nbFirst: showmessage('first clicked');
  nbprior:showmessage('prior clicked');
..... etc
end;
you can find teh possible values in help by clicking on TNavigateBtn and hitting ctrl+F1
here is the definition:
TNavigateBtn = (nbFirst, nbPrior, nbNext, nbLast,
                  nbInsert, nbDelete, nbEdit, nbPost, nbCancel, nbRefresh);
0
 
PeterdeBAuthor Commented:
Ah wait lol I can't right or better said I needn't?
0
 
moorhouselondonCommented:
procedure gofirst;
..

procedure goprior;
..


TForm1.dbNavClick(Sender: TObject; Button: TNavigatorButton);
begin
If button=nbfirst then gofirst else
if button=nbprior then goprior etc.
end;
0
[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

 
moorhouselondonCommented:
ciuly can type faster than me!
0
 
moorhouselondonCommented:
bonus comment: more things to do with navigate

http://delphi.about.com/od/usedbvcl/l/aa090203a.htm
0
 
2266180Commented:
>> ciuly can type faster than me!

actually, it's been almost an hour since he posted his question :P
0
 
Geert GruwezOracle dbaCommented:
what are you trying to do ?
you can provide your own routines instead of the datasets ones
0
 
moorhouselondonCommented:
>actually, it's been almost an hour since he posted his question :P

we all wait for the Hourly Expert Alerts, by the look of it.
0
 
2266180Commented:
>> we all wait for the Hourly Expert Alerts, by the look of it.

actually, I was watching a movie :D I get the alerts by the minute :P
0
 
PeterdeBAuthor Commented:
Thanks all! I noticed that it was possible to edit the database without saving it, closing the program and then the modifications were lost. So I thouhgt maybe I could use the different buttons and buttonclicks in conjunction with teh close query to determine wheter or not to close the program. It's for a friend of mine.

Regards,

Peter

0
 
PeterdeBAuthor Commented:
As always muchos gracias my friend!
0
 
moorhouselondonCommented:
You can check if the table is in a Modified state.  Use CloseQuery to terminate the program, and set the "Accept" variable according to whether or not the table is in Modified state.  If you DoubleClick the CloseQuery Event on the Form, look at the header of the event, you will see the Accept variable there.  All you have to do is plonk the correct value in the procedure to either Accept the Close, or reject the Form's closure.

Other things that might be of interest:-

similarly, if you want the user to explicitly Post a Record before using First, Next, Prior, First or Last, you can either disable these buttons until Table Modified is False (either the user has pressed Post or Cancel), or you can wait for the user to press one of these buttons, then Showmessage('Can not do this'); if Table is Modified.

There is nothing to stop you having more than one DBNavigator for your Datasource - you could have one for First Prior Next Last, and another for the other Buttons/functions (Post, Cancel, etc).
0
 
moorhouselondonCommented:
procedure TForm2.FormCloseQuery(Sender: TObject; var CanClose: Boolean);
begin

Sorry, it's not Accept, it's CanClose.  In which case you can say

CanClose:=not tablex.modified;
0
All Courses

From novice to tech pro — start learning today.