Everybody knows FINDSET(TRUE) locks the table before fetches the records from a table. But my question what is the importance of the second parameter in FINDSET(TRUE,TRUE)?, Yes i know it will be used while modifying key fields. But how will it effect the key fields modification? I want to know how it works thoroughly…
I have seen the SQL Query generated for both FINFDSET(TRUE) and FINDSET(TRUE,TRUE) in 2009. But the SQL Query Results are same. I want to know what second parameter does exactly?