[Gambas-bugtracker] Bug #3002: DB.Subst (gb.db2)

[<bugtracker@xxxxxxxxxxxxxx>]

http://gambaswiki.org/bugtracker/edit?object=BUG.3002&from=L21haW4-

Poly TRICHUM reported a new bug.

Summary
-------

DB.Subst (gb.db2)

Type             : Bug
Priority         : Medium
Gambas version   : 3.20
Product          : Database component


Description
-----------

There is different output when using the function db.Subst with gb.db2 than with gb.db

Example:
Print DB.Subst("SELECT * From [&1] WHERE '&2' = &3 Order by '&4' DESC", "Namen", "Firstname", "Risa", "Lastname")

Output:
with gb.db2: SELECT * From ['Namen'] WHERE ''Firstname'' = 'Risa' Order by ''Lastname'' DESC
         
with gb.db: SELECT * From "Namen" WHERE "Firstname" = 'Risa' Order by "Lastname" DESC
          
and therefore gives an error message when creating a result with this function with a SQLite database

--> Near "Firstname": syntax error 


Best regards
Poly


System information
------------------

[System]
Gambas=3.20.2 972c02e (master)
OperatingSystem=Linux
Distribution=Devuan GNU/Linux 5 (daedalus)
Kernel=6.1.0-21-amd64
Architecture=x86_64
Cores=2
Memory=3797M
Language=de_DE.UTF-8
Platform=x11
Desktop=KDE
DesktopResolution=96
DesktopScale=7
WidgetTheme=breeze
Font=Noto Sans,10
DarkTheme=False
[Programs]
dpkg=Debian »dpkg« Paketmanagement-Programm Version 1.21.22 (amd64).
gcc=gcc (Debian 12.2.0-14) 12.2.0
git=git version 2.39.5
msgmerge=msgmerge (GNU gettext-tools) 0.21
rpmbuild=RPM version 4.18.0
[Libraries]
Cairo=libcairo.so.2.11600.0
Curl=libcurl.so.4.8.0
DBus=libdbus-1.so.3.32.4
GDK2=libgdk-x11-2.0.so.0.2400.33
GDK3=libgdk-3.so.0.2406.32
GStreamer=libgstreamer-1.0.so.0.2200.0
GTK+2=libgtk-x11-2.0.so.0.2400.33
GTK+3=libgtk-3.so.0.2406.32
OpenGL=libGL.so.1.7.0
Poppler=libpoppler.so.126.0.0
QT5=libQt5Core.so.5.15.8
QT6=libQt6Core.so.6.4.2
RSvg=librsvg-2.so.2.48.0
SDL=libSDL2-2.0.so.0.2600.5
SQLite3=libsqlite3.so.0.8.6
[Environment]
DBUS_SESSION_BUS_ADDRESS=unix:path=/tmp/dbus-HQhVUt7Bpn,guid=30a6dffb4329cd9be219846367dc277d
DESKTOP_SESSION=plasma
DISPLAY=:0
GB_GUI=gb.qt5
GDMSESSION=plasma
GPG_AGENT_INFO=/run/user/1000/gnupg/S.gpg-agent:0:1
GTK2_RC_FILES=/etc/gtk-2.0/gtkrc:<home>/.gtkrc-2.0:<home>/.config/gtkrc-2.0
GTK_CSD=0
GTK_MODULES=gail:atk-bridge
GTK_OVERLAY_SCROLLING=0
GTK_RC_FILES=/etc/gtk/gtkrc:<home>/.gtkrc:<home>/.config/gtkrc
HOME=<home>
KDE_APPLICATIONS_AS_SCOPE=1
KDE_FULL_SESSION=true
KDE_SESSION_UID=1000
KDE_SESSION_VERSION=5
LANG=de_DE.UTF-8
LANGUAGE=de_DE.UTF-8
LD_PRELOAD=libgtk3-nocsd.so.0
LIBOVERLAY_SCROLLBAR=0
LOGNAME=<user>
PATH=/usr/local/bin:/usr/bin:/bin:/usr/local/games:/usr/games
PWD=<home>
QT_ACCESSIBILITY=1
QT_AUTO_SCREEN_SCALE_FACTOR=0
QT_LOGGING_RULES=*.debug=false
SESSION_MANAGER=local/<hostname>:@/tmp/.ICE-unix/2220,unix/<hostname>:/tmp/.ICE-unix/2220
SHELL=/bin/bash
SSH_AGENT_PID=2154
SSH_AUTH_SOCK=/tmp/ssh-JZFPZz4drU9E/agent.2107
TZ=:/etc/localtime
USER=<user>
XAUTHORITY=<home>/.Xauthority
XCURSOR_SIZE=24
XCURSOR_THEME=breeze_cursors
XDG_CONFIG_DIRS=<home>/.config/kdedefaults:/etc/xdg
XDG_CURRENT_DESKTOP=KDE
XDG_GREETER_DATA_DIR=/var/lib/lightdm/data/<user>
XDG_RUNTIME_DIR=/run/user/1000
XDG_SEAT=seat0
XDG_SEAT_PATH=/org/freedesktop/DisplayManager/Seat0
XDG_SESSION_CLASS=user
XDG_SESSION_DESKTOP=plasma
XDG_SESSION_ID=1
XDG_SESSION_PATH=/org/freedesktop/DisplayManager/Session0
XDG_SESSION_TYPE=x11
XDG_VTNR=7
force_s3tc_enable=true


----[ Gambas bugtracker-list is hosted by https://www.hostsharing.net ]----