Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Cannot insert empty row (CA problem)
Message
 
 
À
03/10/2006 14:42:43
Information générale
Forum:
Visual FoxPro
Catégorie:
Problèmes
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP
Database:
Visual FoxPro
Divers
Thread ID:
01159031
Message ID:
01159052
Vues:
30
>>Hi everybody,
>>
>>We're getting an intermittent error 1547
>>"Cannot insert an empty row from a view or CursorAdapter into its base table(s).". It happens ~ once in 15 or more normal inserts. Where do you think should I look for this problem and what can I do?
>>
>>Thanks in advance.
>
>Here the description of the error:
>
>
>While a view is updating, a new empty record (with no modified fields) is being inserted into one of the base tables of the view.
>
>Make sure each record inserted from a view into a base table has at least one field that has been modified in the view prior to
>the view update.
>
>Are you sure you don't have somewhere an APPEND BLANK w/o any REPLACE after it?

I was able to reproduce the problem. I added a new Carrier Branch first without a phone. Then I added a phone and got this error. The Error method of CA baseclass didn't fire, but rather Form's Save method produced an error. I'm going to dig further.
If it's not broken, fix it until it is.


My Blog
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform