Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problems with update sql
Message
From
15/01/2001 13:29:49
 
 
To
15/01/2001 13:16:12
Héctor Lizarraga
Gobierno Del Edo de Querétaro
Querétaro, Mexico
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00463855
Message ID:
00463863
Views:
12
>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?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform