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

[Bruce Bruen]

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
-- 
best regards
Bruce Bruen