I have a simple questions.
With the SQL entities I am able to show fields or field rowns or layouts of any table of the database.
But how can I edit the fields of each row or how can I edit a complete row of fields like in a formular?
Is there any sql query in cck to do it?

Hello. At the moment there is no way to edit sql entities using CCK. This is a very complex process and it's hard to predict when it will be added and if it will be added at all.

SQL entity in OS [https://ordasoft.com/cck-content-construction-kit-for-joomla.html=]Joomla CCK[/url] - created only for SHOW any data which you have in database.

exactly as you did for show report. - ordinary these data which imported from other site. Or data which created with other interface.

as example - there you may show Joomla Users or Joomla Articles - in view as you need. And there you may create search for these data.

BUT because SQL request may have a lot source tables - edit it VERY difficult task

Regards
Ordasoft team