
|||||||||| 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())
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