Click here to Skip to main content
15,915,324 members
Home / Discussions / C / C++ / MFC
   

C / C++ / MFC

 
GeneralRe: color information Pin
FarPointer19-Jun-06 5:01
FarPointer19-Jun-06 5:01 
AnswerRe: color information Pin
Viorel.19-Jun-06 4:05
Viorel.19-Jun-06 4:05 
GeneralRe: color information Pin
yogendra kaushik19-Jun-06 4:25
yogendra kaushik19-Jun-06 4:25 
AnswerRe: color information Pin
Maximilien19-Jun-06 4:06
Maximilien19-Jun-06 4:06 
AnswerRe: [Message Deleted] Pin
toxcct19-Jun-06 5:06
toxcct19-Jun-06 5:06 
QuestionQuestion on SAPI Pin
Kiran Pinjala19-Jun-06 3:26
Kiran Pinjala19-Jun-06 3:26 
AnswerRe: Question on SAPI Pin
Viorel.19-Jun-06 4:13
Viorel.19-Jun-06 4:13 
Questionproblem with Open of a query to a recordset Pin
SWDevil19-Jun-06 2:58
SWDevil19-Jun-06 2:58 
Hi,

I have an application in which I am loading data from a database (in this specific case a large database) into a grid in my GUI. So, I open the query into a recordset using the Open method as follows:

sQuery.Format(_T("SELECT DISTINCT D.fieldA, DC.fieldB
from TableDC DC, TableD D
WHERE D.fieldA = DC.fieldA AND D.No = '3’
ORDER BY DC.fieldB"));

if(!Open(AFX_DB_USE_DEFAULT_TYPE, sQuery, CRecordset::readOnly))
{
...
}

The problem is that the statement that contains the call to the Open method sometimes takes about 2 minutes to execute (and sometimes works ok).
Anyone have any idea of why this happens? And maybe an idea of how I can fix it (speed it up)?


QuestionRe: problem with Open of a query to a recordset Pin
David Crow19-Jun-06 3:12
David Crow19-Jun-06 3:12 
AnswerRe: problem with Open of a query to a recordset Pin
SWDevil19-Jun-06 4:15
SWDevil19-Jun-06 4:15 
GeneralRe: problem with Open of a query to a recordset Pin
David Crow19-Jun-06 5:40
David Crow19-Jun-06 5:40 
GeneralRe: problem with Open of a query to a recordset Pin
SWDevil19-Jun-06 10:04
SWDevil19-Jun-06 10:04 
QuestionRe: problem with Open of a query to a recordset Pin
David Crow19-Jun-06 10:24
David Crow19-Jun-06 10:24 
AnswerRe: problem with Open of a query to a recordset Pin
Viorel.19-Jun-06 3:15
Viorel.19-Jun-06 3:15 
GeneralRe: problem with Open of a query to a recordset Pin
SWDevil19-Jun-06 10:06
SWDevil19-Jun-06 10:06 
GeneralRe: problem with Open of a query to a recordset Pin
David Crow19-Jun-06 10:22
David Crow19-Jun-06 10:22 
GeneralRe: problem with Open of a query to a recordset Pin
Milton Karimbekallil19-Jun-06 21:32
Milton Karimbekallil19-Jun-06 21:32 
QuestionRestore after HIDE? Pin
ROWALI19-Jun-06 2:52
ROWALI19-Jun-06 2:52 
AnswerRe: Restore after HIDE? Pin
Rage19-Jun-06 3:14
professionalRage19-Jun-06 3:14 
AnswerRe: Restore after HIDE? Pin
Randor 19-Jun-06 3:18
professional Randor 19-Jun-06 3:18 
AnswerRe: Restore after HIDE? Pin
Eytukan19-Jun-06 3:56
Eytukan19-Jun-06 3:56 
AnswerRe: Restore after HIDE? Pin
Sarath C19-Jun-06 4:44
Sarath C19-Jun-06 4:44 
QuestionI need suggestion on dealing with char terminator in packet Pin
zhangbaodi19-Jun-06 2:43
zhangbaodi19-Jun-06 2:43 
AnswerRe: I need suggestion on dealing with char terminator in packet Pin
NiceNaidu19-Jun-06 2:55
NiceNaidu19-Jun-06 2:55 
GeneralRe: I need suggestion on dealing with char terminator in packet Pin
Randor 19-Jun-06 3:00
professional Randor 19-Jun-06 3:00 

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.