Ask Your Question
0

Tables not created as text tables in Base? [closed]

asked 2015-12-30 22:08:09 +0100

Damascene gravatar image

Hi, I was trying to get a simple SQL statement to work from Tools >> SQL .. like this:

INSERT INTO Table1 (Name, Type, Date) VALUES('m1', 'Server', NOW());

But I get:

1: Table not found in statement [INSERT INTO Table1]

When I searched I found someone saying that:

Your table in database is not a TEXT table. You probably created in design view. You needs to create "contacts" table, in Tools>SQL... command window: https://forum.openoffice.org/en/forum...

So is it a bug? Is there any solution to this issue?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by pierre-yves samyn
close date 2016-05-02 09:15:21.999553

1 Answer

Sort by » oldest newest most voted
0

answered 2015-12-31 16:25:35 +0100

pierre-yves samyn gravatar image

Hi

Try:

INSERT INTO "Table1" ("Name", "Type", "Date") VALUES('m1', 'Server', NOW());

Regards

edit flag offensive delete link more

Comments

Thank you, That was really easy and worked :)

Damascene gravatar imageDamascene ( 2016-01-01 09:42:38 +0100 )edit

Question Tools

1 follower

Stats

Asked: 2015-12-30 22:08:09 +0100

Seen: 512 times

Last updated: Dec 31 '15