[Gambas-user] [Gambas Bug Tracker] Bug #1027: Unexpected behavior on Sqlite3 exec quotation

[bugtracker at ...3416...]

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

Jorge CARRIÓN reported a new bug.

Summary
-------

Unexpected behavior on Sqlite3 exec quotation

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


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

Hi
On Sqlite3 there is a bug on exec comand with parameters: Quotes are included in the propertie .name of resultfields.

Attach a simple project that ilustrates that behavior..


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

[System]
Gambas=3.9.1
OperatingSystem=Linux
Kernel=4.4.0-45-generic
Architecture=x86_64
Distribution=Linux Mint 18 Sarah
Desktop=CINNAMON
Theme=Cleanlooks
Language=es_ES.UTF-8
Memory=15989M

[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.802.0
GTK+2=libgtk-x11-2.0.so.0.2400.30
GTK+3=libgtk-3.so.0.1800.9
OpenGL=libGL.so.1.0.0
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.0.7
DBUS_SESSION_BUS_ADDRESS=unix:abstract=/tmp/dbus-QDB0fN58RP,guid=43c2815ddf5f864e70a795e55818c117
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=6904
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=es_ES.UTF-8
LOGNAME=<user>
MANDATORY_PATH=/usr/share/gconf/cinnamon.mandatory.path
MDMSESSION=cinnamon
MDM_LANG=es_ES.UTF-8
MDM_XSERVER_LOCATION=local
PATH=<home>/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_STYLE_OVERRIDE=gtk
SESSION_MANAGER=local/<hostname>:@/tmp/.ICE-unix/1830,unix/<hostname>:/tmp/.ICE-unix/1830
SHELL=/bin/bash
SSH_AGENT_PID=2860
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=2a5d5f96ef9147c0b35535562b32d0ff-1478017299.234206-230022800
XDG_SESSION_DESKTOP=cinnamon
XDG_SESSION_ID=c1
XDG_VTNR=7