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
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.