Re: Pb while closing ADO query
- From: "Michael Jacobs" <iq193@xxxxxxxxxxxxx>
- Date: Fri, 28 Oct 2005 15:59:11 -0400
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
>> >
>> >
>>
>>
>
>
.
- Follow-Ups:
- Re: Pb while closing ADO query
- From: Bala
- Re: Pb while closing ADO query
- References:
- Pb while closing ADO query
- From: Bala
- Re: Pb while closing ADO query
- From: Michael Jacobs
- Re: Pb while closing ADO query
- From: Bala
- Pb while closing ADO query
- Prev by Date: Re: Delphi BPL ADO : You do not have an appropriate license to use this functionality.
- Next by Date: Re: Pb while closing ADO query
- Previous by thread: Re: Pb while closing ADO query
- Next by thread: Re: Pb while closing ADO query
- Index(es):
Relevant Pages
|