× 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

Can I use mysql views with Joodb

More
9 years 2 weeks ago #3264 by GuiGuy
Can I use mysql views with Joodb was created by GuiGuy
I complains about the lack of a a primary key?

Thanks

Please Log in to join the conversation.

More
9 years 1 week ago - 9 years 1 week ago #3272 by Mia
Replied by Mia on topic Can I use mysql views with Joodb
Yes, if you modify the code. See here .
Last edit: 9 years 1 week ago by Mia.

Please Log in to join the conversation.

More
9 years 1 week ago #3274 by Dirk
Replied by Dirk on topic Can I use mysql views with Joodb
Why don't you crate a Primary Key?
I Guess you can also use a String-Collumn as ID but it must be unique like an alias.

Please Log in to join the conversation.

More
9 years 5 days ago #3275 by GuiGuy
Replied by GuiGuy on topic Can I use mysql views with Joodb
How is a key created in a view? I thought the view is derived from existing tables?

Please Log in to join the conversation.

More
9 years 4 days ago #3277 by Mia
Replied by Mia on topic Can I use mysql views with Joodb

GuiGuy wrote: How is a key created in a view? I thought the view is derived from existing tables?

You're right - so far as I'm aware you can't create a key in a view.

Please Log in to join the conversation.

Moderators: Dirkjoest