Click here to Skip to main content
12,446,146 members (52,508 online)
   

Database

 
GeneralRe: Copy a tables to another database (Flashdisk) Pin
Richard.Berry10018-Oct-12 12:40
memberRichard.Berry10018-Oct-12 12:40 
GeneralRe: Copy a tables to another database (Flashdisk) Pin
mark merrens18-Oct-12 13:14
membermark merrens18-Oct-12 13:14 
GeneralRe: Copy a tables to another database (Flashdisk) Pin
Richard.Berry10018-Oct-12 14:10
memberRichard.Berry10018-Oct-12 14:10 
AnswerCreate small db, then use backup PinPopular
David Mujica19-Oct-12 6:21
memberDavid Mujica19-Oct-12 6:21 
GeneralRe: Create small db, then use backup Pin
Marcus Kramer19-Oct-12 6:43
memberMarcus Kramer19-Oct-12 6:43 
GeneralRe: Create small db, then use backup Pin
Richard.Berry10025-Oct-12 5:55
memberRichard.Berry10025-Oct-12 5:55 
Question10g to 11g migration. Pin
vanikanc17-Oct-12 7:44
membervanikanc17-Oct-12 7:44 
AnswerRe: 10g to 11g migration. Pin
Eddy Vluggen17-Oct-12 9:31
memberEddy Vluggen17-Oct-12 9:31 
QuestionHow to access window ? Pin
nghia09t317-Oct-12 5:27
membernghia09t317-Oct-12 5:27 
AnswerRe: How to access window ? Pin
Eddy Vluggen17-Oct-12 9:32
memberEddy Vluggen17-Oct-12 9:32 
GeneralRe: How to access window ? Pin
nghia09t317-Oct-12 12:47
membernghia09t317-Oct-12 12:47 
AnswerRe: How to access window ? Pin
Richard Andrew x6417-Oct-12 14:06
memberRichard Andrew x6417-Oct-12 14:06 
GeneralRe: How to access window ? Pin
nghia09t317-Oct-12 14:29
membernghia09t317-Oct-12 14:29 
QuestionDatabase to C++ Pin
shiftwik16-Oct-12 16:21
membershiftwik16-Oct-12 16:21 
hey, noob here

I'm reading some database queries into a structure in C++
The database class I'm using MFC CDatabase/CRecordset reads all the data as type strings.

So my questions are:

What is the best practice for storing the fields? should I convert them to their appropriate data type as I read them from the data base,(using CODBCFieldInfo) to determine the datatype?

or is their a class that exists that already does converts the query to a structure automatically in C++?

what is the preferred method for handling datatypes for ma database?
AnswerRe: Database to C++ Pin
Jochen Arndt16-Oct-12 21:21
memberJochen Arndt16-Oct-12 21:21 
Questionsubquery using 1 table Pin
john john mackey16-Oct-12 7:26
memberjohn john mackey16-Oct-12 7:26 
AnswerRe: subquery using 1 table Pin
Marcus Kramer16-Oct-12 8:01
memberMarcus Kramer16-Oct-12 8:01 
GeneralRe: subquery using 1 table Pin
john john mackey16-Oct-12 9:50
memberjohn john mackey16-Oct-12 9:50 
AnswerRe: subquery using 1 table Pin
Michael Potter16-Oct-12 10:38
memberMichael Potter16-Oct-12 10:38 
AnswerRe: subquery using 1 table Pin
AspDotNetDev16-Oct-12 11:25
protectorAspDotNetDev16-Oct-12 11:25 
AnswerRe: subquery using 1 table Pin
Aadhar Joshi16-Oct-12 20:28
memberAadhar Joshi16-Oct-12 20:28 
GeneralRe: subquery using 1 table Pin
john john mackey17-Oct-12 4:38
memberjohn john mackey17-Oct-12 4:38 
QuestionHigh Number of Lock Requests Pin
cjb11016-Oct-12 3:23
membercjb11016-Oct-12 3:23 
AnswerRe: High Number of Lock Requests Pin
Eddy Vluggen17-Oct-12 0:17
memberEddy Vluggen17-Oct-12 0:17 
QuestionSQL Select Where query Pin
Joe Stansfield15-Oct-12 0:37
memberJoe Stansfield15-Oct-12 0:37 
AnswerRe: SQL Select Where query Pin
Eddy Vluggen15-Oct-12 0:57
memberEddy Vluggen15-Oct-12 0:57 
GeneralRe: SQL Select Where query Pin
Joe Stansfield15-Oct-12 1:15
memberJoe Stansfield15-Oct-12 1:15 
GeneralRe: SQL Select Where query Pin
Eddy Vluggen15-Oct-12 1:22
memberEddy Vluggen15-Oct-12 1:22 
GeneralRe: SQL Select Where query Pin
Joe Stansfield15-Oct-12 1:28
memberJoe Stansfield15-Oct-12 1:28 
AnswerRe: SQL Select Where query Pin
Eddy Vluggen15-Oct-12 2:15
memberEddy Vluggen15-Oct-12 2:15 
GeneralRe: SQL Select Where query Pin
Joe Stansfield15-Oct-12 10:48
memberJoe Stansfield15-Oct-12 10:48 
GeneralRe: SQL Select Where query Pin
Marcus Kramer15-Oct-12 11:06
memberMarcus Kramer15-Oct-12 11:06 
GeneralRe: SQL Select Where query Pin
Joe Stansfield16-Oct-12 0:08
memberJoe Stansfield16-Oct-12 0:08 
GeneralRe: SQL Select Where query Pin
Eddy Vluggen16-Oct-12 0:12
memberEddy Vluggen16-Oct-12 0:12 
GeneralRe: SQL Select Where query Pin
Joe Stansfield16-Oct-12 23:04
memberJoe Stansfield16-Oct-12 23:04 
GeneralRe: SQL Select Where query Pin
Eddy Vluggen16-Oct-12 23:37
memberEddy Vluggen16-Oct-12 23:37 
GeneralRe: SQL Select Where query Pin
Member 952116716-Oct-12 22:41
memberMember 952116716-Oct-12 22:41 
GeneralRe: SQL Select Where query Pin
Simon_Whale16-Oct-12 22:52
memberSimon_Whale16-Oct-12 22:52 
GeneralRe: SQL Select Where query Pin
Rohit Shrivastava18-Oct-12 7:56
memberRohit Shrivastava18-Oct-12 7:56 
GeneralRe: SQL Select Where query Pin
Joe Stansfield15-Oct-12 1:20
memberJoe Stansfield15-Oct-12 1:20 
GeneralRe: SQL Select Where query Pin
Eddy Vluggen15-Oct-12 1:25
memberEddy Vluggen15-Oct-12 1:25 
AnswerRe: SQL Select Where query Pin
Nidhisha Biju15-Oct-12 1:05
memberNidhisha Biju15-Oct-12 1:05 
GeneralRe: SQL Select Where query Pin
Eddy Vluggen15-Oct-12 1:26
memberEddy Vluggen15-Oct-12 1:26 
AnswerRe: SQL Select Where query Pin
Aadhar Joshi16-Oct-12 20:47
memberAadhar Joshi16-Oct-12 20:47 
AnswerRe: SQL Select Where query Pin
HiteshDR23-Oct-12 1:06
memberHiteshDR23-Oct-12 1:06 
QuestionMS SQL didn't allow to store apostrophe( ' ) in name Pin
Azher.Cybertech15-Oct-12 0:04
memberAzher.Cybertech15-Oct-12 0:04 
AnswerRe: MS SQL didn't allow to store apostrophe( ' ) in name Pin
Eddy Vluggen15-Oct-12 0:55
memberEddy Vluggen15-Oct-12 0:55 
AnswerRe: MS SQL didn't allow to store apostrophe( ' ) in name Pin
HiteshDR23-Oct-12 1:08
memberHiteshDR23-Oct-12 1:08 
GeneralRe: MS SQL didn't allow to store apostrophe( ' ) in name Pin
Azher.Cybertech27-Oct-12 23:34
memberAzher.Cybertech27-Oct-12 23:34 
QuestionError Running SP [SOLVED] Pin
jojoba201113-Oct-12 21:53
memberjojoba201113-Oct-12 21:53 

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.


Advertise | Privacy | Mobile
Web02 | 2.8.160811.3 | Last Updated 24 Aug 2016
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid