Hi,
Instead of linking tables in CC definition of the data grid I defined a view in MySQL database.
That way the connection is quite simple...
But as a result I've got the message:
This table has no primary keys and its records can't be viewed!
I couldn't define primary index on view itself though some field in it has got the primary key on source table.
Is there any way to use SQL views with CC ?
Where lays this limitation reason?
Henryk
Instead of linking tables in CC definition of the data grid I defined a view in MySQL database.
That way the connection is quite simple...
But as a result I've got the message:
This table has no primary keys and its records can't be viewed!
I couldn't define primary index on view itself though some field in it has got the primary key on source table.
Is there any way to use SQL views with CC ?
Where lays this limitation reason?
Henryk
Hi Henryk,
Some Joomla DB features may only work with an indexed table, you should be able to browse a list of your view records, that should be okay, but I have disabled it because it would cause confusion and you wouldn't be able to delete/update your table/view records.
but I will try to experiment with this and see what I can do, could you please drop me a message through the "Contact Us" page and I will try to send you a patch file for that ? I can only promise that you may be able to list the data, anything else is not guaranteed!
Regards,
Max
Some Joomla DB features may only work with an indexed table, you should be able to browse a list of your view records, that should be okay, but I have disabled it because it would cause confusion and you wouldn't be able to delete/update your table/view records.
but I will try to experiment with this and see what I can do, could you please drop me a message through the "Contact Us" page and I will try to send you a patch file for that ? I can only promise that you may be able to list the data, anything else is not guaranteed!
Regards,
Max
This topic is locked and no more replies can be posted.
