Hi Nick Thomas,
It is not possible to leave Id alone when we put Select * as it is also part of table. The only option you have with OQL is Mention every column.
And one more thing note as well, You should use OQL to Only Display data in a page, since if you closely Notice, all the objects that are returned from OQL are new Objects and have a new Id Value, So all the association which you have with the original values will be empty.
Just curious to know what you are trying to achieve, lets see if you can Do it by not using OQl.
Thanks,
Dinesh
“I want to have a page where a list of Employees is shown in a DataGrid and when you click on a row that a new page opens with all Employee details. On this page you should also be able to change the details.”
This should be default datagrid functionality. Just place an action button on the grid controlbar, select a page Employee_NewEdit and voila set ‘default action’ in the properties of the button.