[Solved] Error while creating a table with SQL commands

[Kartik Pachlodkar]

To,
all members

It is to inform you all that while executing the SQL command for creating a table, an error is being shown that "The query can not be executed. It is too complex." but the syntax of every statement is correct and then also it is displaying an error.

Please help me if you can as i have tried a lot of times but have not gotten it. it has made me like this - .

Please help me "ASAP"

Thanks

Kartik Pachlodkar

Enclosed: image displaying the error named as "1"

Edit: Please do not write in all capitals. This is considered "shouting" at us.   Make your post understandable by others  -- MrProgrammer, forum moderator

[charlie.it]

HI, I try your SQL command, it works for me, without errors.

[FJCC]

I executed the following query successfully.

Code: Select all

CREATE TABLE "STUDENTS' GRADES" 
(
"NAME" VARCHAR(30),
"MARKS" NUMERIC(2)
);

I used the standard HSQLDB embedded database. Are you using an embedded database or something else?

[Kartik Pachlodkar]

Hi,

Thanks for replying first of all!

But I don't have any standard HSQLDB-embedded database to use. Can you please tell me how can I use it???

Thanks

[FJCC]

If you are using the standard embedded data base engine, you will see text at the bottom of the Base window that is like the attached image.
Please explain the exact steps you took to make this Base document. You probably started with the menu File -> New -> Database. What steps did you take after that?

Embedded_DB.JPG (21.43 KiB) Viewed 5076 times

[UnklDonald418]

Also be aware that the table you are attempting to create won't be very useful. Without a Primary Key you won't be able to type any data into that table. That could be remedied by

Code: Select all

CREATE TABLE "STUDENTS' GRADES" 
(
"ID" Integer GENERATED BY DEFAULT AS IDENTITY NOT NULL PRIMARY KEY,
"NAME" VARCHAR(30),
"MARKS" NUMERIC(2)
);