[Solved] Error while creating a table with SQL statements

[Kartik Pachlodkar]

To,
All members

Subject - Error while creating a table with SQL

Hi,
I tried to create a new table using SQL statements in OpenOffice Base. But, if I execute it, it displays an error like this - "The query cannot be executed. It is too complex". Please help me with this problem.

It displays an error like this.

A.jpg (46.92 KiB) Viewed 3206 times

Thanks

[Mountaineer]

I never tried to use the sql-command window for this, as it can easily be done in the Tables-View of the GUI.

Two points to check first: What kind of database are you editing? HSQLDB embedded or something else?

Have you tried to use a name without special chars like '
I'm not sure, if this is valid as ' has its own special use in SQL. (And of habit I never try my luck with this kind of chars.) So try to create STUDENTS first.

[Villeroy]

I always use the SQL window for this, sometimes together with a text edtior having some CREATE skeletons as templates.
Avoid lengthy names with special characters. The apostrophe marks literal strings. It should not appear in an object name. You can give meaningful labels to your objects in the user interface (forms and reports).

The following works well without any quoting

Code: Select all

create table sg(
n varchar(30),
m numeric(2)
)

HSQL creates a table SG with columns N and M.

[Kartik Pachlodkar]

I tried again as you said, but still, it displays the same error. Please help me with this problem.

[UnklDonald418]

I've seen weirdness like that when using an Embedded Base database.
I've never been able to track down the cause but the solution has been to create a new database and copy everything to it from the malfunctioning .odb file.

[Villeroy]

Create_Table.png (31.69 KiB) Viewed 2944 times

[Kartik Pachlodkar]

I am really thankful to all who helped me with this problem. Now I am able to create tables with SQL statements without any errors. Thank You!