Click here to Skip to main content
16,005,734 members
Home / Discussions / C / C++ / MFC
   

C / C++ / MFC

 
GeneralRe: varaint type conversion Pin
John Smith7-Sep-01 5:54
John Smith7-Sep-01 5:54 
GeneralRe: varaint type conversion Pin
Rashid Thadha8-Sep-01 3:44
Rashid Thadha8-Sep-01 3:44 
GeneralRe: varaint type conversion Pin
Carlos Antollini7-Sep-01 4:46
Carlos Antollini7-Sep-01 4:46 
GeneralA free cool year calendar with Full MFC Source code Pin
7-Sep-01 3:39
suss7-Sep-01 3:39 
Generalyeah, for $$$ Pin
Chris Losinger7-Sep-01 4:06
professionalChris Losinger7-Sep-01 4:06 
GeneralRe: yeah, for $$$ Pin
Darren Schroeder10-Sep-01 15:23
Darren Schroeder10-Sep-01 15:23 
GeneralBitmap Help Pin
7-Sep-01 3:17
suss7-Sep-01 3:17 
GeneralADO stored procedure call Pin
7-Sep-01 3:09
suss7-Sep-01 3:09 
i want to get a recordset from server database using ADO command which calls stored procedure.

the subroutine source code is following...
with a global connection and a global recordset pointer,

////////////////////////
try
{
_CommandPtr pCommand ;
HRESULT hr = pCommand.CreateInstance( __uuidof(Command) );
if( FAILED(hr) ) return FALSE;

pCommand->ActiveConnection = GetConnection();
pCommand->CommandText = proc; // stored procedure parameter : @roomNo smallint
pCommand->CommandType = adCmdStoredProc;

pRecordset = pCommand->Execute( NULL, argv, adCmdStoredProc );
// pRecordset->Open((IDispatch *) pCommand, argv, adOpenStatic,adLockOptimistic, CmdStoredProc);
}
catch(...)
/////////////////////////

when returns from the above subroutine, the global recordset becomes closed.
so, can not get a record by using pRecordset->GetCollect(0L).
why this occurs ????
somebody help me.....
thanks in advance.

GeneralRe: ADO stored procedure call Pin
Rashid Thadha8-Sep-01 3:53
Rashid Thadha8-Sep-01 3:53 
GeneralI need help with an arrogant CFile Pin
7-Sep-01 1:20
suss7-Sep-01 1:20 
GeneralRe: I need help with an arrogant CFile Pin
[James Pullicino]7-Sep-01 1:54
[James Pullicino]7-Sep-01 1:54 
GeneralRe: I need help with an arrogant CFile Pin
7-Sep-01 2:04
suss7-Sep-01 2:04 
GeneralRe: I need help with an arrogant CFile Pin
tanin8-Sep-01 7:29
tanin8-Sep-01 7:29 
GeneralUsing IE for a project Pin
sleater7-Sep-01 1:07
sleater7-Sep-01 1:07 
GeneralRe: Using IE for a project Pin
Masaaki Onishi7-Sep-01 4:04
Masaaki Onishi7-Sep-01 4:04 
GeneralRe: Using IE for a project Pin
7-Sep-01 16:57
suss7-Sep-01 16:57 
GeneralProcess Control Pin
Steve Thresher7-Sep-01 0:08
Steve Thresher7-Sep-01 0:08 
GeneralRe: Process Control Pin
[James Pullicino]7-Sep-01 1:08
[James Pullicino]7-Sep-01 1:08 
GeneralRe: Process Control Pin
tanin8-Sep-01 7:41
tanin8-Sep-01 7:41 
GeneralFreezing a list control Pin
v_krishnan6-Sep-01 23:14
v_krishnan6-Sep-01 23:14 
GeneralRe: Freezing a list control Pin
[James Pullicino]7-Sep-01 1:51
[James Pullicino]7-Sep-01 1:51 
GeneralRe: Freezing a list control Pin
ORi x7-Sep-01 2:00
ORi x7-Sep-01 2:00 
GeneralRe: Freezing a list control Pin
v_krishnan7-Sep-01 23:13
v_krishnan7-Sep-01 23:13 
GeneralMSXML DOM question Pin
jkgh6-Sep-01 23:12
jkgh6-Sep-01 23:12 
GeneralMissing Scroll Bars - OLE embedding Pin
AJ1236-Sep-01 22:29
AJ1236-Sep-01 22:29 

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.