Hi,

I'm a newcomer to Gambas, having been writing in numerous other languages for years, and I feel I'm doing really well in getting to grips with it.

But I've hit a brick wall with this one.  I'm creating a simple database utility for personal use.  In, for example, XOJO, you can either write rs.field("surname").stringvalue or rs.idxfield(1).stringvalue.  In Gambas it looks at present that you can only use rs!surname.  The stringvalue part isn't needed of course in Gambas.

Question: is there a Gambas equivalent of idxfield(0), eg, rs!(1)?

Help please!

Alan.

CallMeAlan said

Hi,

I'm a newcomer to Gambas, having been writing in numerous other languages for years, and I feel I'm doing really well in getting to grips with it.

But I've hit a brick wall with this one.  I'm creating a simple database utility for personal use.  In, for example, XOJO, you can either write rs.field("surname").stringvalue or rs.idxfield(1).stringvalue.  In Gambas it looks at present that you can only use rs!surname.  The stringvalue part isn't needed of course in Gambas.

Question: is there a Gambas equivalent of idxfield(0), eg, rs!(1)?

Help please!

Alan.

You will have to clarify your question as I don't speak XOJO.  
Are you trying to address a field in a record by it's index, or something a like?

 What I mean is, instead of saying rs!surname, rs!firstname, rs!city, we could say something like rs!1, rs!2, rs!3.  That is, address the columns by their serial number index within the record set instead of by their column name.

In XOJO we would say rsfield("surname").stringvalue, or rs.idxfield(1).stringvalue, which give the same value.  This permits the use of a for loop to address the columns, such  as:
for x=0 to whatever
    listbox1.add(rs!x)
next

I hope this makes sense!

Alan.

Hi and welcome the result-class acts like an array
So you simple can do

For example



So you have 3 choices:

1.) rs!Namen
2.)  rs["Namen"]
3.) rs[1]

/comp/gb.db2/result - Gambas Documentation

best regards
Poly

and

4.) rs.All     see /comp/gb.db2/result/all - Gambas Documentation

 Oh dear me!  rs[1] works!  I clearly never thought to use square brackets - I was trying round brackets, eg, rs(0).

Many thanks for solving my problem.

Alan