In a Windows app with mainly DD updates, I have a few places where I do record buffer updates with the reread and unlock command
reread table1  // does a lock and re-find of active record in buffer
move "xxx" to Table1.field1
saverecord table1
In native dataflex database one would make sure that all tables other than Table1 were filemode_readonly so they did not get effected by the lock command

When running on MS SQL database does one have to worry about that?
Or is MS SQL smart enough to know that only one record needs to be locked?

The application may have 50 or so open tables with unknown filemode states.

Thanks for your thoughts.