ATL / WTL / STL

Write a C
 Program to find the survivor in a "7 up" game.
   In the game, a group of people stand in a circle,and start counting from 1 in a clockwise direction.
   The person who has to say "7" goes out, and the person next to him starts counting from 1 again.
   This goes on until only one person remains, and he is survivor. Your goal is,
   given the size of the group find out the place(Index) in which a person has to stand for him to become the survivor

I have a very general question on database migration. Am pretty new to database development and have no ideas at all, so please bear with me.

I am working on a VC++ MFC application using Visual Studio. This has a Oracle backend database.

There's a table called T_SIGN_IN that has the following columns,

1. USR_NAME
2. USR_ID
3. USR_ACCT_NUMBER
4. USR_ADDRESS
5. USR_SSN
6. USR_LAST_LOG_IN
7. USR_LAST_LOG_OFF
............and so on...

Now as part of a new feature enhancement, we want to create a new table called T_SIGN_LOG and migrate some of the existing column data from T_SIGN_IN.

For e.g., we want to move data from USR_ID, USR_LAST_LOG_IN and USR_LAST_LOG_OFF to the new table.

How can this be achieved?

I hear that there're 2 ways of achieving this.

1. Stored Procedures.
2. C++ function.

Can someone give me a example of how this can be done via the above 2 approaches? Code snippet will be great!

And also, which is the best way of doing it?

Quote:

#include "E:\CODE\Common_Utilities\Common_Utilities\Common_Utilities.h"

Quote:

Error 1 error LNK2019: unresolved external symbol "__declspec(dllimport) void __cdecl Get_Text_For_Error_Code(unsigned long,wchar_t *,unsigned int)" (__imp_?Get_Text_For_Error_Code@@YAXKPA_WI@Z) referenced in function _wmain E:\CODE\Common_Utilities\Test_Get_Text_For_Error_Code\Test_Get_Text_For_Error_Code.obj Test_Get_Text_For_Error_Code

typedef struct tagXYZHANDLE {} * XYZHANDLE;