[Gambas-user] result from select can be movefirts from ODBC?

PICCORO McKAY Lenz mckaygerhard at ...626...
Wed May 17 18:21:24 CEST 2017


sorry was bad implementation, fixed code:


    resulhowmany = resulhowmany + 1
    If resulobj.MoveNext() Then
      Break
    Endif

documentation said that when no records are available retuns true.. very
confused but well..


Lenz McKAY Gerardo (PICCORO)
http://qgqlochekone.blogspot.com

2017-05-17 12:13 GMT-04:00 PICCORO McKAY Lenz <mckaygerhard at ...626...>:

> i try to filla gridview at demand, so due ODBC limitations i cannot count
> so inside my bean-like object i count and tehen return properties..
>
> the problem goes when i try to move to the fitrs record, i implement the
> code in wrong way? :
>
> Try resulobj = $conexionodbc.Exec(exisqueryrequest)
>
>   While (resulobj.Available)
>
>     If resulobj.MoveNext() Then
>       resulhowmany = resulhowmany + 1
>     Else
>       Break
>     Endif
>
>   Wend
>
>   resulobj.MoveFirst ' <--- here said that its foward only, that's true if
> comes from a simple select ?
>
>
>
> Lenz McKAY Gerardo (PICCORO)
> http://qgqlochekone.blogspot.com
>



More information about the User mailing list