Your picture of the SQL statement is missing an operator -- your expression after WHERE is malformed.
--- The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume. >-----Original Message----- >From: sqlite-users [mailto:sqlite-users- >boun...@mailinglists.sqlite.org] On Behalf Of Amno Jeeuw >Sent: Friday, 7 September, 2018 18:49 >To: SQLite >Subject: [sqlite] sql UPDATE schema > > I have a database table named company that looks like this: > db_snapshot2.png ><https://drive.google.com/file/d/1Fl3gWAqbP029iPdtSJ24hXx5GR54GlF0/vi >ew?usp=drive_web> > >When the application is asked to change the value of ArbolOne to >ArbolOn > db_snapshot1.png ><https://drive.google.com/file/d/1sJu4fH9q816ygCxJ_0QMzMxt1j- >DTq8D/view?usp=drive_web> > > >the application generates the following schema represented on this >message >box: > db_snapshot3.png ><https://drive.google.com/file/d/1fGF0osBeOGXxPBGJKhq4TSk0ip8lyl5K/vi >ew?usp=drive_web> > >which produces this Exception error: > db_snapshot4.png ><https://drive.google.com/file/d/1xKOpy88KWhg- >8DzKjqPrqd5nTOQIRgYV/view?usp=drive_web> > >I am attaching a snip of the code, in case you'd like to know it. >Having said that, I'd like to know if this is a bug or if I have not >understand the information found in here ><https://www.tutorialspoint.com/jdbc/jdbc-update-records.htm>. > >Any help would be much appreciated. > >*ArbolOne >Using Fire Fox and Thunderbird. >Developing for Android using Java, C/C++, HTM/CSS and JS as our >platform has been exciting and most rewarding. >[ Sí ]* >_______________________________________________ >sqlite-users mailing list >sqlite-users@mailinglists.sqlite.org >http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
