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

2017-05-22 Thread PICCORO McKAY Lenz
hi zxMarce debuggin i note that based on their documentation, inserts must return affected roms and seems gambas odbc object does not made this.. please illuminate me! i made a odbc inserts and either returns affected roms! some other has same results? Lenz McKAY Gerardo (PICCORO)

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

2017-05-22 Thread PICCORO McKAY Lenz
hello Fabian.. hello zxMarce Fabian, your method/code does not work as zxMarce said.. (in any case, the resultset and db manage was done in form code) due the result object to make the MoveTo need the count for... as said zxMarce all .MoveXXX methods except .MoveNext SEEMS need a record count

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

2017-05-21 Thread PICCORO McKAY Lenz
2017-05-21 12:33 GMT-04:30 : > All .MoveXXX methods except .MoveNext need a record count from the > provider. You know that ODBC does not provide one, but some drivers do, and > I also patched the component to try to fetch this count when possible. > > Now, the driver may NOT

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

2017-05-21 Thread d4t4full
Piccoro, All .MoveXXX methods except .MoveNext need a record count from the provider. You know that ODBC does not provide one, but some drivers do, and I also patched the component to try to fetch this count when possible. Now, the driver may NOT be correctly configured in unixODBC, allowing

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

2017-05-21 Thread 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

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

2017-05-19 Thread Fabien Bodard
2017-05-18 17:13 GMT+02:00 PICCORO McKAY Lenz : > 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

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

2017-05-18 Thread PICCORO McKAY Lenz
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

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

2017-05-18 Thread PICCORO McKAY Lenz
2017-05-17 18:31 GMT-04:00 Cristiano Guadagnino : > 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 >

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

2017-05-17 Thread Tobias Boege
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

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

2017-05-17 Thread Cristiano Guadagnino
Hi PICCORO, I am a professional DBA working daily with IBM DB/2, Microsoft SQL Server, Mysql. First of all, let me tell you that a big effort is needed to read you messages, because of your poor english and your writing style. I'm sorry if I'm a bit blunt, but please... a little effort from you

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

2017-05-17 Thread PICCORO McKAY Lenz
tobias, i answered few seconds, yeah the if was in wrong place.. thanks for the corrections.. and u dont know that ODBC module in gambas does not implement or have same behaviour of the others like sqlite or mysql.. count does not retunrs nothing, max neither so i must implement my own count..

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

2017-05-17 Thread Tobias Boege
On Wed, 17 May 2017, PICCORO McKAY Lenz wrote: > 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? : > >

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

2017-05-17 Thread PICCORO McKAY Lenz
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

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

2017-05-17 Thread PICCORO McKAY Lenz
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