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

Sun Jun 5 12:01:02 CEST 2016

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 <shordi at ...626...> 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.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
> >
> >
>
> ------------------------------------------------------------------------------
> 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
>