[Gambas-user] [Gambas Bug Tracker] Bug #1102: ODBC driver super buggy 3: impossible made subquerys if the previous its a call/select to SP

[bugtracker at ...3416...]

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

PICCORO LENZ MCKAY reported a new bug.

Summary
-------

ODBC driver super buggy 3: impossible made subquerys if the previous its a call/select to SP

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:

query1 = "call sp('value string')" ' this return a select table resulset
query2 = "select count(*) from sp('value string')"  ' < - - use the select table return of the SP with count

Try rs2 = $conexionodbc.Exec(query2)
    If rs2.Available Then  ' 
      
      try rs1 = $conexionodbc.Exec(query1)      ' BUG this raise a problem, no rows and some times !

    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