[AccessD] Find First in an Array?

Thank you, Max. ;-)

--
Shamil

-----Original Message-----
From: "Max Wanadoo" <max.wanadoo at gmail.com>
To: "'Access Developers discussion and problem solving'"<accessd at databaseadvisors.com>
Date: Thu, 19 Feb 2009 21:45:28 -0000
Subject: Re: [AccessD] Find First in an Array?

> 
> Hi Shamil,
> I was just going to make exactly the same recommendations!  Great minds
> think alike, eh?
> 
> ^_^
> 
> Max
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Salakhetdinov
> Shamil
> Sent: 19 February 2009 21:40
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Find First in an Array?
> 
> You decide, Rocky,
>  
> Do you have time for that experimenting?
> 
> May I warn you about what is known as:
>  
> "Premature Optimization"
> http://c2.com/cgi/wiki?PrematureOptimization 
>  
> and 
>  
> "Premature Generalization" 
> http://c2.com/cgi/wiki?PrematureGeneralizationIsEvil 
>  
> ?
>  
> Have a look:
>  
> "Death by premature generalization" 
> http://ryanfarley.com/blog/archive/2004/04/30/570.aspx
>  
>  
> My name is Shamil, you know :) and I have been a premature generalizer in
> many cases I must admit - but I'm getting more and more XP/SCRUM agile
> habits these days, and I'm getting more fun from programming real life
> business tasks without my premature generalization and optimization not so
> good(?) past habits...
>  
> IMO in the case of the context of this thread using .Seek is the closest and
> quickest yet good enough (and maybe the only one needed for many years
> ahead) solution/transition from your existing .FindFirst-based code...
>  
> If that would not be good/speedy enough in your case then I'd probaably use
> static array loaded on first call/after reset using .GetRows() with
> accompanying static collection with FormName/ControlName as a key to keep
> value for static array entry index, and a function to get translation value
> using this collection/array...
>  
> etc...
>   
> Thank you.
>  
> --
> Shamil
> 
<<< tail trimmed >>>