How does SETCURRENTKEY() work?

I have the following questions:

  1. What does SETCURRENTKEY actually do? How does it work?
  2. What is the benefit of SETCURRENTKEY?
  3. Why would I use SETCURRENTKEY?
  4. When would I use SETCURRENTKEY? In a combination with something?
  5. What is the advantage of using an index and how do I tie this analogously to
    the example of an old sorting system of a library?
  6. What type of database querying efficiency problems does this function solve?

The Navision IT Pro Developer Help documentation has not been helpful for me.

Thanks

Are you using the SQL or Native database? The answers to your questions depend.

Do you have a specific situation here, or these just questions on a test?

Welcome To DUG!!!

Look at the following link straight from MSDN which might help you.

http://msdn.microsoft.com/en-us/library/dd354942.aspx