CRUD issues


#1

Hello,
I am having a problem creating CRUD pages - they do not save. Also, it seems that if I try to create CRUD pages for a view, it doesn't create the add and delete functionality. If I create it myself, I still cannot get things to save data into the database.
What things can I look for to diagnose this?
Is there a reason that views do not get properly created CRUD pages?
How can I get the save button to do something useful?

Thanks


#2

Hi @markl,

Radzen will create read-only pages for SQL views since there are no primary keys and CRUD cannot be supported.

Best Regards,
Vladimir


#3

Ok, so to use CRUD, the page must have a primary key.
If you have a view with three tables and they all have primary keys would it work in that condition?
Why wouldn't the save button work on created CRUD pages for tables with keys?
How would I build a CRUD page that will save for a view?
Thanks


#4

Hi @markl,

I’m afraid that you cannot have CRUD for SQL views since they are read-only by definition.

Best Regards,
Vladimir