Message
From
16/03/2010 17:36:43
To
16/03/2010 17:07:03
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:
01454961
Views:
33
>>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.
>>
>>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.