Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problems with update sql
Message
From
15/01/2001 13:16:12
Héctor Lizarraga
Gobierno Del Edo de Querétaro
Querétaro, Mexico
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Problems with update sql
Miscellaneous
Thread ID:
00463855
Message ID:
00463855
Views:
52
Hi all, i have a simple update:

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?

Thanks in advance
Hector L.
Next
Reply
Map
View

Click here to load this message in the networking platform