Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Problems with update sql
Message
 
 
À
15/01/2001 13:16:12
Héctor Lizarraga
Gobierno Del Edo de Querétaro
Querétaro, Mexique
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00463855
Message ID:
00463863
Vues:
13
>UPDATE Checkinc ;
>SET Checkinc.Paga = qryIncidePago.Paga, ;
>Checkinc.MinDP = qryIncidePago.MinDP, ;
>Checkinc.RefDP = qryIncidePago.RefDP, ;
>Checkinc.Usr = thisform.UsuarioWin, ;
>Checkinc.Fec_mov = Date() ;
>WHERE Checkinc.Uid = qryIncidePago.Uid
>
>the thing is that only the current record is updated, why? Is not suposed that this will update all the records that meet the condition?

Hola, Héctor.

Isn't Checkinc.Uid a primary key that identifies the record uniquely. I know is doesn't seem so for what you said, but the field name is pretty suspicious.

Are you sure that you have many records with the same UID?
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform