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