Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
I DEFINITELY see your point and agree (and will be sure to do it that way from now on) ...but do you see why this would have failed (I don't see it)? Thanks.
USE IN cCkName
SELECT lv_agenciesupdate
IF !lOK
IF !lFoundAbbrev AND !lFOundName
=TableRevert( )
ENDIF
ELSE
** check for changes
IF !TableUpdate( 0, .F. ) && write changes - detect if someone else made a change
=TABLERevert( )
WAIT WINDOW cUpdateFailed + " - " + cOtherUpdate + cNewLine + "Try again"
=REQUERY( "LV_AgenciesUpdate" )
.AgencyGrid.Refresh()
ELSE
IF .lAdding
.AgencyGrid.Refresh()
ENDIF
ENDIF
.DisableInputs
ENDIF
>It is good practive to ALWAYS include the alias name in table operations (like you are already doing in REQUERY(). IOW,
>
>TABLEUPDATE(0,.F.,"LV_AgenciesUPdate")
>TABLEREVERT(.T.,"LV_AgenciesUPdate")
>
>This way, we know for sure which cursors are being operated on. It looks to me like that is the problem; oyu have tred to TABLEREVERT() a different cursor tan you think you are.
>
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement