SQL Server 8 and Windows 2000

Bob Grime

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

SQL Server 8 and Windows 2000

Does anybody know of a work around when an empty set is returned from a
Select statement so that Close works again.
i.e.
while not Eof do
begin
...
Next;
end;
Close; - This gives an error Either Bof or Eof is True ...

Michael

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:SQL Server 8 and Windows 2000

I cannot duplicate this Bof/Eof error on NT. Is there some other code that
is trying to execute before the "Close"?

Quote

Bob Grimes <bob.gri...@sd-partners.com> wrote in message

news:39f59486_2@dnews...

Quote

> Does anybody know of a work around when an empty set is returned from a
> Select statement so that Close works again.
> i.e.
> while not Eof do
> begin
> ...
> Next;
> end;
> Close; - This gives an error Either Bof or Eof is True ...

Martijn Houtma

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:SQL Server 8 and Windows 2000

Use the last AdoExpress components update from CodeCentral.

Martijn Houtman

Quote

"Bob Grimes" <bob.gri...@sd-partners.com> wrote in message

news:39f59486_2@dnews...

Quote

> Does anybody know of a work around when an empty set is returned from a
> Select statement so that Close works again.
> i.e.
> while not Eof do
> begin
> ...
> Next;
> end;
> Close; - This gives an error Either Bof or Eof is True ...

Other Threads

1. Windows 2000, SQL Server 2000 and ADO Problem?

2. Controlling of Cache with SQL Server 7 and Delphi on Windows 2000 server

3. windows 2000 server to connect SQL server 6.5

4. Sql Server 2000 & Sql Server 7.0

5. InterBase v5.6 and InterClient support on Windows 2000 and Windows 2003 Server

6. Installing Interbase Server 6.0 on a Windows 2000 Server CLUSTER

7. Use InterBase 6.0 on Terminal Server under Windows 2000 Server

8. Upgrade from Access 2000 to SQL Server 2000 - table values are padded with spaces

9. Ms-SQL server 2000 cause MIDAS/DCOM Server Error

10. SQL server 2000 SQL problem - TOP doesn't work