How to update an element list from a list created by a SQL View?

[jmdc]

Hello,

As i said, do you think it?s possible to update an element list in a list created from a SQL View?

I have tried it and i receive this message:

Erreur
Can not modify more than one base table through a join view 'inscri_bdlfcl.Facturacao' SQL=UPDATE `Facturacao` SET `Nome_completo`='ASSS',`NomeCompletoFiliacao`='M?E Fran?',`DebitarFacturas`='1',`FraisScolarite`='85' WHERE Userid='135'

Could you help me, please?

Thank you.

 

[cheesegrits]

No, you can't. MySQL views are "read only", for all intents and purposes. Fabrik lists built on views should be used only for display / reporting purposes, you can't submit data through them.

-- hugh

 

[cheesegrits]

What I typically do if I need to edit data from a list I've built on a view is to use a custom link on the list, pointing to a form which resides on the list for the requisite table I built the view from. Isn't always workable, depending on what your view does, but most of the time it's a solution.

-- hugh