Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Select * WITH 1 RECORD NEVER STOPS

3 posts in OLEDB Last posting was on 2006-10-20 20:45:08.0Z
Michael Woodard Posted on 2006-09-16 23:18:58.0Z
From: "Michael Woodard" <mawoodard@pilotcat.com>
Newsgroups: advantage.oledb
Subject: Select * WITH 1 RECORD NEVER STOPS
Date: Sat, 16 Sep 2006 18:18:58 -0500
Lines: 29
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962
NNTP-Posting-Host: 69.85.208.133
Message-ID: <450c8577@solutions.advantagedatabase.com>
X-Trace: 16 Sep 2006 17:15:03 -0700, 69.85.208.133
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!69.85.208.133
Xref: solutions.advantagedatabase.com Advantage.OLEDB:1159
Article PK: 1133680

Hello,

Is there any one else out there that has run a query that yields one record
and seen the record set be none ending? I get the same results from the
Architect and Delphi 2005 application.

The following query produces a never ending set of the same record:
select * from DataTable
where LogicalField=True
and CO='205'
order by User_ID

But the following gives the 1 record:
select TOP 1000 * from DataTable
where LogicalField=True
and CO='205'
order by User_ID

And the following gives the number of records in the set, 1:
select count(*) from DataTable
where LogicalField=True
and CO='205'

DB Server is Advantage DB 7.1, Application using Advantage OLE DB 7.1,
Application developed with Delphi 2005, Advantage Architect 7.10.0.3

Michael


Jeremy Mullin Posted on 2006-09-18 14:12:30.0Z
Date: Mon, 18 Sep 2006 14:12:30 +0000 (UTC)
Message-ID: <886edc1519f478c8a911527bfb8d@devzone.advantagedatabase.com>
From: Jeremy Mullin <no@email.com>
Subject: Re: Select * WITH 1 RECORD NEVER STOPS
Newsgroups: Advantage.OLEDB
References: <450c8577@solutions.advantagedatabase.com>
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
Content-Type: text/plain; charset=iso-8859-1; format=flowed
X-Newsreader: JetBrains Omea Reader 928.2
NNTP-Posting-Host: 10.24.38.116
X-Trace: 18 Sep 2006 08:08:34 -0700, 10.24.38.116
Lines: 32
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!10.24.38.116
Xref: solutions.advantagedatabase.com Advantage.OLEDB:1160
Article PK: 1133681

Shot in the dark here: Have you tried reindexing?

J.D. Mullin
Advantage R&D

> Hello,
>
> Is there any one else out there that has run a query that yields one
> record and seen the record set be none ending? I get the same results
> from the Architect and Delphi 2005 application.
>
> The following query produces a never ending set of the same record:
> select * from DataTable
> where LogicalField=True
> and CO='205'
> order by User_ID
> But the following gives the 1 record:
> select TOP 1000 * from DataTable
> where LogicalField=True
> and CO='205'
> order by User_ID
> And the following gives the number of records in the set, 1:
> select count(*) from DataTable
> where LogicalField=True
> and CO='205'
> DB Server is Advantage DB 7.1, Application using Advantage OLE DB 7.1,
> Application developed with Delphi 2005, Advantage Architect 7.10.0.3
>
> Michael
>


Michael Woodard Posted on 2006-10-20 20:45:08.0Z
From: "Michael Woodard" <mawoodard@pilotcat.com>
Newsgroups: Advantage.OLEDB
References: <450c8577@solutions.advantagedatabase.com> <886edc1519f478c8a911527bfb8d@devzone.advantagedatabase.com>
Subject: Re: Select * WITH 1 RECORD NEVER STOPS
Date: Fri, 20 Oct 2006 15:45:08 -0500
Lines: 41
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.2962
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: 69.85.208.133
Message-ID: <45393464@solutions.advantagedatabase.com>
X-Trace: 20 Oct 2006 14:41:08 -0700, 69.85.208.133
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!69.85.208.133
Xref: solutions.advantagedatabase.com Advantage.OLEDB:1173
Article PK: 1133694

Hello,

I have not, but I will.

Michael Woodard

"Jeremy Mullin" <no@email.com> wrote in message
news:886edc1519f478c8a911527bfb8d@devzone.advantagedatabase.com...
> Shot in the dark here: Have you tried reindexing?
>
> J.D. Mullin
> Advantage R&D
>
>> Hello,
>>
>> Is there any one else out there that has run a query that yields one
>> record and seen the record set be none ending? I get the same results
>> from the Architect and Delphi 2005 application.
>>
>> The following query produces a never ending set of the same record:
>> select * from DataTable
>> where LogicalField=True
>> and CO='205'
>> order by User_ID
>> But the following gives the 1 record:
>> select TOP 1000 * from DataTable
>> where LogicalField=True
>> and CO='205'
>> order by User_ID
>> And the following gives the number of records in the set, 1:
>> select count(*) from DataTable
>> where LogicalField=True
>> and CO='205'
>> DB Server is Advantage DB 7.1, Application using Advantage OLE DB 7.1,
>> Application developed with Delphi 2005, Advantage Architect 7.10.0.3
>>
>> Michael
>>
>
>