http://gambaswiki.org/bugtracker/edit?object=BUG.1109=L21haW4-
Michael ALTROGGE reported a new bug.
Summary
---
Wrong Substitution
Type : Bug
Priority : Medium
Gambas version : 3.9.90 (TRUNK)
Product : PostgreSQL driver
Description
---
Doing this:
Public Sub MAIN()
Dim strSQL As String
DatabaseOpenCon()
-->strSQL = DBConMain.Subst("SELECT &1, &2, &3, &4, &5, &6 FROM &7",
"INDX", "MNDT", "SQLT", "SQLI", "SQLB", "SQLN", "DD00T")
DBErgMain = DBConMain.Exec(strSQL)
For Each DBErgMain
Debug DBErgMain[0], DBErgMain[1], DBErgMain[2], DBErgMain[3],
DBErgMain[4], DBErgMain[5]
Next
End
will result in that:
--> SYS_DB.MAIN.10: SELECT E'INDX', E'MNDT', E'SQLT', E'SQLI', E'SQLB', E'SQLN'
FROM E'DD00T'
System information
--
[System]
Gambas=3.9.90
OperatingSystem=Linux
Kernel=4.4.0-72-generic
Architecture=x86_64
Distribution=Linux Mint 18.1 Serena
Desktop=CINNAMON
Theme=Gtk
Language=de_DE.UTF-8
Memory=3511M
[Libraries]
Cairo=libcairo.so.2.11400.6
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.803.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]
DBUS_SESSION_BUS_ADDRESS=unix:abstract=/tmp/dbus-EFHGqAGhVd,guid=9b762d3834ba788f5de4cc2b5926db76
DEFAULTS_PATH=/usr/share/gconf/cinnamon.default.path
DESKTOP_AUTOSTART_ID=107b3a8f22f976950d14957187758163010020170012
DESKTOP_SESSION=cinnamon
DISPLAY=:0
GB_GUI=gb.qt4
GDMSESSION=cinnamon
GDM_XSERVER_LOCATION=local
GNOME_DESKTOP_SESSION_ID=this-is-deprecated
GTK_MODULES=gail:atk-bridge
GTK_OVERLAY_SCROLLING=1
HOME=
LANG=de_DE.UTF-8
LOGNAME=
MANDATORY_PATH=/usr/share/gconf/cinnamon.mandatory.path
MDMSESSION=cinnamon
MDM_LANG=de_DE.UTF-8
MDM_XSERVER_LOCATION=local
PATH=/bin:/.local/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/usr/local/games
PWD=
QT_ACCESSIBILITY=1
QT_LINUX_ACCESSIBILITY_ALWAYS_ON=1
QT_QPA_PLATFORMTHEME=qgnomeplatform
QT_STYLE_OVERRIDE=gtk
SESSION_MANAGER=local/:@/tmp/.ICE-unix/2017,unix/:/tmp/.ICE-unix/2017
SHELL=/bin/bash
SSH_AGENT_PID=2101
SSH_AUTH_SOCK=/run/user/1000/keyring/ssh
TZ=:/etc/localtime
USER=
USERNAME=
WINDOWPATH=7
XAUTHORITY=/.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-1495718772.950534-1270231686
XDG_SESSION_DESKTOP=cinnamon
XDG_SESSION_ID=c1
XDG_VTNR=7
--
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
