Re: Pb while closing ADO query
- From: "Bala" <bkarat@xxxxxxxx>
- Date: Fri, 28 Oct 2005 18:39:07 +0530
Thanks Michael
We installed the ADO upgrade for Delphi 5 and the ADO update 2; that's it.
Anything else to be updated?
Regards,
Bala
"Michael Jacobs" <iq193@xxxxxxxxxxxxx> wrote in message
news:43621909$1@xxxxxxxxxxxxxxxxxxxxxxxxx
> 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: Brian Bushay TeamB
- Re: Pb while closing ADO query
- From: Michael Jacobs
- Re: Pb while closing ADO query
- References:
- Pb while closing ADO query
- From: Bala
- Re: Pb while closing ADO query
- From: Michael Jacobs
- Pb while closing ADO query
- Prev by Date: Re: Pb while closing ADO query
- Next by Date: Re: Help with Stored Procedure Execution Speed - Delphi 6
- Previous by thread: Re: Pb while closing ADO query
- Next by thread: Re: Pb while closing ADO query
- Index(es):
Relevant Pages
|
