PDA

View Full Version : Creating table goes wrong if no index created



LeonRaafs
4-Jun-2015, 03:04 AM
Hi all,

I was creating a table thru the database builder. After defining the fields I forgot to create a index and tried to save the table. This results in a error and crash of the database builder, after wich the table has to be defined all over again.

Kind regards,

Leon Raafs

Stephen W. Meeley
4-Jun-2015, 06:35 AM
Leon,

Can you send a .def file of the table so we can reproduce?

LeonRaafs
9-Jun-2015, 01:35 AM
Hi Stephen,

Sorry for the late reaction, must have mist it. There was no .def involved, I created a table from scratch. Nothing fancy, I did not have the idea it had something to do with the fields, just with the missing index. I tried to reproduce but to no availe. If this happens again I let you know.

Regards,

Leon Raafs

IJmert
9-Jun-2015, 05:32 AM
This always happens if you forget to define an index on SQL Tables. The studio tries to create the table but gets an SQL error that this is not possible without an index. You don't get the warning that you' have forgotten something.

Hans van de Laar
9-Jun-2015, 08:23 AM
I've noticed the same behaviour