Re: Pb while closing ADO query
- From: "Michael Jacobs" <iq193@xxxxxxxxxxxxx>
- Date: Fri, 28 Oct 2005 08:26:47 -0400
Do you have the updates for ADO and MDAC installed on your system?
HTH,
Michael
"Bala" <bkarat@xxxxxxxx> wrote in message
news:4361f7f5@xxxxxxxxxxxxxxxxxxxxxxxxx
> Hi !
>
> We are using Delphi 5.0 with SQL Server. Using ADO Connection Command for
> accessing database, TADO query and TADO Dataset component for accessing
> Table data.
>
>
>
> We are facing the following problem, when ADO Query or ADO Dataset record
> is
> blank (ie Record Count = 0) and try to Close or set Active = False, it
> shows
> the error:
>
>
>
> " Either BOF or EOF is True, or the current record has been deleted.
> Requested operation requires a current record "
>
>
>
> Coding is as below:
>
>
>
> qryDisplay.Active := False; //This statement returns Error Message when
> executed for
>
> //second time
>
> qryDisplay.SQL.Clear;
>
> qryDisplay.SQL.Text := 'Select * From TempCustomers';
>
> qryDisplay.Active := True;
>
> if qryDisplay.RecordCount > 0 Then
>
> Begin
>
> while qryDisplay.RecNo <= 5 do
>
> begin
>
> ShowMessage(qryDisplay.FieldValues['CustName']);
>
> qryDisplay.Next;
>
> end;
>
> End;
>
>
>
> Someone pl help
>
>
>
> Regards,
>
> Bala
>
>
.
- Follow-Ups:
- Re: Pb while closing ADO query
- From: Bala
- Re: Pb while closing ADO query
- References:
- Pb while closing ADO query
- From: Bala
- Pb while closing ADO query
- Prev by Date: Re: Two tiers on the net
- Next by Date: Re: Pb while closing ADO query
- Previous by thread: Pb while closing ADO query
- Next by thread: Re: Pb while closing ADO query
- Index(es):
Relevant Pages
|
