Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Uncommited changes error
Message
 
À
30/11/2005 00:39:25
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
01072879
Message ID:
01073120
Vues:
28
>the uncommited changes error because of the delete statement:
>
>DELETE FOR pk=findpk in vtemp
>DELETE FOR fk=findpk IN vtempdetail
>thisform.addnew
>
>if I remove the delete code, I won't get error message.
>
>any suggestion?
>
>thanks for the help
>
>regards,
>
>Jerry

It is hard to me to give you proper advise. I don't know what Buffering mode you use (I suppose it is Row Buffering, but I am not sure). What are these tables? Only temporary tables that you use for showing data or they are Views or CAs wich you use for manage DataBase Tables?
If these temp tables (cursors) are Views/CAs what do you want to happens with deleted records? To be deleted in Actual table or you want just to desapear from your Temp Table?
DELETE FOR pk=findpk in vtemp
DELETE FOR fk=findpk IN vtempdetail

*** Update tables before you trying to add a new record
*** Don't do that if these cursors are Views/CAs and you don't want to delete records from 
*** real table
TableUpdate(1,.t.,"vtemp")
TableUpdate(1,.t.,"vtempdetail")

thisform.addnew
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform