Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
>>>>I have one problem, and I am not sure what is it.
>>>>
>>>>I have one local view that is updatable and it's working fine.
>>>>Then I decided to add one field to local view and suddenly view isn't working!
>>>>
>>>>Message is Cannot insert an empty row from a view into its base table(s) (Error 1547).
>>>>
>>>>Can someone help me what is the problem?
>>>
>>>Did you add a field from another table?
>>>
>>>Can you post your view code?
>>
>>No, there are two tables in view, with inner join and one order field.
>>I just add one more field from one of two tables already in view.
>>
>>I have also try, for example, to delete existing field from view, and also get same error message.
>>
>>It seems that modification of view ruins it.
>
>You need to make sure that only one table's fields are made updatable.
It is already, like I said, everything worked fine till now.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement