[Gambas-user] [Gambas Bug Tracker] Bug #1101: ODBC driver super buggy 2: rs.max return always negative and always -2 event in lasted

[bugtracker at ...3416...]

http://gambaswiki.org/bugtracker/edit?object=BUG.1101&from=L21haW4-

PICCORO LENZ MCKAY reported a new bug.

Summary
-------

ODBC driver super buggy 2: rs.max return always negative and always -2 event in lasted

Type             : Bug
Priority         : High
Gambas version   : 3.9
Product          : ODBC driver


Description
-----------

as i said in previous bug: some time ago i tried and found many bugs, but not reported due i using older linux.. 

tested in linuxmint, winbuntu, stupibuntu, debian lasted, and fedora 
and with gambas versions from 3.1.1 to lasted (specifically 3.1.1, 3.4.2 and 3.9.X and trunk)

the next piece of code always return "-2" for Max in resulset:

Try rs = $conexionodbc.Exec(queryprices)
    If rs.Available Then  ' 
      
      ' BUG 2 Max from resulset in ODBC are negative!
      howmany = rsprices.Max '  <---- psst ¡always get here -2! no care the query, if there are a SP always -2

    Endif

this are very unconfortable, due for workaroud must made a select count(), that relies on another bug that i next to post right now!

for now i try to workaround with the rs.MoveNext using when


System information
------------------

[System]
Gambas=3.9.1
OperatingSystem=Linux
Kernel=3.2.0-0.bpo.4-686-pae
Architecture=x86
Distribution=debian 6.1
Desktop=
Theme=VenenuX
Language=es_VE.UTF-8
Memory=1695M

[Libraries]
Cairo=libcairo.so.2.11000.2
Curl=libcurl.so.4.2.0
DBus=libdbus-1.so.3.4.0
GStreamer=libgstreamer-0.10.so.0.27.0
GTK+2=libgtk-x11-2.0.so.0.2000.1
Poppler=libpoppler.so.5.0.0
QT4=libQtCore.so.4.7.4
SDL=libSDL-1.2.so.0.11.4
SQLite=libsqlite3.so.0.8.6

[Environment]
DBUS_SESSION_BUS_ADDRESS=unix:abstract=/tmp/dbus-SDLMZFhfxe,guid=e84bee4349323ab2fdd0e833000d3724
DESKTOP_SESSION=openbox
DISPLAY=:0.0
GB_GUI=gb.qt4
GDMSESSION=openbox
GDM_LANG=es_VE.UTF-8
GDM_XSERVER_LOCATION=local
GNOME_KEYRING_CONTROL=/tmp/keyring-F6Av2Z
GNOME_KEYRING_PID=28945
HOME=<home>
LANG=es_VE.UTF-8
LOGNAME=<user>
PATH=/usr/local/bin:/usr/bin:/bin:/usr/local/games:/usr/games:<home>/.rvm/bin
PWD=<home>
SHELL=/bin/bash
SSH_AGENT_PID=28992
SSH_AUTH_SOCK=/tmp/ssh-MIgmw28954/agent.28954
TZ=:/etc/localtime
USER=<user>
USERNAME=<user>
WINDOWPATH=7:8:8:8:8
XAUTHORITY=<home>/.Xauthority
XDG_DATA_DIRS=/usr/local/share/:/usr/share/:/usr/share/gdm/
XDG_SESSION_COOKIE=b7d14e28769c4139a06b6f990000000c-1493388004.744958-1810097376