Regarding creations of weak entity type

Classic Servoy
1

weak entity types are entities that don’t have any primary keys defined over the entity.

when i am going to create a weak entity type(table).

In servoy, it automatically creat a “entityname_id” field and set that to primary key of that table.

but, i changed that name and checked the “allow null” field, and add other fields.

but, it is showing a error primary key is not defined over the table, and hence cann’t be created.

can we create a weak entity type in servoy? :?:

2

Servoy needs a unique key for each row, which normally is the pk, but you can specify a column as custom row ident afterwards if you do not have a pk

3

As Jan Blok stated Servoy needs a unique key column per table it accesses.

And yes you can create tables via Servoy Developer but I strongly advice you to use a DBA tool that comes with your back-end database. It will give you much more control like changing datatypes after you created them, etc.

Hope this helps.