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
------------------------------------------------------------------------------
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@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/gambas-user
