Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
View problem after modify
Message
From
16/03/2010 17:45:02
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01454946
Message ID:
01454964
Views:
26
>>>>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform