[Gambas-user] [Gambas Bug Tracker] Bug #926: want to edit a record, it's change the other record

Sun Jun 5 11:16:01 CEST 2016

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.ilmi at ...626...>:

> you can extract project into /tmp directory (attach project)
>
> On Sat, May 28, 2016 at 3:50 PM, Jorge Carrión <shordi at ...626...> wrote:
>
> > It will be intersting take a look to your database structure...
> >
> > Regards
> >
> > 2016-05-28 5:24 GMT+02:00 <bugtracker at ...3416...>:
> >
> > > 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 at 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 at 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 at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/gambas-user
>
>