Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
View problem after modify
Message
De
16/03/2010 17:45:02
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Database:
Visual FoxPro
Divers
Thread ID:
01454946
Message ID:
01454964
Vues:
27
>>>>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
Fil
Voir

Click here to load this message in the networking platform