http://gambaswiki.org/bugtracker/edit?object=BUG.1122&from=L21haW4-
Bruce BRUEN reported a new bug. Summary ------- SQL syntax highlighter does not respect continued (multiline) strings Type : Bug Priority : Low Gambas version : 3.9.90 (TRUNK) Product : GUI components Description ----------- SQL string literals can continue over multiple lines without any special treatment as the string is terminated by the first occurrence of the string delimiter used. For example, the SQL source file may contain: COMMENT ON TABLE jockey_stats IS 'At the moment this table contains the crosstabulated monthly figures for the jockey over the last 12 months. It is created by an involved query that is run daily. The column names need changing (desperatley)'; The string is totally delimited by the ' character pair and any CR/LF are ignored. The SQL syntax highlighter does not respect that convention and treats everything after the "... run daily." as more of the same string. System information ------------------ [System] Gambas=3.9.90 r8135 OperatingSystem=Linux Kernel=4.1.15-pclos1 Architecture=x86 Distribution=PCLinuxOS Desktop=LXDE Theme=Gtk Language=en_AU.UTF-8 Memory=1005M [Libraries] Cairo=libcairo.so.2.11400.6 Curl=libcurl.so.3.0.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.603.0 GTK+2=libgtk-x11-2.0.so.0.2400.26 GTK+3=libgtk-3.so.0.1400.14 OpenGL=libGL.so.1.2.0 OpenGL=libGL.so.173.14.39 OpenGL=libGL.so.96.43.23 Poppler=libpoppler.so.13.0.0 Poppler=libpoppler.so.19.0.0 Poppler=libpoppler.so.46.0.0 Poppler=libpoppler.so.54.0.0 QT4=libQtCore.so.4.8.7 QT5=libQt5Core.so.5.4.2 SDL=libSDL-1.2.so.0.11.4 SQLite=libsqlite3.so.0.8.6 [Environment] BROWSER=/usr/bin/www-browser CANBERRA_DRIVER=pulse DBUS_SESSION_BUS_ADDRESS=unix:abstract=/tmp/dbus-6AOFReU3eQ,guid=967e3250abf3a8a11787da3259458417 DESKTOP_SESSION=LXDE DISPLAY=:0 GB_GUI=gb.qt4 GCONF_TMPDIR=/tmp GDMSESSION=04LXDE GDM_XSERVER_LOCATION=local GIT_PAGER=less -FRS GPG_AGENT_INFO=/tmp/gpg-5uywEs/S.gpg-agent:3147:1 GTK_MODULES=canberra-gtk-module GUILE_LOAD_PATH=/usr/share G_FILENAME_ENCODING=@locale HISTCONTROL=ignoredups HISTSIZE=1000 HOME=<home> HOSTNAME=<hostname> INPUTRC=/etc/inputrc LANG=en_AU.UTF-8 LANGUAGE=en_AU:en_GB:en LC_ADDRESS=en_AU.UTF-8 LC_COLLATE=en_AU.UTF-8 LC_CTYPE=en_AU.UTF-8 LC_IDENTIFICATION=en_AU.UTF-8 LC_MEASUREMENT=en_AU.UTF-8 LC_MESSAGES=en_AU.UTF-8 LC_MONETARY=en_AU.UTF-8 LC_NAME=en_AU.UTF-8 LC_NUMERIC=en_AU.UTF-8 LC_PAPER=en_AU.UTF-8 LC_SOURCED=1 LC_TELEPHONE=en_AU.UTF-8 LC_TIME=en_AU.UTF-8 LESS=-MM LESSCHARSET=utf-8 LESSKEY=/etc/.less LESSOPEN=|/usr/bin/lesspipe.sh %s LOGNAME=<user> LS_COLORS= MAIL=/var/spool/mail/<user> MDV_MENU_STYLE=discovery META_CLASS=desktop NLSPATH=/usr/share/locale/%l/%N PATH=/bin:/usr/bin:/usr/local/bin:/usr/games:/usr/lib/qt4/bin:/usr/lib/qt5/bin:/usr/bin:/usr/sbin:/usr/lib/kde4/libexec:/bin:/sbin:/usr/X11R6/bin:/usr/games:/usr/local/bin:/usr/local/sbin:/usr/lib/qt5/bin:/usr/bin:/usr/sbin:/usr/lib/kde4/libexec:/bin:/sbin:/usr/X11R6/bin:/usr/games:/usr/local/bin:/usr/local/sbin:<home>/bin:/sbin:/usr/sbin:/bin:/usr/bin:/usr/X11R6/bin:/usr/local/bin:/usr/local/sbin:/usr/lib/kde4/libexec PKG_CONFIG_PATH=/usr/lib/pkgconfig PWD=<home> PYTHONDONTWRITEBYTECODE=1 PYTHONSTARTUP=/etc/pythonrc.py QT4DOCDIR=/usr/share/doc/qt4 QT5DOCDIR=/usr/share/doc/qt5 QTDIR=/usr/lib/qt4 QTDIR5=/usr/lib/qt5 QTINC=/usr/lib/qt3/include QTLIB=/usr/lib QT_PLUGIN_PATH=/usr/lib/qt4/plugins/:/usr/lib/kde4/plugins/:/usr/lib64/kde4/plugins:/usr/lib/kde4/plugins QT_XFT=0 SAL_USE_VCLPLUGIN=gtk SHELL=/bin/bash SHLVL=2 SSH_AGENT_PID=3091 SSH_ASKPASS=/usr/lib/ssh/ssh-askpass SSH_AUTH_SOCK=<home>/tmp/ssh-ARhV7y8AZBzn/agent.3083 TMP=<home>/tmp TMPDIR=<home>/tmp TZ=:/etc/localtime USER=<user> WINDOWPATH=8 XAUTHORITY=<home>/.Xauthority XDG_CONFIG_DIRS=/etc/xdg/discovery:/etc/xdg XDG_CONFIG_HOME=<home>/.config XDG_CURRENT_DESKTOP=LXDE XDG_DATA_DIRS=/usr/local/share:/usr/share/gdm:/var/lib/menu-xdg:/usr/share:/usr/share/gdm/ XDG_MENU_PREFIX=lxde- XDG_SESSION_COOKIE=82ab6c261883e9ffe2a80b674b7b435e-1497728016.181950-1353101201 XMODIFIERS=@im=none _=/usr/bin/gambas3 _LXSESSION_PID=2617 ------------------------------------------------------------------------------ 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