Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Shared Access & Updateable Views
Message
De
01/11/1999 16:41:09
Jill Derickson
Software Specialties
Saipan, CNMI
 
 
À
01/11/1999 09:14:27
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00284390
Message ID:
00285082
Vues:
21
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
Fil
Voir

Click here to load this message in the networking platform