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

[PICCORO McKAY Lenz]

now after some messaged between fabian and me, i continue in the list the
problemm

thanks fabian.. do you see that moveto do not permit due the grid does not
fill in order.. so when the data event are raised the index are not
secuencial so a "foward only" problem happened....

and now u count and then send again the select:


  $Result = db.Exec("select count(*) irows from sys_productos")
  $iCount = $Result!irows

  $Result = db.Exec("select * from sys_productos") <- in sybase odbc seems
this does not work afete a count using select


seems there's a problem in odbc, this was i do in firts, but does not work,
maybe i do in bad way..

due right now i not have the odbc environment.. i'll test monday and post
feedback here.. but seems the odbc module in gambas has a problem in this
way, due does not permit make that.. or at least does not permit retrieve
the results after made a select count


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

2017-05-19 2:59 GMT-04:30 Fabien Bodard <gambas.fr at ...626...>:

> 2017-05-18 17:13 GMT+02:00 PICCORO McKAY Lenz <mckaygerhard at ...626...>:
> > yes tobias, I already know.- in last years some bugs where discovered by
> me
> > ... the surprise its that those bugs were inside gambas since some time
> ..
> > that's probe that the usage of was very few and limited .. (i mean too
> many
> > mysql )
> >
> > but now i can not use, the corporation now used odbc for standard and
> > gundows integration ... so i must use odbc inclusivelly for mysql !!!
> Arrggg
> >
> > so now i implement your solution, and recors fill the grid .. but when i
> > separate the database logic from the form .. now the recorset gives me
> the
> > "only forward" error ...
> >
> > i try to attadhed the project example ... some one can helpme? the mail
> > list cut the message! i cannot attach project!
>
> send it to me :
>
> gambas.fr at ...626...
> >
> > Lenz McKAY Gerardo (PICCORO)
> > http://qgqlochekone.blogspot.com
> >
> > 2017-05-17 18:49 GMT-04:00 Tobias Boege <taboege at ...626...>:
> >
> >> On Thu, 18 May 2017, Cristiano Guadagnino wrote:
> >> > If your complaint is due to the fact that the only native
> implementation
> >> > for Gambas is the Mysql one, you have to understand that Mysql
> (usually
> >> in
> >> > the form of MariaDB) is available on all linux distributions and it is
> >> > free.
> >> > One other free DBMS available for all linuxes is Postgresql, but this
> is
> >> > not even nearly as widely used as Mysql. I would not be very surprised
> >> if,
> >> > in fact, the great majority of Gambas developers were using Mysql.
> What's
> >> > wrong with that?
> >> >
> >>
> >> (Just a quick interjection: Gambas does have a native PostgreSQL
> driver.)
> >>
> >> --
> >> "There's an old saying: Don't change anything... ever!" -- Mr. Monk
> >>
> >> ------------------------------------------------------------
> >> ------------------
> >> Check out the vibrant tech community on one of the world's most
> >> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> >> _______________________________________________
> >> Gambas-user mailing list
> >> Gambas-user at lists.sourceforge.net
> >> https://lists.sourceforge.net/lists/listinfo/gambas-user
> >>
> > ------------------------------------------------------------
> ------------------
> > Check out the vibrant tech community on one of the world's most
> > engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> > _______________________________________________
> > Gambas-user mailing list
> > Gambas-user at lists.sourceforge.net
> > https://lists.sourceforge.net/lists/listinfo/gambas-user
>
>
>
> --
> Fabien Bodard
>
> ------------------------------------------------------------
> ------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> _______________________________________________
> Gambas-user mailing list
> Gambas-user at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/gambas-user
>