On Mon, Oct 22, 2018 at 1:17 AM Benoît Minisini <g4m...@gmail.com> wrote: > > Le 22/10/2018 à 00:43, Markus Schatten a écrit : > > Dear all, > > > > I'm having a weird "Out of bounds" error in the DataBrowser. I'm using > > the DataBrowser with a PostgreSQL database to edit tables. The error > > occurs only if I add a new row (with a click on the empty row), enter > > data for a few columns, then go back to edit some previous column and > > then press enter to store the whole row. > > > > For example if I have the following table: > > > > table | Col A | Col B | Col C > > ---------------------------------- > > > > And enter data in a new row, say: > > > > > > table | Col A | Col B | Col C > > ---------------------------------- > > Val 1 | Val 2 | Val 3 > > > > Then (before storing the row) go back to edit say Col A: > > > > table | Col A | Col B | Col C > > ---------------------------------- > > Val 4 | Val 2 | Val 3 > > > > An then move to Col C and press enter to store the row I get an Out of > > Bounds Error. Weirdly, the row gets stored in the table, but the app > > crashes... > > > > What am I doing wrong? > > [...] > > Can you send a dump of your database? Not all the contents, but at least > the table definition. > Sorry for the delay. It happens with any table I use, regardless of definition if it has more than two editable columns. It actually happened on multiple occasions in a class of students where each student had his/her own database with different table definitions. Here is an example where it happens:
CREATE TABLE person ( email TEXT PRIMARY KEY, first TEXT NOT NULL, last TEXT NOT NULL, country TEXT, city TEXT, sex VARCHAR( 6 ) ); All the best, M. _______________________________________________ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user