[Gambas-user] Help to make on the fly pointer to various result sets

[Jeff Halverson]

Thanks, this is exactly what I was looking for.  I knew there must be a
way to do this and am suprised I missed the Results[String] formating
option!

Jeff H
Tokyo

On Wed, 2011-04-13 at 10:50 +0930, Bruce Bruen wrote:

> On Wednesday, April 13, 2011 09:21:05 AM Jeff Halverson wrote:
> > I have something that is puzzling me that seems easy to do, but I can't
> > figure it out...  I was hoping somebody might be able to help.
> > 
> > If I have the following available from a resultset:
> > 
> > DataSummary!InvestmentName
> > DataSummary!BrokerName
> > DataSummary!ManagementCompanyName
> > DataSummary!RegionName
> > 
> > And I want to be able to use each of those fields above in a function,
> > such as the example below:
> > 
> > IF TextToSearchFor = DataSummary!RegionName THEN
> >     ' Do a bunch of stuff
> > END IF
> > 
> > Is there a way to replace the "DataSummary!RegionName" within the
> > function with a variable that will evaluate to the resultset value?
> > Maybe something like:
> > 
> > FieldToSearchFor = "DataSummary!RegionName"
> > IF TextToSearchFor = Evaluate(FieldToSearchFor) THEN
> >     ' Do a bunch of stuff
> > END IF
> > 
> > Obviously the above doesn't work, but is there some means in Gambas to
> > achieve this result?
> > 
> > Any help is greatly appreciately.
> > 
> > Jeff H
> > Tokyo
> > ---------------------------------------------------------------------------
> > --- Forrester Wave Report - Recovery time is now measured in hours and
> > minutes not days. Key insights are discussed in the 2010 Forrester Wave
> > Report as part of an in-depth evaluation of disaster recovery service
> > providers. Forrester found the best-in-class provider in terms of services
> > and vision. Read this report now!  http://p.sf.net/sfu/ibm-webcastpromo
> > _______________________________________________
> > Gambas-user mailing list
> > Gambas-user at lists.sourceforge.net
> > https://lists.sourceforge.net/lists/listinfo/gambas-user
> 
> 
> Sub Search(SearchCol as String) AS Whatever
> 	...
> 	...DataSummary[SearchCol]...
> 	DoABunchOfStuff
> 
> etc