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