General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Problems with update sql
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only