Re: Pb while closing ADO query

Hi Michael,

Thanks again. I am out of station right now and would be back only on 4th
Nov. I have to check up with our system guy. But if I remember, no patch or
updates are installed. Currently we are using SQL Server 2000 Dev edition.

Regards,
Bala

"Michael Jacobs" <iq193@xxxxxxxxxxxxx> wrote in message
news:4362905c$1@xxxxxxxxxxxxxxxxxxxxxxxxx
> is your SQL Server current with patches and service packs. Also which
> version of MDAC (Microsoft Data Access Components) is installed on your
> system?
>
> Regards,
>
> Michael
>
> "Bala" <bkarat@xxxxxxxx> wrote in message
> news:436222fb@xxxxxxxxxxxxxxxxxxxxxxxxx
> > 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
> >> >
> >> >
> >>
> >>
> >
> >
>
>


.

Relevant Pages

  • Re: Modifying data in complex type
    ... Michael ... > Sorry I didn't mention that...I am using SQL Server 2005. ... > node in a larger Xml Document stored in a SQL Server 2005 table of typed ... >> Best regards ...
    (microsoft.public.sqlserver.xml)
  • Re: D5 with ADO
    ... With best regards, ... Bala ... > Any problem expected in using D5 with ADO to connect SQL Server 2000? ...
    (borland.public.delphi.database.ado)
  • Re: Timeout Expired Error
    ... Bala wrote: ... > when the number of records in the table is large (Delphi 5 and SQL ... I haven't worked with SQL Server but, ... Best regards:) ...
    (borland.public.delphi.database.ado)
  • Re: importing xml
    ... SQL Server 7 has no such support. ... You may find some third party tool that ... Best regards ... Michael ...
    (microsoft.public.sqlserver.xml)
  • Re: Settings files
    ... What I am saying is that this is a file name your application is using ... (it is not something that SQL Server uses) ... >> Best regards ...
    (microsoft.public.sqlserver.xml)