Re: Pb while closing ADO query

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: OT: anger-fest thread
    ...  I know he is trolling with regards to ... I see you have changed your tune with regards to outsider - I did ... he picks on Michael and you jump in. ...
    (alt.support.diabetes)
  • Re: Cannot start Cluster Resources
    ... Regards ... "Michael P. Schieferer" wrote: ... >> we have a 2-Node Cluster here wich running Exchange, File and DHCP ...
    (microsoft.public.windows.server.clustering)
  • Re: putty and SuSE and OpenSSH2 without password
    ... >>> regards ... >>> Michael ... > in the putty-help it should only be no write permissions for group/other. ... William Hooper ...
    (comp.security.ssh)
  • Re: Chart with Month-Scale, MajorUnitScale
    ... They are TickMarkUnitType, TickMarkSpacing, ... TickLabelUnitType and TickLabelSpacing! ... Regards ... Michael ...
    (microsoft.public.office.developer.web.components)
  • Re: Detecting a dead proxy to a remote object
    ... Michael ... >> calling a method on the proxy? ... >> service itself is the remote object. ... >> Regards, ...
    (microsoft.public.dotnet.framework.remoting)