How to use CREATE TABLE queries in LibreOffice Base?
I'm using LibreOffice 3.5.4.2 (from Ubuntu 12.04 packages) and trying to create tables using SQL's CREATE TABLE statement. For the first few attempts I got a message saying that the query must be a SELECT query. I changed the query and made it extremely simple:
CREATE TABLE moo3 (id_1 INT, name_1 VARCHAR(255));
Now the query seems to be executed, returning no results, but I can't find the table in Base's GUI. Is it a bug or am I doing it wrong?
ubuntu sql libreoffice-base
edited Mar 9 '13 at 18:40
wonea
1,48211940
asked Oct 20 '12 at 14:15
Shlomi LoubatonShlomi Loubaton
11125
add a comment |
I'm using LibreOffice 3.5.4.2 (from Ubuntu 12.04 packages) and trying to create tables using SQL's CREATE TABLE statement. For the first few attempts I got a message saying that the query must be a SELECT query. I changed the query and made it extremely simple:
CREATE TABLE moo3 (id_1 INT, name_1 VARCHAR(255));
Now the query seems to be executed, returning no results, but I can't find the table in Base's GUI. Is it a bug or am I doing it wrong?
ubuntu sql libreoffice-base
edited Mar 9 '13 at 18:40
wonea
1,48211940
asked Oct 20 '12 at 14:15
Shlomi LoubatonShlomi Loubaton
11125
add a comment |
I'm using LibreOffice 3.5.4.2 (from Ubuntu 12.04 packages) and trying to create tables using SQL's CREATE TABLE statement. For the first few attempts I got a message saying that the query must be a SELECT query. I changed the query and made it extremely simple:
CREATE TABLE moo3 (id_1 INT, name_1 VARCHAR(255));
Now the query seems to be executed, returning no results, but I can't find the table in Base's GUI. Is it a bug or am I doing it wrong?
ubuntu sql libreoffice-base
edited Mar 9 '13 at 18:40
wonea
1,48211940
asked Oct 20 '12 at 14:15
Shlomi LoubatonShlomi Loubaton
11125
I'm using LibreOffice 3.5.4.2 (from Ubuntu 12.04 packages) and trying to create tables using SQL's CREATE TABLE statement. For the first few attempts I got a message saying that the query must be a SELECT query. I changed the query and made it extremely simple:
CREATE TABLE moo3 (id_1 INT, name_1 VARCHAR(255));
Now the query seems to be executed, returning no results, but I can't find the table in Base's GUI. Is it a bug or am I doing it wrong?
ubuntu sql libreoffice-base
ubuntu sql libreoffice-base
edited Mar 9 '13 at 18:40
wonea
1,48211940
asked Oct 20 '12 at 14:15
Shlomi LoubatonShlomi Loubaton
11125
edited Mar 9 '13 at 18:40
wonea
1,48211940
asked Oct 20 '12 at 14:15
Shlomi LoubatonShlomi Loubaton
11125
edited Mar 9 '13 at 18:40
wonea
1,48211940
edited Mar 9 '13 at 18:40
wonea
1,48211940
edited Mar 9 '13 at 18:40
wonea
1,48211940
1,48211940
asked Oct 20 '12 at 14:15
Shlomi LoubatonShlomi Loubaton
11125
asked Oct 20 '12 at 14:15
Shlomi LoubatonShlomi Loubaton
11125
asked Oct 20 '12 at 14:15
Shlomi LoubatonShlomi Loubaton
11125
11125
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
You need to View/Refresh Tables to see the change. If you want to keep the lower case field names, you need to quote the them (at least in the embedded database SQL tool). And I realize that this is just a test, but you need to have a primary key field defined in order to enter data from the GUI. You could get data into the table other ways.
answered Mar 1 '13 at 1:05
W_WhalleyW_Whalley
3,09711115
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f490330%2fhow-to-use-create-table-queries-in-libreoffice-base%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
You need to View/Refresh Tables to see the change. If you want to keep the lower case field names, you need to quote the them (at least in the embedded database SQL tool). And I realize that this is just a test, but you need to have a primary key field defined in order to enter data from the GUI. You could get data into the table other ways.
answered Mar 1 '13 at 1:05
W_WhalleyW_Whalley
3,09711115
add a comment |
You need to View/Refresh Tables to see the change. If you want to keep the lower case field names, you need to quote the them (at least in the embedded database SQL tool). And I realize that this is just a test, but you need to have a primary key field defined in order to enter data from the GUI. You could get data into the table other ways.
answered Mar 1 '13 at 1:05
W_WhalleyW_Whalley
3,09711115
add a comment |
You need to View/Refresh Tables to see the change. If you want to keep the lower case field names, you need to quote the them (at least in the embedded database SQL tool). And I realize that this is just a test, but you need to have a primary key field defined in order to enter data from the GUI. You could get data into the table other ways.
answered Mar 1 '13 at 1:05
W_WhalleyW_Whalley
3,09711115
You need to View/Refresh Tables to see the change. If you want to keep the lower case field names, you need to quote the them (at least in the embedded database SQL tool). And I realize that this is just a test, but you need to have a primary key field defined in order to enter data from the GUI. You could get data into the table other ways.
answered Mar 1 '13 at 1:05
W_WhalleyW_Whalley
3,09711115
answered Mar 1 '13 at 1:05
W_WhalleyW_Whalley
3,09711115
answered Mar 1 '13 at 1:05
W_WhalleyW_Whalley
3,09711115
answered Mar 1 '13 at 1:05
W_WhalleyW_Whalley
3,09711115
3,09711115
add a comment |
add a comment |
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f490330%2fhow-to-use-create-table-queries-in-libreoffice-base%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
