not inserting in database table

User, date Message
Written by gilgal
5 years ago
Category: General
32 posts since Wed, 12 Dec 07 		Not inserting... or I don't know.
On top of the empty database table:
kjv.bible: 60 records total, 0 matching to filter

wrote: 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.')
Written by Dr. Dave
5 years ago
95 posts since Sun, 27 Jan 08 		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.
Written by ansgar
5 years ago
3950 posts since Fri, 07 Apr 06

gilgal wrote: 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.
Written by gilgal
5 years ago
32 posts since Wed, 12 Dec 07

anse wrote:

gilgal wrote: 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?
Written by ansgar
5 years ago
3950 posts since Fri, 07 Apr 06 		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?
Written by Dr. Dave
5 years ago
95 posts since Sun, 27 Jan 08 		hmm.. my assumption was he was trying to INSERT data yet was unsuccessful. s'pose I was wrong. Ignore my above post then.
Written by gilgal
5 years ago
32 posts since Wed, 12 Dec 07

anse wrote: 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
 

Please login to leave a reply, or register at first.