Information générale
Catégorie:
The Mere Mortals Framework
No, I'm sorry. I meant delete it and re-create it. If it's a complex view, view the SQL code and copy and paste it into a program file and then re-create it using the create view command.
>Thanks.
>
>By "drop and re-add", you mean remove the view from the project, and then re-create it?
>
>June
>
>>June,
>>
>>I get this often. And the way I always solve it, is by dropping the view and re-adding it. I know this doesn't answer 'why' it is happening, but as I have mentioned before to you, there are times when finding the answers why is not so important.
>>
>>>Thanks for the suggestion.
>>>
>>>I did have some of table 2's fields interspersed with those of table 1 in the view, and corrected that, but I'm still getting the 1547.
>>>
>>>June
>>>
>>>>Hi,
>>>>Make sure your view's updatable fields is not seperated by any non-updateable field. For example, table1 is the source you want to update:
>>>>
>>>>**This should work fine
>>>>View : MyView
>>>>Selected Field List : MyTable1.Field1, MyTable1.Field2, MyTable2.Field1
>>>>
>>>>**This may cause error 1547
>>>>View : MyView
>>>>Selected Field List : MyTable1.Field1, MyTable2.Field1, MyTable1.Field2
>>>>
>>>>HTH
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