not inserting in database table

Not inserting... or I don't know.
On top of the empty database table:
kjv.bible: 60 records total, 0 matching to filter

INSERT INTO bible (id) VALUES ('In the beginning God created the heaven and the earth.')
INSERT INTO bible (book) VALUES ('In the beginning God created the heaven and the earth.')
INSERT INTO bible (book_spoke) VALUES ('In the beginning God created the heaven and the earth.')
INSERT INTO bible (recordType) VALUES ('In the beginning God created the heaven and the earth.')
INSERT INTO bible (book_title) VALUES ('In the beginning God created the heaven and the earth.')
INSERT INTO bible (chapter) VALUES ('In the beginning God created the heaven and the earth.')
INSERT INTO bible (chapter_spoke) VALUES ('In the beginning God created the heaven and the earth.')
INSERT INTO bible (verse) VALUES ('In the beginning God created the heaven and the earth.')
INSERT INTO bible (verse_spoke) VALUES ('In the beginning God created the heaven and the earth.')
INSERT INTO bible (text_data) VALUES ('In the beginning God created the heaven and the earth.')

First, what are the DATA TYPES for your fields? For instance:

INSERT INTO bible (id) VALUES ('In the beginning God created the heaven and the earth.');

If (id) is an integer type, then ('In the beginning God created the heaven and the earth.') of course will not work.


At best guess, are you trying to do this: ?

INSERT INTO bible (id) VALUES (1);
INSERT INTO bible (book) VALUES (1);
INSERT INTO bible (book_spoke) VALUES ('Genesis');
INSERT INTO bible (recordType) VALUES ('Verse');
INSERT INTO bible (book_title) VALUES ('Genesis Chapter I');
INSERT INTO bible (chapter) VALUES (1);
INSERT INTO bible (chapter_spoke) VALUES ('Chapter I.');
INSERT INTO bible (verse) VALUES (1);
INSERT INTO bible (verse_spoke) VALUES ('Verse 1');
INSERT INTO bible (text_data) VALUES ('In the beginning God created the heaven and the earth.');

I'm just guessing.

kjv.bible: 60 records total, 0 matching to filter

You have an active WHERE filter which is the cause you're seeing 0 rows(just like the info label says). Just remove the filter and you'll see all rows.

kjv.bible: 60 records total, 0 matching to filter

You have an active WHERE filter which is the cause you're seeing 0 rows(just like the info label says). Just remove the filter and you'll see all rows.

Where do I go to remove the filter?

Depends on which version/revision you're using.

Original 3.2 version:
See the tab "Filter" in the very bottom pagecontrol where the SQL log also resides

Nightly build since r1591:
Click the "Filter" button above the data grid so the filter editor gets visible directly below it. Whereas this is done automatically if you have applied a filter previously for the relevant table... so my guess is you are at 3.2 right?

hmm.. my assumption was he was trying to INSERT data yet was unsuccessful. s'pose I was wrong. Ignore my above post then.

Depends on which version/revision you're using.

Original 3.2 version:
See the tab "Filter" in the very bottom pagecontrol where the SQL log also resides

Nightly build since r1591:
Click the "Filter" button above the data grid so the filter editor gets visible directly below it. Whereas this is done automatically if you have applied a filter previously for the relevant table... so my guess is you are at 3.2 right?

Ok I cleared it. Yes 3.2