[Gambas-user] Result sets and the fields they contain...

[sbungay]

Correction

Y = ResultSet[ResultSet.Field[X].Name]

or

For X = 1 TO ResultSet.Fields.Count
    Grid.Current.Text = ResultSet[ResultSet.Field[X].Name]
Next

sbungay wrote:
>   I was afraid that was the only method.
>   Does this not limit the flexability of what can be done with the
> Result?
> 
> For example something like this
> 
>  X = ResultSet[ResultSet.Field[X].Name] 
> 
>    would be a VERY useful ability. One could then build a generic 
> function which could iterate through all fields of any result from any 
> SQL. This would make pouplating grids a simple matter.. not good for 
> large result sets (for that a data bound grid is preferred).
> 
> Steve.
> 
> 
> Benoit Minisini wrote:
> 
>>On Tuesday 25 July 2006 14:39, sbungay wrote:
>>
>>
>>>   I have been through the docs and I see nothing like
>>>Result.Field[X].Name but I do see an Exists method. Is there a way for
>>>the result object to tell me the names of the fields it contains?
>>>
>>>Steve.
>>>
>>
>>
>>You must do:
>>
>>MyResult.Fields[FieldName] to get a ResultField object that will describe the 
>>field returned by the Result object.
>>
>>Regards,
>>
> 
> 
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys -- and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> Gambas-user mailing list
> Gambas-user at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/gambas-user
>