Message
From
16/03/2010 17:41:17
To
16/03/2010 17:36:43
General information
Fórum:
Visual FoxPro
Category:
Bases de dados, Tabelas, Views, Indices e SQL
Título:
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
ID da thread:
01454946
ID da mensagem:
01454963
Views:
25
>>>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.
>>>
>>>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.