× If you expect answers you should describe your problem and give as much information's as possible. (SQL-Structure, Template Code, Joomla Version ...) Please read this before posting: joodb.feenders.de/support.html

Show data from database view

More
7 years 10 months ago #3883 by tdobe
Show data from database view was created by tdobe
Hello,

Why can not I show data from a database view ? ( Error : The table has no primary index. Pleas define a ID field using PhpmyAdmin. ) - after all, it is a basic option for displaying data ( data manipulation )?


Why I can not specify a primary key by hand?

Tomek

Please Log in to join the conversation.

More
7 years 10 months ago #3884 by Dirk
Replied by Dirk on topic Show data from database view
JooDB also allows to add, edit or remove data. Therefore every table needs a PRIMARY KEY. This is usually a UNIQUE integer field to identify a database entry.

No serious Database tool would allow you to use a table without.

Use phpmyadmin or whatever and add a primary key flag to a unique field or insert a auto index.

Please Log in to join the conversation.

More
7 years 10 months ago #3885 by tdobe
Replied by tdobe on topic Show data from database view
clearly , I wrote that I mean the display of data and not about editing - that's why I write about the view and not a table !

Please Log in to join the conversation.

Moderators: Dirkjoest