|
View previous topic :: View next topic
|
| Author |
Message |
revathi
New User
Joined: 07 Mar 2005
Posts: 3
|
|
|
|
 how can we find out recently updated records in a table? |
|
| Back to top |
|
 |
chandramouli.v
New User
Joined: 21 Mar 2005
Posts: 12
|
|
|
|
| By checking the values in SQLCA u can find the updated records |
|
| Back to top |
|
|
sivatechdrive
Active User
.jpg)
Joined: 17 Oct 2004
Posts: 191
Location: hyderabad
|
|
|
|
Hi revathi
u can check the SQLERRD(3) field of SQLCA,which gives the details of number of rows effected becouse of previous command....
Otherway is in most of the applications we will have a timestamp field in the table or whenever we make any updates to the columns,we also set the timestamp to the current value....
Cheers
Siva |
|
| Back to top |
|
|
|
|
