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

[sbungay]

  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,
>