Is it possible to right click on a field and set it to be a
primary key..
This would make it Not null and add it as a contraint in
one shot.
There might also be a way of creating the whole
Generator etc in one ;-)
Maybe a new datatype, eg AUTOINCREMENT, which when added to
a table results in dialog comming up asking for the
generator, trigger name and real datatype (default
numeric(18,0)??). The names should default to something like
GEN_tableName_columnName and
TRIG_INSERT_INC_tableName_columnName.
User should be able to default prefixes, and datatype and
initial value.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Logged In: YES
user_id=61098
Maybe a new datatype, eg AUTOINCREMENT, which when added to
a table results in dialog comming up asking for the
generator, trigger name and real datatype (default
numeric(18,0)??). The names should default to something like
GEN_tableName_columnName and
TRIG_INSERT_INC_tableName_columnName.
User should be able to default prefixes, and datatype and
initial value.
Logged In: YES
user_id=152149
Hi,
good idea. It will be included in one of the next snapshots.
Regards,
Tilo Muetze
Logged In: YES
user_id=152149
Yes I thought about something like this. Thanks again for
your hints.