The result (still only one field for Primary Key) : gb.db.sqlite3: 0x958f33c: PRAGMA table_info('test2') Primary Key : id2 gb.db.sqlite3: 0x958f33c: SELECT "id2" FROM "test2" ORDER BY "id2" LIMIT 256 gb.db.sqlite3: 0x958f33c: SELECT * FROM "test2" ORDER BY "id2" LIMIT 256
I think I should try with a new linux distro. Thanks. On Sun, Jun 5, 2016 at 4:16 PM, Jorge Carrión <sho...@gmail.com> wrote: > Ok. I think that the problem is in the definition of the test table. > If you try to update a row in your table you got an error about primary > key. > > Try to add a "without rowid" in creation of table, like this: > > CREATE TABLE "test2" ( "id" INT4 NOT NULL , "id2" INT4 NOT NULL , "fruit" > TEXT, PRIMARY KEY ("id","id2") ) without rowid > > This prevents the feature of automated creation of primari index > autoincremental in all tables of sqlite and le yor constrain created > compound primary key to be the only primary key. > > updates should works now. > > Why in gambas the result of an erroneus update is an addition of record, I > can't imagine... > > Regards > > > 2016-06-04 14:54 GMT+02:00 zainudin ahmad <author.i...@gmail.com>: > > > you can extract project into /tmp directory (attach project) > > > > On Sat, May 28, 2016 at 3:50 PM, Jorge Carrión <sho...@gmail.com> wrote: > > > > > It will be intersting take a look to your database structure... > > > > > > Regards > > > > > > 2016-05-28 5:24 GMT+02:00 <bugtrac...@gambaswiki.org>: > > > > > > > http://gambaswiki.org/bugtracker/edit?object=BUG.926&from=L21haW4- > > > > > > > > Comment #10 by Zainudin AHMAD: > > > > > > > > >> maybe you could try to purge everything related to Gambas on your > > > > system, and do a full recompilation from scratch > > > > > > > > I have doing complete removal from synaptic and install gambas from > > PPA. > > > > > > > > in this system I used gambas only from PPA, and I still get this > issue. > > > > > > > > Sys Info : > > > > > > > > [System] > > > > Gambas=3.8.4 > > > > OperatingSystem=Linux > > > > Kernel=3.2.0-69-generic > > > > Architecture=x86 > > > > Distribution=Ubuntu 12.04.5 LTS > > > > Desktop=LXDE > > > > Theme=Oxygen > > > > Language=en_US.UTF-8 > > > > Memory=494M > > > > > > > > [Libraries] > > > > Cairo=libcairo.so.0.0.0 > > > > Cairo=libcairo.so.2.11000.2 > > > > Curl=libcurl.so.4.2.0 > > > > DBus=libdbus-1.so.3.5.8 > > > > GStreamer=libgstreamer-0.10.so.0.30.0 > > > > GStreamer=libgstreamer-1.0.so.0.1.0 > > > > GTK+2=libgtk-x11-2.0.so.0.2400.10 > > > > GTK+3=libgtk-3.so.0.400.2 > > > > OpenGL=libGL.so.173.14.39 > > > > OpenGL=libGL.so.96.43.23 > > > > Poppler=libpoppler.so.19.0.0 > > > > QT4=libQtCore.so.4.8.1 > > > > SDL=libSDL-1.2.so.0.11.3 > > > > > > > > [Environment] > > > > > > > > > > > > > > DBUS_SESSION_BUS_ADDRESS=unix:abstract=/tmp/dbus-MLCzWvSLAH,guid=e9fbdfa8c29a55ad62fb5b2d00000041 > > > > DEFAULTS_PATH=/usr/share/gconf/LXDE.default.path > > > > DESKTOP_SESSION=LXDE > > > > DISPLAY=:0 > > > > GB_GUI=gb.qt4 > > > > GDMSESSION=LXDE > > > > GNOME_KEYRING_CONTROL=/tmp/keyring-27ibEk > > > > GNOME_KEYRING_PID=1698 > > > > GPG_AGENT_INFO=/tmp/gpg-7kMMn6/S.gpg-agent:1752:1 > > > > GTK_MODULES=canberra-gtk-module:canberra-gtk-module > > > > HOME=<home> > > > > LANG=en_US.UTF-8 > > > > LANGUAGE=en_US:en > > > > LC_ADDRESS=en_US.UTF-8 > > > > LC_IDENTIFICATION=en_US.UTF-8 > > > > LC_MEASUREMENT=en_US.UTF-8 > > > > LC_MONETARY=en_US.UTF-8 > > > > LC_NAME=en_US.UTF-8 > > > > LC_NUMERIC=en_US.UTF-8 > > > > LC_PAPER=en_US.UTF-8 > > > > LC_TELEPHONE=en_US.UTF-8 > > > > LC_TIME=en_US.UTF-8 > > > > LIBOVERLAY_SCROLLBAR=0 > > > > LOGNAME=<user> > > > > MANDATORY_PATH=/usr/share/gconf/LXDE.mandatory.path > > > > > > > > > > > > > > PATH=/usr/lib/lightdm/lightdm:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games > > > > PWD=<home> > > > > SAL_USE_VCLPLUGIN=gtk > > > > SHELL=/bin/bash > > > > SSH_AGENT_PID=1751 > > > > SSH_AUTH_SOCK=/tmp/ssh-ZMKoIXgT1709/agent.1709 > > > > TZ=:/etc/localtime > > > > UBUNTU_MENUPROXY=libappmenu.so > > > > USER=<user> > > > > XAUTHORITY=<home>/.Xauthority > > > > XDG_CONFIG_DIRS=/etc/xdg/xdg-LXDE:/etc/xdg > > > > XDG_CONFIG_HOME=<home>/.config > > > > XDG_CURRENT_DESKTOP=LXDE > > > > > > > > > > > > > > XDG_DATA_DIRS=/usr/local/share/:/usr/share/:/usr/share/gdm/:/var/lib/menu-xdg/ > > > > XDG_MENU_PREFIX=lxde- > > > > XDG_SEAT_PATH=/org/freedesktop/DisplayManager/Seat0 > > > > > > > > > > > > > > XDG_SESSION_COOKIE=c87a744d1d6f8f10324c61480000000a-1464403096.168554-1750800897 > > > > XDG_SESSION_PATH=/org/freedesktop/DisplayManager/Session0 > > > > _LXSESSION_PID=1709 > > > > > > > > > > > > > > > > > > > > > > > > > > ------------------------------------------------------------------------------ > > > > What NetFlow Analyzer can do for you? Monitors network bandwidth and > > > > traffic > > > > patterns at an interface-level. Reveals which users, apps, and > > protocols > > > > are > > > > consuming the most bandwidth. Provides multi-vendor support for > > NetFlow, > > > > J-Flow, sFlow and other flows. Make informed decisions using capacity > > > > planning reports. > > > https://ad.doubleclick.net/ddm/clk/305295220;132659582;e > > > > _______________________________________________ > > > > Gambas-user mailing list > > > > Gambas-user@lists.sourceforge.net > > > > https://lists.sourceforge.net/lists/listinfo/gambas-user > > > > > > > > > > > > > ------------------------------------------------------------------------------ > > > What NetFlow Analyzer can do for you? Monitors network bandwidth and > > > traffic > > > patterns at an interface-level. Reveals which users, apps, and > protocols > > > are > > > consuming the most bandwidth. Provides multi-vendor support for > NetFlow, > > > J-Flow, sFlow and other flows. Make informed decisions using capacity > > > planning reports. > > https://ad.doubleclick.net/ddm/clk/305295220;132659582;e > > > _______________________________________________ > > > Gambas-user mailing list > > > Gambas-user@lists.sourceforge.net > > > https://lists.sourceforge.net/lists/listinfo/gambas-user > > > > > > > > > > ------------------------------------------------------------------------------ > > What NetFlow Analyzer can do for you? Monitors network bandwidth and > > traffic > > patterns at an interface-level. Reveals which users, apps, and protocols > > are > > consuming the most bandwidth. Provides multi-vendor support for NetFlow, > > J-Flow, sFlow and other flows. Make informed decisions using capacity > > planning reports. > https://ad.doubleclick.net/ddm/clk/305295220;132659582;e > > _______________________________________________ > > Gambas-user mailing list > > Gambas-user@lists.sourceforge.net > > https://lists.sourceforge.net/lists/listinfo/gambas-user > > > > > > ------------------------------------------------------------------------------ > What NetFlow Analyzer can do for you? Monitors network bandwidth and > traffic > patterns at an interface-level. Reveals which users, apps, and protocols > are > consuming the most bandwidth. Provides multi-vendor support for NetFlow, > J-Flow, sFlow and other flows. Make informed decisions using capacity > planning reports. https://ad.doubleclick.net/ddm/clk/305295220;132659582;e > _______________________________________________ > Gambas-user mailing list > Gambas-user@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/gambas-user > ------------------------------------------------------------------------------ What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic patterns at an interface-level. Reveals which users, apps, and protocols are consuming the most bandwidth. Provides multi-vendor support for NetFlow, J-Flow, sFlow and other flows. Make informed decisions using capacity planning reports. https://ad.doubleclick.net/ddm/clk/305295220;132659582;e _______________________________________________ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user