Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Bong Bungalan
  Where is Bong Bungalan?
 gensan
 Philippines
 Bong Bungalan
 To: Stefan Wuebbe
  Where is Stefan Wuebbe?
 Hamburg
 Germany
 Stefan Wuebbe
 Tags
Subject: RE: Adding Header.Click() event at runtime
Thread ID: 268547 Message ID: 268628 # Views: 22 # Ratings: 0
Version: Visual FoxPro 9 Category: Classes and Objects
Date: Tuesday, July 13, 2010 4:31:10 PM         
   


Hi again,
Thanks for clarifying the Collate thing. Noted your points.

while about that checking if tag exist, i just found "TAGNO()" which worked too. I just dont know yet if ATagInfo() and TagNo() has a significant difference.

ANyways, Thank you guys for your help. This feature now seemed fully functional and it would not be possible without Foxite and you guys.

More power to Foxite and to all of you guys. Kind regards
Bong


> If you add an explicit Collate clause, you do not need to do an additional "Set Collate To ..." before (and after) your "Index On ..." line(s), so that each "Index On .." line would care for itself and would not depend on any (un)intentional environment settings.
> (Collate=machine is the fastest one and also the default setting.)
>
>
> > Also, I indexed all the Fields included (though there are fields that are not necessary to include) to avoid the error when I click on the header which is not indexed. Will this case affects the performance if by chance this view will hold hundreds of thousands records?
> >
>
> While each index tag indeed has its performance "costs", I'd say it might quite likely not make a noticeable performance difference in this case.
>
> However, you can expand the previous code if you like by additionally doing something like checking whether a certain index tag is existing or not -> ATagInfo()
>
> Or by explicitly storing (or not storing) the desired index tag name somewhere, for instance in the anyColumn.Tag property, so that your header.Click() code would "see" whether a specific column allows setting order or not.
> Or by doing BindEvent() with certain columns only...
>
>
>
> hth
> -Stefan

ENTIRE THREAD

Adding Header.Click() event at runtime Posted by Bong Bungalan @ 7/13/2010 8:15:49 AM
RE: Adding Header.Click() event at runtime Posted by Bhushan Sahni @ 7/13/2010 8:20:56 AM
RE: Adding Header.Click() event at runtime Posted by Bong Bungalan @ 7/13/2010 8:33:49 AM
RE: Adding Header.Click() event at runtime Posted by Bhushan Sahni @ 7/13/2010 8:35:09 AM
RE: Adding Header.Click() event at runtime Posted by Stefan Wuebbe @ 7/13/2010 8:37:29 AM
RE: Adding Header.Click() event at runtime Posted by Bong Bungalan @ 7/13/2010 9:12:34 AM
RE: Adding Header.Click() event at runtime Posted by Stefan Wuebbe @ 7/13/2010 10:00:19 AM
RE: Adding Header.Click() event at runtime Posted by Bong Bungalan @ 7/13/2010 2:18:31 PM
RE: Adding Header.Click() event at runtime Posted by Stefan Wuebbe @ 7/13/2010 3:29:19 PM
RE: Adding Header.Click() event at runtime Posted by Bong Bungalan @ 7/13/2010 3:52:15 PM
RE: Adding Header.Click() event at runtime Posted by Stefan Wuebbe @ 7/13/2010 4:17:35 PM
RE: Adding Header.Click() event at runtime Posted by Bong Bungalan @ 7/13/2010 4:31:10 PM
RE: Adding Header.Click() event at runtime Posted by tushar @ 7/13/2010 4:23:10 PM
RE: Adding Header.Click() event at runtime Posted by Bong Bungalan @ 7/13/2010 4:37:24 PM
RE: Adding Header.Click() event at runtime Posted by tushar @ 7/13/2010 4:43:17 PM
RE: Adding Header.Click() event at runtime Posted by tushar @ 7/13/2010 8:46:25 AM