Click here to Skip to main content
16,012,223 members
Home / Discussions / C / C++ / MFC
   

C / C++ / MFC

 
GeneralRe: excel automation, hprocess is not closing Pin
Richard Ellis16-Jul-02 14:05
Richard Ellis16-Jul-02 14:05 
GeneralRe: excel automation, hprocess is not closing Pin
pnpfriend17-Jul-02 3:39
pnpfriend17-Jul-02 3:39 
Generalderive a class from my tree control Pin
Steve L.15-Jul-02 11:39
Steve L.15-Jul-02 11:39 
GeneralRe: derive a class from my tree control Pin
Joaquín M López Muñoz15-Jul-02 11:43
Joaquín M López Muñoz15-Jul-02 11:43 
GeneralRe: derive a class from my tree control Pin
Steve L.15-Jul-02 11:50
Steve L.15-Jul-02 11:50 
GeneralRe: derive a class from my tree control Pin
Joaquín M López Muñoz15-Jul-02 12:01
Joaquín M López Muñoz15-Jul-02 12:01 
GeneralRe: derive a class from my tree control Pin
Steve L.15-Jul-02 12:08
Steve L.15-Jul-02 12:08 
GeneralUsing CRecordset Pin
achandra00715-Jul-02 10:23
achandra00715-Jul-02 10:23 
Hi All

I am trying to connect to SQL Server using the ODBC classes. In my sql to CRecordset.Open, I provide a query which looks like:

CString sSql = "select ani from cxcu where company = ' + sCompany;

cxcu is a very large table and the query will return upward of 600k records. I am also turning on the CRecordset::useMultiRowFetch option.

What I want to do is to lookup an "ani" ( from above query ) and check if it exists in the table or not.

Would it make sense if I connected with a NULL string and then called Requery()? I am having to wait for a very long time (in excess of 15 minutes) for the CRecordset.Open(...) to complete.

What would be the best way to do this lookup of a record in amongst 600k+ using CRecordset?

Thanks
ashish

GeneralRe: Using CRecordset Pin
Ranjan Banerji15-Jul-02 11:02
Ranjan Banerji15-Jul-02 11:02 
GeneralRe: Using CRecordset Pin
achandra00715-Jul-02 11:39
achandra00715-Jul-02 11:39 
GeneralComboBoxEx with DropList style problem Pin
Maciek Niedzielski15-Jul-02 10:10
Maciek Niedzielski15-Jul-02 10:10 
QuestionHow to make invisible CEdit visisble with code? Pin
ns15-Jul-02 10:09
ns15-Jul-02 10:09 
Answernevermind - I got it! Pin
ns15-Jul-02 10:15
ns15-Jul-02 10:15 
GeneralOpening a serial COM port Pin
dorin15-Jul-02 9:47
dorin15-Jul-02 9:47 
GeneralRe: Opening a serial COM port Pin
Joaquín M López Muñoz15-Jul-02 9:58
Joaquín M López Muñoz15-Jul-02 9:58 
GeneralWeird Acception Violation :: MFC Pin
valikac15-Jul-02 9:35
valikac15-Jul-02 9:35 
GeneralRe: Weird Acception Violation :: MFC Pin
Joaquín M López Muñoz15-Jul-02 9:50
Joaquín M López Muñoz15-Jul-02 9:50 
GeneralRe: Weird Acception Violation :: MFC Pin
valikac15-Jul-02 10:45
valikac15-Jul-02 10:45 
GeneralRe: Weird Acception Violation :: MFC Pin
Joaquín M López Muñoz15-Jul-02 11:35
Joaquín M López Muñoz15-Jul-02 11:35 
GeneralRe: Weird Acception Violation :: MFC Pin
valikac15-Jul-02 12:50
valikac15-Jul-02 12:50 
GeneralRe: Solution Pin
valikac15-Jul-02 17:11
valikac15-Jul-02 17:11 
QuestionHow do you wait until a process has finihed before you start another Pin
Desmond Mardle15-Jul-02 9:17
Desmond Mardle15-Jul-02 9:17 
AnswerRe: How do you wait until a process has finihed before you start another Pin
Joaquín M López Muñoz15-Jul-02 9:21
Joaquín M López Muñoz15-Jul-02 9:21 
GeneralRe: How do you wait until a process has finihed before you start another Pin
Desmond Mardle15-Jul-02 22:00
Desmond Mardle15-Jul-02 22:00 
AnswerRe: How do you wait until a process has finihed before you start another Pin
User 842015-Jul-02 9:28
User 842015-Jul-02 9:28 

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.