|||||||||| ADO : PROBLEM WITH MoveFirst AND EndOfFile under Visual C++ 6.0 ||||||||||| 
Author Message
 |||||||||| ADO : PROBLEM WITH MoveFirst AND EndOfFile under Visual C++ 6.0 |||||||||||

Hi every body

I have a problem with this instruction :
....
 ....
 _RecordsetPtr MyRecord;

 MyRecord.CreateInstance(__uuidof(Recordset));
 pConnection->CommandTimeout =0;

MyRecord->Open(strSQL,MyConnection.pConnection.GetInterfacePtr(),adOpenDynam
ic,adLockOptimistic,adCmdText);
 ....

There is no problem with the execution of sql query,
BUT if i try this :

MyRecord ->MoveFirst();
While (!MyRecord->EndOfFile )
{

Quote:
}

it's take about 6 minutes to execute. Finally do nothing (???)

Is there any problem with my instructions??

I use Visual C++ 6.0  and ADO 1.5

Thanks in advance



Mon, 11 Nov 2002 03:00:00 GMT  
 |||||||||| ADO : PROBLEM WITH MoveFirst AND EndOfFile under Visual C++ 6.0 |||||||||||

Quote:

>Hi every body

>I have a problem with this instruction :
>....
> ....
> _RecordsetPtr MyRecord;

> MyRecord.CreateInstance(__uuidof(Recordset));
> pConnection->CommandTimeout =0;

>MyRecord->Open(strSQL,MyConnection.pConnection.GetInterfacePtr(),adOpenDynam
>ic,adLockOptimistic,adCmdText);
> ....

>There is no problem with the execution of sql query,
>BUT if i try this :

>MyRecord ->MoveFirst();
>While (!MyRecord->EndOfFile )
>{

// I work in Dao and the first line look as if it is a dao command.
\why don't you try (!MyRecord->IsEOF())

- Show quoted text -

Quote:
>}

>it's take about 6 minutes to execute. Finally do nothing (???)

>Is there any problem with my instructions??

>I use Visual C++ 6.0  and ADO 1.5

>Thanks in advance



Tue, 12 Nov 2002 03:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Problem with Visual Studio 6.0 (Visual C++ 6.0) !!!!

2. Using ADO in Visual C++ 6.0

3. Visual C++ .NET reviews, comparisons to Visual C++ 6.0

4. Visual C++ 6.0 vs. Visual C++ .NET

5. Visual C++ 6.0 contra Visual C++ Technology Preview IE4

6. DoModal Visual C++ 6.0 and Visual C++ .NET?

7. Visual C++ 6.0 contra Visual C++ Technology Preview IE4

8. Is there a way to merge visual C++ 6.0 and Embedded visual C++ 4.0

9. Problems with launching of Visual C++ 6.0

10. Accessing OLE DB Interfaces from Visual C++ 6.0 Problem

11. stdio Problems In Visual C++ 6.0

12. Visual Studio/C++ 6.0 problems

 

 
Powered by phpBB® Forum Software