Click here to Skip to main content
16,019,263 members
Home / Discussions / ATL / WTL / STL
   

ATL / WTL / STL

 
GeneralRe: How to open file with single quote in its name? Pin
liquid_27-Jul-16 8:06
liquid_27-Jul-16 8:06 
GeneralRe: How to open file with single quote in its name? Pin
Richard MacCutchan24-Jul-16 1:26
mveRichard MacCutchan24-Jul-16 1:26 
Questioncode Pin
Member 1222782612-Jun-16 21:24
Member 1222782612-Jun-16 21:24 
AnswerRe: code Pin
Jochen Arndt12-Jun-16 22:38
professionalJochen Arndt12-Jun-16 22:38 
AnswerRe: code Pin
Patrice T17-Feb-17 13:47
mvePatrice T17-Feb-17 13:47 
QuestionSending raw data to a chinese POS58 thermal printer Pin
sdancer757-Jun-16 8:42
sdancer757-Jun-16 8:42 
AnswerRe: Sending raw data to a chinese POS58 thermal printer Pin
Richard MacCutchan7-Jun-16 8:59
mveRichard MacCutchan7-Jun-16 8:59 
QuestionDatabase Migration in C++ and Oracle Pin
Donguy197611-May-16 11:30
Donguy197611-May-16 11:30 
C#
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?

AnswerRe: Database Migration in C++ and Oracle Pin
Richard MacCutchan11-May-16 20:29
mveRichard MacCutchan11-May-16 20:29 
QuestionLinking my first DLL Pin
bkelly1328-Feb-16 14:53
bkelly1328-Feb-16 14:53 
AnswerRe: Linking my first DLL Pin
Richard MacCutchan28-Feb-16 21:35
mveRichard MacCutchan28-Feb-16 21:35 
GeneralRe: Linking my first DLL Pin
bkelly1329-Feb-16 15:50
bkelly1329-Feb-16 15:50 
GeneralRe: Linking my first DLL Pin
Richard MacCutchan29-Feb-16 21:52
mveRichard MacCutchan29-Feb-16 21:52 
GeneralRe: Linking my first DLL Pin
bkelly131-Mar-16 12:46
bkelly131-Mar-16 12:46 
GeneralRe: Linking my first DLL Pin
Richard Andrew x641-Mar-16 15:01
professionalRichard Andrew x641-Mar-16 15:01 
GeneralRe: Linking my first DLL Pin
Richard MacCutchan1-Mar-16 21:58
mveRichard MacCutchan1-Mar-16 21:58 
QuestionDLL article question Resolved Pin
bkelly1327-Feb-16 11:10
bkelly1327-Feb-16 11:10 
AnswerRe: DLL article question Pin
Richard Andrew x6427-Feb-16 13:32
professionalRichard Andrew x6427-Feb-16 13:32 
GeneralRe: DLL article question Pin
bkelly1328-Feb-16 3:18
bkelly1328-Feb-16 3:18 
QuestionDLL Questions Pin
bkelly1324-Feb-16 13:34
bkelly1324-Feb-16 13:34 
AnswerRe: DLL Questions Pin
Richard Andrew x6424-Feb-16 14:17
professionalRichard Andrew x6424-Feb-16 14:17 
GeneralRe: DLL Questions Pin
Kenneth Haugland24-Feb-16 15:40
mvaKenneth Haugland24-Feb-16 15:40 
GeneralRe: DLL Questions Pin
Richard MacCutchan24-Feb-16 21:34
mveRichard MacCutchan24-Feb-16 21:34 
AnswerRe: DLL Questions Pin
Richard MacCutchan24-Feb-16 21:33
mveRichard MacCutchan24-Feb-16 21:33 
GeneralRe: DLL Questions Pin
bkelly1325-Feb-16 13:07
bkelly1325-Feb-16 13:07 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.