Click here to Skip to main content
15,747,845 members
Home / Discussions / C / C++ / MFC
   

C / C++ / MFC

 
AnswerRe: Double value precision Pin
Chuck O'Toole9-Dec-11 10:38
Chuck O'Toole9-Dec-11 10:38 
GeneralRe: Double value precision Pin
JackDingler9-Dec-11 10:42
JackDingler9-Dec-11 10:42 
AnswerRe: Double value precision Pin
Chuck O'Toole9-Dec-11 16:52
Chuck O'Toole9-Dec-11 16:52 
QuestionAccess ODBC issue/question in MFC Application CDatabase Class Pin
MacRaider46-Dec-11 9:06
MacRaider46-Dec-11 9:06 
QuestionRe: Access ODBC issue/question in MFC Application CDatabase Class Pin
David Crow7-Dec-11 6:17
David Crow7-Dec-11 6:17 
AnswerRe: Access ODBC issue/question in MFC Application CDatabase Class Pin
MacRaider47-Dec-11 6:47
MacRaider47-Dec-11 6:47 
AnswerRe: Access ODBC issue/question in MFC Application CDatabase Class Pin
MacRaider47-Dec-11 7:27
MacRaider47-Dec-11 7:27 
AnswerRe: Access ODBC issue/question in MFC Application CDatabase Class Pin
jkirkerx7-Dec-11 8:38
professionaljkirkerx7-Dec-11 8:38 
I'm not an SQL Expert, but in theory and based on my experience, You want to write SQL commands that does everything you need in 1 command execute, and just assume it worked or write more sql to return a reply.

So a conditional SQL Command based on certain parameters being met could look something like below.

SQL
IF (SELECT PARAM.param INTO CHKPARAM FROM PARAM WHERE PARAM.param = 'Y')
BEGIN
SELECT TOP 1 * FROM CHKPARAM
END


You should never have to sleep or wait for an anwser, for the underlying sql client inside the OBDC wrapper should take care of the timing, or socket/pipe and SQL Server latency, in producing your result. Are you destroying the cdw object before creating it again? Are you modeling your SQL Commands in something like EMS SQL Manager to test how long they take to process on a known good program code.



This is why I asked in a previous post of mine what others are using to talk to SQL Server, and went with the gut wrenching torture of using the native sql client sqlclin10 to talk to the server. I had really bad luck using ODBC back in 2002, and will never use it again.
GeneralRe: Access ODBC issue/question in MFC Application CDatabase Class Pin
MacRaider47-Dec-11 9:24
MacRaider47-Dec-11 9:24 
GeneralRe: Access ODBC issue/question in MFC Application CDatabase Class Pin
jkirkerx7-Dec-11 10:49
professionaljkirkerx7-Dec-11 10:49 
GeneralRe: Access ODBC issue/question in MFC Application CDatabase Class Pin
MacRaider48-Dec-11 1:09
MacRaider48-Dec-11 1:09 
GeneralRe: Access ODBC issue/question in MFC Application CDatabase Class Pin
jkirkerx9-Dec-11 11:29
professionaljkirkerx9-Dec-11 11:29 
GeneralRe: Access ODBC issue/question in MFC Application CDatabase Class Pin
MacRaider412-Dec-11 1:32
MacRaider412-Dec-11 1:32 
GeneralRe: Access ODBC issue/question in MFC Application CDatabase Class Pin
jkirkerx12-Dec-11 4:20
professionaljkirkerx12-Dec-11 4:20 
QuestionTextOut/DrawText is too slow Pin
Joe Smith IX6-Dec-11 6:32
Joe Smith IX6-Dec-11 6:32 
AnswerRe: TextOut/DrawText is too slow Pin
Chris Losinger6-Dec-11 8:45
professionalChris Losinger6-Dec-11 8:45 
GeneralRe: TextOut/DrawText is too slow Pin
Albert Holguin6-Dec-11 14:34
professionalAlbert Holguin6-Dec-11 14:34 
GeneralRe: TextOut/DrawText is too slow Pin
Chris Losinger6-Dec-11 15:13
professionalChris Losinger6-Dec-11 15:13 
GeneralRe: TextOut/DrawText is too slow Pin
Albert Holguin6-Dec-11 16:00
professionalAlbert Holguin6-Dec-11 16:00 
GeneralRe: TextOut/DrawText is too slow Pin
Joe Smith IX7-Dec-11 3:10
Joe Smith IX7-Dec-11 3:10 
AnswerRe: TextOut/DrawText is too slow Pin
Software_Developer6-Dec-11 15:30
Software_Developer6-Dec-11 15:30 
AnswerRe: TextOut/DrawText is too slow Pin
JackDingler9-Dec-11 10:10
JackDingler9-Dec-11 10:10 
QuestionDesigning file processing application Pin
Member 3287156-Dec-11 4:07
Member 3287156-Dec-11 4:07 
AnswerRe: Designing file processing application Pin
Albert Holguin6-Dec-11 5:30
professionalAlbert Holguin6-Dec-11 5:30 
GeneralRe: Designing file processing application Pin
JackDingler6-Dec-11 6:17
JackDingler6-Dec-11 6:17 

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.