Tables not created as text tables in Base?

[Damascene]

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:
Table not found in statement (View topic) • Apache OpenOffice Community Forum

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

[PYS]

Hi

Try:

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

Regards

[Damascene]

Thank you, That was really easy and worked