http://gambaswiki.org/bugtracker/edit?object=BUG.1088&from=L21haW4-
hakan UNVER reported a new bug.
Summary
-------
sqllite result Overflow
Type : Bug
Priority : Medium
Gambas version : Unknown
Product : Unknown
Description
-----------
This code line :
usorgu = "SELECT * FROM hs_call WHERE CALL_STATUS = '2' OR CALL_STATUS = '3'
OR CALL_STATUS = '9' AND ROOM = '" & room & "' AND CALL_TYPE = 'C' OR CALL_TYPE
= 'Z' OR CALL_TYPE = 'R' AND CALL_CODE = '" & code & "'"
Debug usorgu
rs_update = CFnc.MyConn.Exec(usorgu)
catch
debug Error.text
I get This Error
Debug Log :
FrmMain.update_record.590: SELECT * FROM hs_call WHERE CALL_STATUS = '2' OR
CALL_STATUS = '3' OR CALL_STATUS = '9' AND ROOM = '1383' AND CALL_TYPE = 'C' OR
CALL_TYPE = 'Z' OR CALL_TYPE = 'R' AND CALL_CODE = '0'
FrmMain.update_record.634: Overflow
if I use short Query string is Ok no problem..
System information
------------------
[System]
Gambas=3.9.2
OperatingSystem=Linux
Kernel=4.4.0-62-generic
Architecture=x86_64
Distribution=Linux Mint 18.1 Serena
Desktop=CINNAMON
Theme=Gtk
Language=en_US.UTF-8
Memory=5764M
[Libraries]
Cairo=libcairo.so.2.11502.0
Curl=libcurl.so.4.4.0
DBus=libdbus-1.so.3.14.6
GStreamer=libgstreamer-0.10.so.0.30.0
GStreamer=libgstreamer-1.0.so.0.802.0
GTK+2=libgtk-x11-2.0.so.0.2400.30
GTK+3=libgtk-3.so.0.1800.9
OpenGL=libGL.so.1.2.0
Poppler=libpoppler.so.58.0.0
QT4=libQtCore.so.4.8.7
QT5=libQt5Core.so.5.5.1
SDL=libSDL-1.2.so.0.11.4
SQLite=libsqlite3.so.0.8.6
[Environment]
CINNAMON_VERSION=3.2.6
DBUS_SESSION_BUS_ADDRESS=unix:abstract=/tmp/dbus-Izsym8Vgti,guid=c7fd160b6ebc9bfcf41af72958afd379
DEFAULTS_PATH=/usr/share/gconf/cinnamon.default.path
DESKTOP_SESSION=cinnamon
DISPLAY=:0
GB_GUI=gb.qt4
GDMSESSION=cinnamon
GDM_XSERVER_LOCATION=local
GIO_LAUNCHED_DESKTOP_FILE=/usr/share/applications/gambas3.desktop
GIO_LAUNCHED_DESKTOP_FILE_PID=2009
GJS_DEBUG_OUTPUT=stderr
GJS_DEBUG_TOPICS=JS ERROR;JS LOG
GNOME_DESKTOP_SESSION_ID=this-is-deprecated
GTK_MODULES=gail:atk-bridge
GTK_OVERLAY_SCROLLING=1
HOME=<home>
LANG=en_US.UTF-8
LC_ADDRESS=tr_TR.UTF-8
LC_IDENTIFICATION=tr_TR.UTF-8
LC_MEASUREMENT=tr_TR.UTF-8
LC_MONETARY=tr_TR.UTF-8
LC_NAME=tr_TR.UTF-8
LC_NUMERIC=tr_TR.UTF-8
LC_PAPER=tr_TR.UTF-8
LC_TELEPHONE=tr_TR.UTF-8
LOGNAME=<user>
MANDATORY_PATH=/usr/share/gconf/cinnamon.mandatory.path
MDMSESSION=cinnamon
MDM_LANG=en_US.UTF-8
MDM_XSERVER_LOCATION=local
PATH=<home>/bin:<home>/.local/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/usr/local/games
PWD=<home>
QT_ACCESSIBILITY=1
QT_LINUX_ACCESSIBILITY_ALWAYS_ON=1
QT_QPA_PLATFORMTHEME=qgnomeplatform
QT_STYLE_OVERRIDE=gtk
SESSION_MANAGER=local/<hostname>:@/tmp/.ICE-unix/1532,unix/<hostname>:/tmp/.ICE-unix/1532
SHELL=/bin/bash
SSH_AGENT_PID=1601
SSH_AUTH_SOCK=/run/user/1000/keyring/ssh
TZ=:/etc/localtime
USER=<user>
USERNAME=<user>
WINDOWPATH=8
XAUTHORITY=<home>/.Xauthority
XDG_CONFIG_DIRS=/etc/xdg/xdg-cinnamon:/etc/xdg
XDG_CURRENT_DESKTOP=X-Cinnamon
XDG_DATA_DIRS=/usr/share/cinnamon:/usr/share/gnome:/usr/local/share/:/usr/share/:/usr/share/mdm/
XDG_RUNTIME_DIR=/run/user/1000
XDG_SEAT=seat0
XDG_SESSION_COOKIE=5ab3c275b7304ed3b8aeef9ffcc37eb4-1487917944.855606-545540223
XDG_SESSION_DESKTOP=cinnamon
XDG_SESSION_ID=c1
XDG_VTNR=8
------------------------------------------------------------------------------
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
