distal-attribute
distal-attribute
distal-attribute
distal-attribute

not inserting in database table

gilgal posted 6 years ago in General
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.')

Dr. Dave posted 6 years ago
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.
ansgar posted 6 years ago

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.
gilgal posted 6 years ago

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?
ansgar posted 6 years ago
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?

Dr. Dave posted 6 years ago
hmm.. my assumption was he was trying to INSERT data yet was unsuccessful. s'pose I was wrong. Ignore my above post then.
gilgal posted 6 years ago

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.