http://gambaswiki.org/bugtracker/edit?object=BUG.1109&from=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=107b3a8f22f976950d149571877581630100000020170012 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=<home> LANG=de_DE.UTF-8 LOGNAME=<user> MANDATORY_PATH=/usr/share/gconf/cinnamon.mandatory.path MDMSESSION=cinnamon MDM_LANG=de_DE.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/2017,unix/<hostname>:/tmp/.ICE-unix/2017 SHELL=/bin/bash SSH_AGENT_PID=2101 SSH_AUTH_SOCK=/run/user/1000/keyring/ssh TZ=:/etc/localtime USER=<user> USERNAME=<user> WINDOWPATH=7 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-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