Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Error 1547
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Problèmes
Titre:
Divers
Thread ID:
00521182
Message ID:
00521196
Vues:
18
>>Hi everyone,
>>
>>I want to create an empty record, if there is no record in the base table. I use view. I got this error: Cannot insert an empty row from a view into its base table(s) (Error 1547)
>>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.

>>
>>On this code segment:
>>
>>dodefault()
>>lnCustomerID=oJC.CustID
>>select CustomerInfo
>>requery()
>>if reccount()=0
>>   append blank
>>   replace CustomerID with m.lnCustomerID
>>   set step on
>>   thisform.dotableupdate()
>>   requery()
>>endif
>>select RegionsInfo
>>requery()
>>if reccount()>0
>>   lnRegionID=RegionInfo.RegionID
>>   select TownsInfo
>>   requery()
>>endif
>>set status bar on
>>set message to "Create a custom report configuration..."
>>
>>How can I insert a blank record into the view?
>>
>>Thanks in advance.
>
>Use an SQL Insert, populating the necessary field(s).

Thank you. For some reason, I always forgot about it... May be because our framework uses APPEND BLANK...

I found problem. My Table (and view) didn't contain field UserID, but has a Table rule with UpdateUserID()...

Now it works. Thanks again.
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